Baloni za poslovne promocije, marketinške aktivnosti i ostala poslovna događanja.
Organizirarate li event, promociju proizvoda, promotivne akcijske prodaje, promovirate li svoj brend ili proizvod, baloni mogu biti zaista snažno sredstvo privlačenja novih kupaca. Zainteresirajte kupce, napravite da zastanu kod Vas i, naravno, prodajte svoje proizvode.
Baloni nisu samo za šalu, oni su i vrlo ozbiljno promotivno sredstvo, prepustite nam da vam predložimo nešto specijalno što će vam pomoći istaknuti Vaše prodajno mjesto. POGLEDAJTE GALERIJE NAŠIH RADOVA - javite nam se, pokažite što vam se sviđa, a mi ćemo vam dati ideju i za vas najbolju ponudu!
Sjedište:
Pleter vatrometi d.o.o.
Stubička 107, Zagreb
Croatia
Maloprodaja 1:
Ozaljska 45, Zagreb
Maloprodaja 2:
Nova Ves 26, Zagreb
session.client.browser ⇒ CCBot/2.0 (https://commoncrawl.org/faq/)
password_clear ⇒
groups ⇒
js_id_currency_orig ⇒ 2
js_id_currency ⇒ 2
js_history_sel_lang ⇒ hr-HR
0 ⇒ en-GB
1 ⇒ hr-HR
jshop_end_page_buy_product ⇒ /baloni/baloni-za-poslovna-dogadjanja.html
jshop_end_page_list_product ⇒ /baloni/baloni-za-poslovna-dogadjanja.html
session.token ⇒ eb25f90edae37a52a1c4babb2fbd4cd1
Application 0.000 seconds (+0.000); 0.61 MB (+0.612) - afterLoad
Application 0.057 seconds (+0.057); 5.90 MB (+5.286) - afterInitialise
Application 0.086 seconds (+0.030); 7.87 MB (+1.969) - afterRoute
Application 0.146 seconds (+0.060); 11.89 MB (+4.025) - afterDispatch
Application 0.252 seconds (+0.106); 12.91 MB (+1.014) - beforeRenderModule mod_menu (Bottom Menu)
Application 0.256 seconds (+0.005); 12.99 MB (+0.086) - afterRenderModule mod_menu (Bottom Menu)
Application 0.256 seconds (+0.000); 12.99 MB (-0.005) - beforeRenderModule mod_s5_box (Registracija i prijava)
Application 0.257 seconds (+0.001); 13.07 MB (+0.079) - beforeRenderModule mod_login (Prijava)
Application 0.261 seconds (+0.004); 13.12 MB (+0.058) - afterRenderModule mod_login (Prijava)
Application 0.261 seconds (+0.000); 13.12 MB (-0.004) - beforeRenderModule mod_s5_register (Registracija)
Application 0.269 seconds (+0.008); 13.67 MB (+0.552) - afterRenderModule mod_s5_register (Registracija)
Application 0.269 seconds (+0.000); 13.66 MB (-0.011) - beforeRenderModule mod_jshopping_cart_ext (Košarica)
Application 0.272 seconds (+0.003); 13.95 MB (+0.288) - afterRenderModule mod_jshopping_cart_ext (Košarica)
Application 0.272 seconds (+0.000); 13.89 MB (-0.061) - afterRenderModule mod_s5_box (Registracija i prijava)
Application 0.272 seconds (+0.000); 13.89 MB (+0.003) - beforeRenderModule mod_acymailing (Prijava za newsletter class=hide_800)
Application 0.288 seconds (+0.016); 14.99 MB (+1.100) - afterRenderModule mod_acymailing (Prijava za newsletter class=hide_800)
Application 0.289 seconds (+0.000); 14.96 MB (-0.031) - beforeRenderModule mod_menu (Informacije class=hide_800)
Application 0.291 seconds (+0.003); 14.98 MB (+0.018) - afterRenderModule mod_menu (Informacije class=hide_800)
Application 0.291 seconds (+0.000); 14.97 MB (-0.005) - beforeRenderModule mod_articles_popular (BLOG)
Application 0.308 seconds (+0.017); 15.38 MB (+0.406) - afterRenderModule mod_articles_popular (BLOG)
Application 0.308 seconds (+0.000); 15.28 MB (-0.097) - beforeRenderModule mod_articles_latest (Najnovije)
Application 0.317 seconds (+0.009); 15.43 MB (+0.150) - afterRenderModule mod_articles_latest (Najnovije)
Application 0.317 seconds (+0.000); 15.34 MB (-0.095) - beforeRenderModule mod_custom (Logo i adresa)
Application 0.319 seconds (+0.002); 15.35 MB (+0.009) - afterRenderModule mod_custom (Logo i adresa)
Application 0.319 seconds (+0.000); 15.34 MB (-0.002) - beforeRenderModule mod_breadcrumbs (Putanja)
Application 0.322 seconds (+0.003); 15.41 MB (+0.071) - afterRenderModule mod_breadcrumbs (Putanja)
Application 0.322 seconds (+0.000); 15.41 MB (-0.006) - beforeRenderModule mod_search (Tražilica)
Application 0.323 seconds (+0.001); 15.42 MB (+0.016) - afterRenderModule mod_search (Tražilica)
Application 0.323 seconds (+0.000); 15.42 MB (-0.007) - beforeRenderModule mod_finder (Pametna tražilica)
Application 0.342 seconds (+0.019); 15.81 MB (+0.391) - afterRenderModule mod_finder (Pametna tražilica)
Application 0.342 seconds (+0.000); 15.80 MB (-0.007) - beforeRenderModule mod_menu (Gornji izbornik)
Application 0.345 seconds (+0.003); 15.82 MB (+0.022) - afterRenderModule mod_menu (Gornji izbornik)
Application 0.363 seconds (+0.018); 15.99 MB (+0.164) - afterRender
16.1 MB (16,878,160 Bytes)
SELECT *
FROM ( SELECT *
FROM u340s_redj_redirects
WHERE ( ( ('/baloni/baloni-za-poslovna-dogadjanja.html' REGEXP BINARY fromurl)>0
AND (case_sensitive<>0)
AND (decode_url<>0)
AND (request_only<>0) ) OR ( ('/baloni/baloni-za-poslovna-dogadjanja.html' REGEXP BINARY fromurl)>0
AND (case_sensitive<>0)
AND (decode_url=0)
AND (request_only<>0) ) OR ( ('http://www.pletervatrometi.hr/baloni/baloni-za-poslovna-dogadjanja.html' REGEXP BINARY fromurl)>0
AND (case_sensitive<>0)
AND (decode_url<>0)
AND (request_only=0) ) OR ( ('http://www.pletervatrometi.hr/baloni/baloni-za-poslovna-dogadjanja.html' REGEXP BINARY fromurl)>0
AND (case_sensitive<>0)
AND (decode_url=0)
AND (request_only=0) ) OR ( ('/baloni/baloni-za-poslovna-dogadjanja.html' REGEXP fromurl)>0
AND (case_sensitive=0)
AND (decode_url<>0)
AND (request_only<>0) ) OR ( ('/baloni/baloni-za-poslovna-dogadjanja.html' REGEXP fromurl)>0
AND (case_sensitive=0)
AND (decode_url=0)
AND (request_only<>0) ) OR ( ('http://www.pletervatrometi.hr/baloni/baloni-za-poslovna-dogadjanja.html' REGEXP fromurl)>0
AND (case_sensitive=0)
AND (decode_url<>0)
AND (request_only=0) ) OR ( ('http://www.pletervatrometi.hr/baloni/baloni-za-poslovna-dogadjanja.html' REGEXP fromurl)>0
AND (case_sensitive=0)
AND (decode_url=0)
AND (request_only=0) ) )
AND published=1
ORDER BY ordering ) AS A
WHERE A.skip='' OR ( ('http://www.pletervatrometi.hr/baloni/baloni-za-poslovna-dogadjanja.html' REGEXP BINARY A.skip)=0
AND (case_sensitive<>0)
AND (decode_url<>0) ) OR ( ('http://www.pletervatrometi.hr/baloni/baloni-za-poslovna-dogadjanja.html' REGEXP BINARY A.skip)=0
AND (case_sensitive<>0)
AND (decode_url=0) ) OR ( ('http://www.pletervatrometi.hr/baloni/baloni-za-poslovna-dogadjanja.html' REGEXP A.skip)=0
AND (case_sensitive=0)
AND (decode_url<>0) ) OR ( ('http://www.pletervatrometi.hr/baloni/baloni-za-poslovna-dogadjanja.html' REGEXP A.skip)=0
AND (case_sensitive=0)
AND (decode_url=0) )
SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM u340s_menu AS m
LEFT JOIN u340s_extensions AS e
ON m.component_id = e.extension_id
WHERE m.published = 1
AND m.parent_id > 0
AND m.client_id = 0
ORDER BY m.lft
SELECT joomlatablename,tablepkID
FROM `u340s_falang_tableinfo`
SELECT *
FROM u340s_languages
ORDER BY ordering
SHOW FULL COLUMNS
FROM `u340s_languages`
SELECT extension_id AS id, element AS "option", params, enabled
FROM u340s_extensions
WHERE `type` = 'component'
AND `element` = 'com_falang'
SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
FROM u340s_falang_content AS falang_content
WHERE falang_content.language_id=2
AND falang_content.published=1
AND falang_content.reference_id IN(420,101,416,410,205,262,248,263,415,210,211,206,249,171,172,173,174,175,176,177,178,179,180,181,182,183,184,185,190,293,294,295,296,333,361,362,363,401,402,403,404,405,406,409,411,412,125,128,129,130,131,132,134,133,127,135,136,137,138,139,198,126,151,152,153,154,155,279,146,277,278,283,285,149,150,255,256,257,258,259,260,157,282,284,280,141,142,143,144,145,264,163,164,166,167,169,148,168,170,158,160,199,161,345,408,265,266,267,140,268,360,344,103,197,104,105,106,107,247,108,102,417)
AND falang_content.reference_table='menu'
SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM u340s_menu AS m
LEFT JOIN u340s_extensions AS e
ON m.component_id = e.extension_id
WHERE m.published = 1
AND m.parent_id > 0
AND m.client_id = 0
ORDER BY m.lft
SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
FROM u340s_falang_content AS falang_content
WHERE falang_content.language_id=2
AND falang_content.published=1
AND falang_content.reference_id IN(420,101,416,410,205,262,248,263,415,210,211,206,249,171,172,173,174,175,176,177,178,179,180,181,182,183,184,185,190,293,294,295,296,333,361,362,363,401,402,403,404,405,406,409,411,412,125,128,129,130,131,132,134,133,127,135,136,137,138,139,198,126,151,152,153,154,155,279,146,277,278,283,285,149,150,255,256,257,258,259,260,157,282,284,280,141,142,143,144,145,264,163,164,166,167,169,148,168,170,158,160,199,161,345,408,265,266,267,140,268,360,344,103,197,104,105,106,107,247,108,102,417)
AND falang_content.reference_table='menu'
SELECT extension_id AS id, element AS "option", params, enabled
FROM u340s_extensions
WHERE `type` = 'component'
AND `element` = 'com_jshopping'
SELECT id, home, template, s.params
FROM u340s_template_styles as s
LEFT JOIN u340s_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
WHERE s.client_id = 0
AND e.enabled = 1
SHOW FULL COLUMNS
FROM `u340s_jshopping_config`
SELECT *
FROM u340s_jshopping_config
WHERE `id` = '1'
SHOW FULL COLUMNS
FROM `u340s_jshopping_currencies`
SELECT currency_id, currency_name, currency_code, currency_code_iso, currency_value
FROM `u340s_jshopping_currencies`
WHERE currency_publish = '1'
ORDER BY currency_ordering
select *
from u340s_jshopping_languages
SHOW FULL COLUMNS
FROM `u340s_jshopping_categories`
SELECT *
FROM u340s_jshopping_categories
WHERE `category_id` = '6'
SHOW FULL COLUMNS
FROM `u340s_jshopping_vendors`
SELECT id
FROM u340s_jshopping_vendors
WHERE `main`=1
SELECT *
FROM u340s_jshopping_vendors
WHERE `id` = '1'
select id,link
from u340s_menu
where `type`='component'
and published=1
and link like '%option=com_jshopping%'
and client_id=0
and (language='*' or language='hr-HR')
and access IN (1,1)
SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
FROM u340s_falang_content AS falang_content
WHERE falang_content.language_id=2
AND falang_content.published=1
AND falang_content.reference_id IN(125,420,417,264,174,128,127,126,141,149,155,153,283,146,152,151,277,279,278,154,139,135,137,138,198,136,131,130,129,145,143,142,144,408,160,161,170,345,199,158,168,282,150,260,255,157,258,259,257,256,167,164,166,169,265,148,163,360,140,268,267,266,344)
AND falang_content.reference_table='menu'
SELECT `name_hr-HR` as name,`description_hr-HR` as description,`short_description_hr-HR` as short_description, category_id, category_publish, ordering, category_image
FROM `u340s_jshopping_categories`
WHERE category_parent_id = '6'
AND category_publish = '1'
AND access IN (1,1)
ORDER BY ordering asc
select category_id as id, `alias_hr-HR` as alias
from u340s_jshopping_categories
where `alias_hr-HR`!=''
SHOW FULL COLUMNS
FROM `u340s_jshopping_products_extra_fields`
SELECT F.id, F.`name_hr-HR` as name, F.`description_hr-HR` as description, F.allcats, F.type, F.cats, F.ordering, F.`
group`, G.`name_hr-HR` as groupname, multilist
FROM `u340s_jshopping_products_extra_fields` as F
left join `u340s_jshopping_products_extra_field_groups` as G
on G.id=F.
group
order by G.ordering, F.ordering
SHOW FULL COLUMNS
FROM `u340s_jshopping_taxes`
SELECT tax_id, tax_name, tax_value
FROM `u340s_jshopping_taxes`
SELECT count(*)
FROM `u340s_jshopping_products_to_categories` AS pr_cat
INNER JOIN `u340s_jshopping_products` AS prod
ON pr_cat.product_id = prod.product_id
WHERE pr_cat.category_id = '6'
AND prod.product_publish = '1'
AND prod.access IN (1,1)
AND prod.product_quantity > 0
SELECT count(*)
FROM `u340s_jshopping_products_to_categories` AS pr_cat
INNER JOIN `u340s_jshopping_products` AS prod
ON pr_cat.product_id = prod.product_id
WHERE pr_cat.category_id = '6'
AND prod.product_publish = '1'
AND prod.access IN (1,1)
AND prod.product_quantity > 0
SELECT prod.product_id, pr_cat.category_id, prod.`name_hr-HR` as name, prod.`short_description_hr-HR` as short_description, prod.product_ean, prod.product_thumb_image, prod.product_price, prod.currency_id, prod.product_tax_id as tax_id, prod.product_old_price, prod.product_weight, prod.average_rating, prod.reviews_count, prod.hits, prod.weight_volume_units, prod.basic_price_unit_id, prod.label_id, prod.product_manufacturer_id, prod.min_price, prod.product_quantity, prod.different_prices
FROM `u340s_jshopping_products` AS prod
LEFT JOIN `u340s_jshopping_products_to_categories` AS pr_cat USING (product_id)
WHERE pr_cat.category_id = '6'
AND prod.product_publish = '1'
AND prod.access IN (1,1)
AND prod.product_quantity > 0
ORDER BY pr_cat.product_ordering ASC
LIMIT 0, 80
SHOW FULL COLUMNS
FROM `u340s_jshopping_users`
SHOW FULL COLUMNS
FROM `u340s_jshopping_products_reviews`
CREATE TABLE IF NOT EXISTS `u340s_powr` ( `data_type` VARCHAR(50) NOT NULL, `value` VARCHAR(50) NOT NULL, PRIMARY KEY (`data_type`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SELECT value
FROM u340s_powr
WHERE data_type = 'powr_token'
SELECT extension_id AS id, element AS "option", params, enabled
FROM u340s_extensions
WHERE `type` = 'component'
AND `element` = 'com_content'
SELECT id
FROM u340s_falang_content
WHERE reference_id = 0
AND reference_table= 'content'
SELECT *
FROM u340s_template_styles
WHERE template = 'no1_shopping';
SELECT *
FROM u340s_menu
WHERE template_style_id IN (14)
AND alias = 'baloni-za-poslovna-dogadjanja'
SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
FROM u340s_falang_content AS falang_content
WHERE falang_content.language_id=2
AND falang_content.published=1
AND falang_content.reference_id IN(128)
AND falang_content.reference_table='menu'
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM u340s_modules AS m
LEFT JOIN u340s_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN u340s_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.published = 1
AND e.enabled = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2022-08-09 11:11:51')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2022-08-09 11:11:51')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 128 OR mm.menuid <= 0)
AND m.language IN ('hr-HR','*')
ORDER BY m.position, m.ordering
SELECT menutype
FROM u340s_menu
WHERE language = 'hr-HR'
AND home = 1
SELECT menutype
FROM u340s_menu
WHERE language = 'hr-HR'
AND home = 1
SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM u340s_menu AS m
LEFT JOIN u340s_extensions AS e
ON m.component_id = e.extension_id
WHERE m.published = 1
AND m.parent_id > 0
AND m.client_id = 0
ORDER BY m.lft
SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
FROM u340s_falang_content AS falang_content
WHERE falang_content.language_id=2
AND falang_content.published=1
AND falang_content.reference_id IN(420,101,416,410,205,262,248,263,415,210,211,206,249,171,172,173,174,175,176,177,178,179,180,181,182,183,184,185,190,293,294,295,296,333,361,362,363,401,402,403,404,405,406,409,411,412,125,128,129,130,131,132,134,133,127,135,136,137,138,139,198,126,151,152,153,154,155,279,146,277,278,283,285,149,150,255,256,257,258,259,260,157,282,284,280,141,142,143,144,145,264,163,164,166,167,169,148,168,170,158,160,199,161,345,408,265,266,267,140,268,360,344,103,197,104,105,106,107,247,108,102,417)
AND falang_content.reference_table='menu'
SELECT *
FROM u340s_acymailing_config
SELECT *
FROM u340s_acymailing_list
WHERE type = 'list'
ORDER BY ordering ASC
SELECT a.id,a.alias,a.catid, c.alias as catalias
FROM u340s_content as a
LEFT JOIN u340s_categories AS c
ON c.id = a.catid
WHERE a.id = 130
LIMIT 1
SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
FROM u340s_falang_content AS falang_content
WHERE falang_content.language_id=2
AND falang_content.published=1
AND falang_content.reference_id IN(130)
AND falang_content.reference_table='content'
SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
FROM u340s_falang_content AS falang_content
WHERE falang_content.language_id=2
AND falang_content.published=1
AND falang_content.reference_id IN(37)
AND falang_content.reference_table='categories'
SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM u340s_categories as c
LEFT JOIN u340s_categories AS s
ON (s.lft < c.lft
AND s.rgt > c.rgt
AND c.language in ('hr-HR','*')) OR (s.lft >= c.lft
AND s.rgt <= c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM u340s_categories AS cat JOIN u340s_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id=37
AND badcats.id is null
GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id
ORDER BY c.lft
SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
FROM u340s_falang_content AS falang_content
WHERE falang_content.language_id=2
AND falang_content.published=1
AND falang_content.reference_id IN(1,44,37)
AND falang_content.reference_table='categories'
SELECT a.rules
FROM u340s_assets AS a
WHERE (a.id = 1)
GROUP BY a.id, a.rules, a.lft
SELECT b.rules
FROM u340s_assets AS a
LEFT JOIN u340s_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE (a.name = 'com_content')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lft
SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.language, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore,
CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,(
SELECT MAX(contact.id) AS id
FROM u340s_contact_details AS contact
WHERE contact.published = 1
AND contact.user_id = a.created_by
AND (contact.language in ('hr-HR','*') OR contact.language IS NULL)) as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published,
CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
FROM u340s_content AS a
LEFT JOIN u340s_content_frontpage AS fp
ON fp.content_id = a.id
LEFT JOIN u340s_categories AS c
ON c.id = a.catid
LEFT JOIN u340s_users AS ua
ON ua.id = a.created_by
LEFT JOIN u340s_users AS uam
ON uam.id = a.modified_by
LEFT JOIN u340s_categories as parent
ON parent.id = c.parent_id
LEFT JOIN u340s_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM u340s_categories AS cat JOIN u340s_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id ) AS badcats
ON badcats.id = c.id
WHERE a.access IN (1,1)
AND c.access IN (1,1)
AND
CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2022-08-09 11:11:51')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2022-08-09 11:11:51')
AND a.language in ('hr-HR','*')
ORDER BY a.hits DESC
LIMIT 0, 6
SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
FROM u340s_falang_content AS falang_content
WHERE falang_content.language_id=2
AND falang_content.published=1
AND falang_content.reference_id IN(153,143,97,160,131,135)
AND falang_content.reference_table='content'
SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
FROM u340s_falang_content AS falang_content
WHERE falang_content.language_id=2
AND falang_content.published=1
AND falang_content.reference_id IN(36,47,44)
AND falang_content.reference_table='categories'
SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
FROM u340s_falang_content AS falang_content
WHERE falang_content.language_id=2
AND falang_content.published=1
AND falang_content.reference_id IN(36,47,44)
AND falang_content.reference_table='categories'
SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM u340s_categories as c
LEFT JOIN u340s_categories AS s
ON (s.lft < c.lft
AND s.rgt > c.rgt
AND c.language in ('hr-HR','*')) OR (s.lft >= c.lft
AND s.rgt <= c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM u340s_categories AS cat JOIN u340s_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id=36
AND badcats.id is null
GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id
ORDER BY c.lft
SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
FROM u340s_falang_content AS falang_content
WHERE falang_content.language_id=2
AND falang_content.published=1
AND falang_content.reference_id IN(1,45,36)
AND falang_content.reference_table='categories'
SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM u340s_categories as c
LEFT JOIN u340s_categories AS s
ON (s.lft < c.lft
AND s.rgt > c.rgt
AND c.language in ('hr-HR','*')) OR (s.lft >= c.lft
AND s.rgt <= c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM u340s_categories AS cat JOIN u340s_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id=47
AND badcats.id is null
GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id
ORDER BY c.lft
SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
FROM u340s_falang_content AS falang_content
WHERE falang_content.language_id=2
AND falang_content.published=1
AND falang_content.reference_id IN(1,47)
AND falang_content.reference_table='categories'
SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.language, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore,
CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,(
SELECT MAX(contact.id) AS id
FROM u340s_contact_details AS contact
WHERE contact.published = 1
AND contact.user_id = a.created_by
AND (contact.language in ('hr-HR','*') OR contact.language IS NULL)) as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published,
CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
FROM u340s_content AS a
LEFT JOIN u340s_content_frontpage AS fp
ON fp.content_id = a.id
LEFT JOIN u340s_categories AS c
ON c.id = a.catid
LEFT JOIN u340s_users AS ua
ON ua.id = a.created_by
LEFT JOIN u340s_users AS uam
ON uam.id = a.modified_by
LEFT JOIN u340s_categories as parent
ON parent.id = c.parent_id
LEFT JOIN u340s_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM u340s_categories AS cat JOIN u340s_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id ) AS badcats
ON badcats.id = c.id
WHERE a.access IN (1,1)
AND c.access IN (1,1)
AND
CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
AND a.featured = 0
AND a.catid IN (38)
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2022-08-09 11:11:51')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2022-08-09 11:11:51')
AND a.language in ('hr-HR','*')
ORDER BY a.created DESC
LIMIT 0, 6
SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
FROM u340s_falang_content AS falang_content
WHERE falang_content.language_id=2
AND falang_content.published=1
AND falang_content.reference_id IN(99,100,101,103,104,120)
AND falang_content.reference_table='content'
SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
FROM u340s_falang_content AS falang_content
WHERE falang_content.language_id=2
AND falang_content.published=1
AND falang_content.reference_id IN(38)
AND falang_content.reference_table='categories'
SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
FROM u340s_falang_content AS falang_content
WHERE falang_content.language_id=2
AND falang_content.published=1
AND falang_content.reference_id IN(38)
AND falang_content.reference_table='categories'
SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM u340s_categories as c
LEFT JOIN u340s_categories AS s
ON (s.lft < c.lft
AND s.rgt > c.rgt
AND c.language in ('hr-HR','*')) OR (s.lft >= c.lft
AND s.rgt <= c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM u340s_categories AS cat JOIN u340s_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id=38
AND badcats.id is null
GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id
ORDER BY c.lft
SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
FROM u340s_falang_content AS falang_content
WHERE falang_content.language_id=2
AND falang_content.published=1
AND falang_content.reference_id IN(1,46,38)
AND falang_content.reference_table='categories'
SELECT extension_id AS id, element AS "option", params, enabled
FROM u340s_extensions
WHERE `type` = 'component'
AND `element` = 'com_finder'
SELECT name
FROM `u340s_extensions`
WHERE `type` = 'plugin'
AND `folder` = 'finder'
AND `enabled` = 1
SELECT `title`
FROM `u340s_finder_taxonomy`
WHERE `parent_id` = 1
AND `state` = 1
AND `access` IN (1,1)
SELECT *
FROM u340s_gtm_queue
WHERE status = 'pending'
UPDATE `u340s_session`
SET `data` = '__default|a:15:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1660043511;s:18:\"session.timer.last\";i:1660043511;s:17:\"session.timer.now\";i:1660043511;s:22:\"session.client.browser\";s:40:\"CCBot/2.0 (https://commoncrawl.org/faq/)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\0*\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:19:\"js_id_currency_orig\";s:1:\"2\";s:14:\"js_id_currency\";s:1:\"2\";s:19:\"js_history_sel_lang\";s:5:\"hr-HR\";s:15:\"js_prev_user_id\";i:0;s:22:\"jshop_checked_language\";a:2:{i:0;s:5:\"en-GB\";i:1;s:5:\"hr-HR\";}s:26:\"jshop_end_page_buy_product\";s:42:\"/baloni/baloni-za-poslovna-dogadjanja.html\";s:27:\"jshop_end_page_list_product\";s:42:\"/baloni/baloni-za-poslovna-dogadjanja.html\";s:13:\"session.token\";s:32:\"eb25f90edae37a52a1c4babb2fbd4cd1\";}'
, `time` = '1660043511'
WHERE `session_id` = '64bbea6df6bcfdd97dd7b08a8956c473'
17 × SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
FROM u340s_falang_content AS falang_content
4 × SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM u340s_categories as c
LEFT JOIN u340s_categories AS s
ON (s.lft < c.lft
AND s.rgt > c.rgt
AND c.language in ('hr-HR','*')) OR (s.lft >= c.lft
AND s.rgt <= c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM u340s_categories AS cat JOIN u340s_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
4 × SELECT extension_id AS id, element AS "option", params, enabled
FROM u340s_extensions
3 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM u340s_menu AS m
LEFT JOIN u340s_extensions AS e
ON m.component_id = e.extension_id
2 × SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.language, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore,
CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,( SELECT MAX(contact.id) AS id
FROM u340s_contact_details AS contact
2 × SELECT menutype
FROM u340s_menu
2 × SELECT count(*)
FROM `u340s_jshopping_products_to_categories` AS pr_cat
INNER JOIN `u340s_jshopping_products` AS prod
ON pr_cat.product_id = prod.product_id
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM u340s_modules AS m
LEFT JOIN u340s_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN u340s_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
1 × SELECT *
FROM u340s_template_styles
1 × SELECT id
FROM u340s_falang_content
1 × SELECT *
FROM u340s_acymailing_confi
1 × SELECT *
FROM u340s_menu
1 × SELECT a.rules
FROM u340s_assets AS a
1 × SELECT `title`
FROM `u340s_finder_taxonomy`
1 × SELECT *
FROM u340s_gtm_queue
1 × SELECT name
FROM `u340s_extensions`
1 × SELECT b.rules
FROM u340s_assets AS a
LEFT JOIN u340s_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT a.id,a.alias,a.catid, c.alias as catalias
FROM u340s_content as a
LEFT JOIN u340s_categories AS c
ON c.id = a.catid
1 × SELECT value
FROM u340s_powr
1 × SELECT *
FROM u340s_acymailing_list
1 × SELECT tax_id, tax_name, tax_value
FROM `u340s_jshopping_taxes
1 × SELECT currency_id, currency_name, currency_code, currency_code_iso, currency_value
FROM `u340s_jshopping_currencies`
1 × select *
from u340s_jshopping_language
1 × SELECT *
FROM u340s_jshopping_config
1 × SELECT id, home, template, s.params
FROM u340s_template_styles as s
LEFT JOIN u340s_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
1 × SELECT joomlatablename,tablepkID
FROM `u340s_falang_tableinfo
1 × SELECT *
FROM u340s_languages
1 × SELECT *
FROM u340s_jshopping_categories
1 × SELECT id
FROM u340s_jshopping_vendors
1 × SELECT F.id, F.`name_hr-HR` as name, F.`description_hr-HR` as description, F.allcats, F.type, F.cats, F.ordering, F.`
group`, G.`name_hr-HR` as groupname, multilist
FROM `u340s_jshopping_products_extra_fields` as F
left join `u340s_jshopping_products_extra_field_groups` as G
on G.id=F.
group
1 × SELECT *
FROM ( SELECT *
FROM u340s_redj_redirects
1 × select category_id as id, `alias_hr-HR` as alias
from u340s_jshopping_categories
1 × SELECT `name_hr-HR` as name,`description_hr-HR` as description,`short_description_hr-HR` as short_description, category_id, category_publish, ordering, category_image
FROM `u340s_jshopping_categories`
1 × SELECT *
FROM u340s_jshopping_vendors
1 × select id,link
from u340s_menu
1 × SELECT prod.product_id, pr_cat.category_id, prod.`name_hr-HR` as name, prod.`short_description_hr-HR` as short_description, prod.product_ean, prod.product_thumb_image, prod.product_price, prod.currency_id, prod.product_tax_id as tax_id, prod.product_old_price, prod.product_weight, prod.average_rating, prod.reviews_count, prod.hits, prod.weight_volume_units, prod.basic_price_unit_id, prod.label_id, prod.product_manufacturer_id, prod.min_price, prod.product_quantity, prod.different_prices
FROM `u340s_jshopping_products` AS prod
LEFT JOIN `u340s_jshopping_products_to_categories` AS pr_cat USING (product_id)
1 × SHOW FULL COLUMNS
FROM `u340s_jshopping_users
1 × SHOW FULL COLUMNS
FROM `u340s_jshopping_products_reviews
1 × CREATE TABLE IF NOT EXISTS `u340s_powr` ( `data_type` VARCHAR(50) NOT NULL, `value` VARCHAR(50) NOT NULL, PRIMARY KEY (`data_type`)) ENGINE=InnoDB DEFAULT CHARSET=utf8
1 × UPDATE `u340s_session`
SET `data` = '__default|a:15:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1660043511;s:18:\"session.timer.last\";i:1660043511;s:17:\"session.timer.now\";i:1660043511;s:22:\"session.client.browser\";s:40:\"CCBot/2.0 (https://commoncrawl.org/faq/)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\0*\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:19:\"js_id_currency_orig\";s:1:\"2\";s:14:\"js_id_currency\";s:1:\"2\";s:19:\"js_history_sel_lang\";s:5:\"hr-HR\";s:15:\"js_prev_user_id\";i:0;s:22:\"jshop_checked_language\";a:2:{i:0;s:5:\"en-GB\";i:1;s:5:\"hr-HR\";}s:26:\"jshop_end_page_buy_product\";s:42:\"/baloni/baloni-za-poslovna-dogadjanja.html\";s:27:\"jshop_end_page_list_product\";s:42:\"/baloni/baloni-za-poslovna-dogadjanja.html\";s:13:\"session.token\";s:32:\"eb25f90edae37a52a1c4babb2fbd4cd1\";}' , `time` = '1660043511'
1 × SHOW FULL COLUMNS
FROM `u340s_jshopping_taxes
1 × SHOW FULL COLUMNS
FROM `u340s_jshopping_products_extra_fields
1 × SHOW FULL COLUMNS
FROM `u340s_jshopping_config
1 × SHOW FULL COLUMNS
FROM `u340s_jshopping_currencies
1 × SHOW FULL COLUMNS
FROM `u340s_jshopping_categories
1 × SHOW FULL COLUMNS
FROM `u340s_jshopping_vendors
1 × SHOW FULL COLUMNS
FROM `u340s_languages