Blog RSS Feed

SET time_zone = '+00:00'

SELECT *
FROM `oc_store`
WHERE REPLACE(`url`, 'www.', '') = 'https://gajcom.si/'

SELECT *
FROM `oc_setting`
WHERE `store_id` = '0' OR `store_id` = 0
ORDER BY `store_id` ASC

SET time_zone = '+02:00'

SELECT `data`
FROM `oc_session`
WHERE `session_id` = '3d1ad8117aa3fd756a52e5d0e5' AND `expire` > '2025-05-30 22:33:05'

SELECT *
FROM `oc_seo_url`
WHERE (`keyword` = '' OR `keyword` LIKE '%/') AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE (`keyword` = 'blog' OR `keyword` LIKE '%/blog') AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_currency`

SELECT tr1.`tax_class_id`, tr2.`tax_rate_id`, tr2.`name`, tr2.`rate`, tr2.`type`, tr1.`priority`
FROM `oc_tax_rule` tr1
LEFT JOIN `oc_tax_rate` tr2 ON (tr1.`tax_rate_id` = tr2.`tax_rate_id`)
INNER JOIN `oc_tax_rate_to_customer_group` tr2cg ON (tr2.`tax_rate_id` = tr2cg.`tax_rate_id`)
LEFT JOIN `oc_zone_to_geo_zone` z2gz ON (tr2.`geo_zone_id` = z2gz.`geo_zone_id`)
LEFT JOIN `oc_geo_zone` gz ON (tr2.`geo_zone_id` = gz.`geo_zone_id`)
WHERE tr1.`based` = 'shipping' AND tr2cg.`customer_group_id` = '1' AND z2gz.`country_id` = '190' AND (z2gz.`zone_id` = '0' OR z2gz.`zone_id` = '3963')
ORDER BY tr1.`priority` ASC

SELECT tr1.`tax_class_id`, tr2.`tax_rate_id`, tr2.`name`, tr2.`rate`, tr2.`type`, tr1.`priority`
FROM `oc_tax_rule` tr1
LEFT JOIN `oc_tax_rate` tr2 ON (tr1.`tax_rate_id` = tr2.`tax_rate_id`)
INNER JOIN `oc_tax_rate_to_customer_group` tr2cg ON (tr2.`tax_rate_id` = tr2cg.`tax_rate_id`)
LEFT JOIN `oc_zone_to_geo_zone` z2gz ON (tr2.`geo_zone_id` = z2gz.`geo_zone_id`)
LEFT JOIN `oc_geo_zone` gz ON (tr2.`geo_zone_id` = gz.`geo_zone_id`)
WHERE tr1.`based` = 'store' AND tr2cg.`customer_group_id` = '1' AND z2gz.`country_id` = '190' AND (z2gz.`zone_id` = '0' OR z2gz.`zone_id` = '3963')
ORDER BY tr1.`priority` ASC

SELECT *
FROM `oc_weight_class` wc
LEFT JOIN `oc_weight_class_description` wcd ON (wc.`weight_class_id` = wcd.`weight_class_id`)
WHERE wcd.`language_id` = '1'

SELECT *
FROM `oc_length_class` mc
LEFT JOIN `oc_length_class_description` mcd ON (mc.`length_class_id` = mcd.`length_class_id`)
WHERE mcd.`language_id` = '1'

DELETE
FROM `oc_cart`
WHERE (`api_id` > '0' OR `customer_id` = '0') AND `date_added` < DATE_SUB(NOW(), INTERVAL 1 HOUR)

SELECT DISTINCT `extension`
FROM `oc_extension`

SELECT *
FROM `oc_startup`
WHERE `status` = '1'
ORDER BY `sort_order` ASC

SELECT *
FROM `oc_cart`
WHERE `api_id` = '0' AND `customer_id` = '0' AND `session_id` = '3d1ad8117aa3fd756a52e5d0e5'

SELECT *
FROM `oc_seo_url`
WHERE (`keyword` = 'blog' OR `keyword` LIKE '%/blog') AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'journal3/blog' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_event`
WHERE `status` = '1'
ORDER BY `sort_order` ASC

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'common/home' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'language' AND `value` = 'en-gb' AND `store_id` = '0' AND `language_id` = '1'

SELECT p.post_id, p.image, p.date_created as date, p.views, pd.name, pd.description, a.username, a.firstname, a.lastname, a.email, ( SELECT count(*)
FROM `oc_journal3_blog_comments` bc
WHERE bc.status = 1 AND bc.post_id = p.post_id AND bc.parent_id = 0 ) as comments
FROM `oc_journal3_blog_post` p
LEFT JOIN `oc_journal3_blog_post_description` pd ON p.post_id = pd.post_id
LEFT JOIN `oc_journal3_blog_post_to_store` p2s ON p.post_id = p2s.post_id
LEFT JOIN `oc_user` a ON p.author_id = a.user_id
WHERE pd.language_id = '1' AND p2s.store_id = '0' AND p.date_created <= NOW() AND p.status = 1 GROUP BY p.post_id
ORDER BY p.date_created DESC LIMIT 0, 12

SELECT COUNT(*) AS total
FROM `oc_journal3_blog_post` p
LEFT JOIN `oc_journal3_blog_post_description` pd ON p.post_id = pd.post_id
LEFT JOIN `oc_journal3_blog_post_to_store` p2s ON p.post_id = p2s.post_id
WHERE pd.language_id = '1' AND p2s.store_id = '0' AND p.date_created <= NOW() AND p.status = 1

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'journal3/blog|post' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'journal_blog_post_id' AND `value` = '27' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'blog/post' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'journal_blog_post_id' AND `value` = '19' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'journal_blog_post_id' AND `value` = '21' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'journal_blog_post_id' AND `value` = '25' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'journal_blog_post_id' AND `value` = '26' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'journal_blog_post_id' AND `value` = '24' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'journal_blog_post_id' AND `value` = '10' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'journal_blog_post_id' AND `value` = '23' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'journal_blog_post_id' AND `value` = '20' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'journal_blog_post_id' AND `value` = '18' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'journal_blog_post_id' AND `value` = '17' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'journal_blog_post_id' AND `value` = '16' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/blog_posts'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'page' AND `value` = '{page}' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'extension/journal_3/common/pagination'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'page' AND `value` = '2' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'journal3/blog|feed' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_layout_route`
WHERE 'journal3/blog' LIKE `route` AND `store_id` = '0'
ORDER BY `route` DESC LIMIT 1

SELECT layout_id, layout_data
FROM `oc_journal3_layout`
WHERE `layout_id` = '15' OR `layout_id` = -1
ORDER BY `layout_id` DESC

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/blog_search'

SELECT *
FROM `oc_journal3_module`

SELECT c.category_id, cd.name
FROM `oc_journal3_blog_category` c
LEFT JOIN `oc_journal3_blog_category_description` cd ON c.category_id = cd.category_id
LEFT JOIN `oc_journal3_blog_category_to_store` c2s ON c.category_id = c2s.category_id
WHERE c.status = 1 AND cd.language_id = '1' AND c2s.store_id = '0'
ORDER BY c.sort_order

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'journal_blog_category_id' AND `value` = '6' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'journal_blog_category_id' AND `value` = '4' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'journal_blog_category_id' AND `value` = '5' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/blog_categories'

SELECT p.post_id, p.image, p.date_created as date, p.views, pd.name, pd.description, a.username, a.firstname, a.lastname, a.email, ( SELECT count(*)
FROM `oc_journal3_blog_comments` bc
WHERE bc.status = 1 AND bc.post_id = p.post_id AND bc.parent_id = 0 ) as comments
FROM `oc_journal3_blog_post` p
LEFT JOIN `oc_journal3_blog_post_description` pd ON p.post_id = pd.post_id
LEFT JOIN `oc_journal3_blog_post_to_store` p2s ON p.post_id = p2s.post_id
LEFT JOIN `oc_user` a ON p.author_id = a.user_id
WHERE pd.language_id = '1' AND p2s.store_id = '0' AND p.date_created <= NOW() AND p.status = 1 GROUP BY p.post_id
ORDER BY p.views DESC LIMIT 0, 5

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'journal_blog_post_id' AND `value` = '4' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'journal_blog_post_id' AND `value` = '11' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'journal_blog_post_id' AND `value` = '15' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'journal_blog_post_id' AND `value` = '14' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/blog_side_posts'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/blog_side_posts'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/blog_comments'

SELECT pd.tags as tags
FROM `oc_journal3_blog_post` p
LEFT JOIN `oc_journal3_blog_post_description` pd ON p.post_id = pd.post_id
LEFT JOIN `oc_journal3_blog_post_to_store` p2s ON p.post_id = p2s.post_id
WHERE p.status = 1 AND pd.language_id = '1' AND p2s.store_id = '0'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'journal_blog_tag' AND `value` = 'promotion' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'journal_blog_tag' AND `value` = 'promotional products' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'journal_blog_tag' AND `value` = 'T-shirt printing' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'journal_blog_tag' AND `value` = 'printing' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'journal_blog_tag' AND `value` = 'silkscreen print' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'journal_blog_tag' AND `value` = 'Screenprinting' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'journal_blog_tag' AND `value` = 'DTG' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'journal_blog_tag' AND `value` = 'Embroidery' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'journal_blog_tag' AND `value` = 'Sublimation' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'journal_blog_tag' AND `value` = 'Transfer print' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/blog_tags'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/grid'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/common/column_left'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/blog_search'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/grid'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/common/content_top'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/notification'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/header_notice'

SELECT *
FROM `oc_translation`
WHERE `store_id` = '0' AND `language_id` = '1' AND `route` = 'product/product'

SELECT p.product_id
FROM `oc_product` p
LEFT JOIN `oc_product_to_store` p2s ON (p.product_id = p2s.product_id)
WHERE p.product_id IN (0) AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'product/product' AND `store_id` = '0' AND `language_id` = '1'

SELECT category_id
FROM oc_product_to_category
WHERE product_id = '430'
ORDER BY main_category DESC LIMIT 1

SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '225'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '225' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '430' AND `store_id` = '0' AND `language_id` = '1'

SELECT category_id
FROM oc_product_to_category
WHERE product_id = '431'
ORDER BY main_category DESC LIMIT 1

SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '229'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '229' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '431' AND `store_id` = '0' AND `language_id` = '1'

SELECT category_id
FROM oc_product_to_category
WHERE product_id = '440'
ORDER BY main_category DESC LIMIT 1

SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '289'

SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '286'

SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '254'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '254_286_289' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '440' AND `store_id` = '0' AND `language_id` = '1'

SELECT category_id
FROM oc_product_to_category
WHERE product_id = '442'
ORDER BY main_category DESC LIMIT 1

SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '225'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '225' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '442' AND `store_id` = '0' AND `language_id` = '1'

SELECT category_id
FROM oc_product_to_category
WHERE product_id = '443'
ORDER BY main_category DESC LIMIT 1

SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '225'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '225' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '443' AND `store_id` = '0' AND `language_id` = '1'

SELECT category_id
FROM oc_product_to_category
WHERE product_id = '444'
ORDER BY main_category DESC LIMIT 1

SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '369'

SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '255'

SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '254'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '254_255_369' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '444' AND `store_id` = '0' AND `language_id` = '1'

SELECT category_id
FROM oc_product_to_category
WHERE product_id = '449'
ORDER BY main_category DESC LIMIT 1

SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '227'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '227' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '449' AND `store_id` = '0' AND `language_id` = '1'

SELECT category_id
FROM oc_product_to_category
WHERE product_id = '450'
ORDER BY main_category DESC LIMIT 1

SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '227'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '227' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '450' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/products'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/image'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/info_blocks'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/catalog'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/newsletter'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/info_blocks'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/icons_menu'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/grid'

SELECT *
FROM `oc_translation`
WHERE `store_id` = '0' AND `language_id` = '1' AND `route` = 'common/footer'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'information/contact' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'account/returns|add' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'information/gdpr' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'information/sitemap' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'product/manufacturer' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'checkout/voucher' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'product/special' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'account/account' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'account/order' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'account/wishlist' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'account/newsletter' AND `store_id` = '0' AND `language_id` = '1'

DELETE
FROM `oc_customer_online`
WHERE `date_added` < '2025-05-30 23:33:05'

REPLACE INTO `oc_customer_online` SET `ip` = '216.73.216.0', `customer_id` = '0', `url` = 'https://gajcom.si/index.php?_route_=/blog', `referer` = 'https://gajcom.si/en/blog', `date_added` = '2025-05-31 00:33:05'

SELECT DISTINCT *
FROM `oc_information` i
LEFT JOIN `oc_information_description` id ON (i.`information_id` = id.`information_id`)
LEFT JOIN `oc_information_to_store` i2s ON (i.`information_id` = i2s.`information_id`)
WHERE i.`information_id` = '3' AND id.`language_id` = '1' AND i2s.`store_id` = '0' AND i.`status` = '1'

SELECT *
FROM `oc_translation`
WHERE `store_id` = '0' AND `language_id` = '1' AND `route` = 'common/cookie'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'information/information|info' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'information_id' AND `value` = '3' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'common/cookie|confirm' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'agree' AND `value` = '1' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'agree' AND `value` = '0' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'common/cookie'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/common/footer'

SET time_zone = '+00:00'

SELECT *
FROM `oc_store`
WHERE REPLACE(`url`, 'www.', '') = 'https://gajcom.si/'

SELECT *
FROM `oc_setting`
WHERE `store_id` = '0' OR `store_id` = 0
ORDER BY `store_id` ASC

SET time_zone = '+02:00'

SELECT `data`
FROM `oc_session`
WHERE `session_id` = '3d1ad8117aa3fd756a52e5d0e5' AND `expire` > '2025-05-30 22:33:05'

SELECT *
FROM `oc_seo_url`
WHERE (`keyword` = '' OR `keyword` LIKE '%/') AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE (`keyword` = 'blog' OR `keyword` LIKE '%/blog') AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_currency`

SELECT tr1.`tax_class_id`, tr2.`tax_rate_id`, tr2.`name`, tr2.`rate`, tr2.`type`, tr1.`priority`
FROM `oc_tax_rule` tr1
LEFT JOIN `oc_tax_rate` tr2 ON (tr1.`tax_rate_id` = tr2.`tax_rate_id`)
INNER JOIN `oc_tax_rate_to_customer_group` tr2cg ON (tr2.`tax_rate_id` = tr2cg.`tax_rate_id`)
LEFT JOIN `oc_zone_to_geo_zone` z2gz ON (tr2.`geo_zone_id` = z2gz.`geo_zone_id`)
LEFT JOIN `oc_geo_zone` gz ON (tr2.`geo_zone_id` = gz.`geo_zone_id`)
WHERE tr1.`based` = 'shipping' AND tr2cg.`customer_group_id` = '1' AND z2gz.`country_id` = '190' AND (z2gz.`zone_id` = '0' OR z2gz.`zone_id` = '3963')
ORDER BY tr1.`priority` ASC

SELECT tr1.`tax_class_id`, tr2.`tax_rate_id`, tr2.`name`, tr2.`rate`, tr2.`type`, tr1.`priority`
FROM `oc_tax_rule` tr1
LEFT JOIN `oc_tax_rate` tr2 ON (tr1.`tax_rate_id` = tr2.`tax_rate_id`)
INNER JOIN `oc_tax_rate_to_customer_group` tr2cg ON (tr2.`tax_rate_id` = tr2cg.`tax_rate_id`)
LEFT JOIN `oc_zone_to_geo_zone` z2gz ON (tr2.`geo_zone_id` = z2gz.`geo_zone_id`)
LEFT JOIN `oc_geo_zone` gz ON (tr2.`geo_zone_id` = gz.`geo_zone_id`)
WHERE tr1.`based` = 'store' AND tr2cg.`customer_group_id` = '1' AND z2gz.`country_id` = '190' AND (z2gz.`zone_id` = '0' OR z2gz.`zone_id` = '3963')
ORDER BY tr1.`priority` ASC

SELECT *
FROM `oc_weight_class` wc
LEFT JOIN `oc_weight_class_description` wcd ON (wc.`weight_class_id` = wcd.`weight_class_id`)
WHERE wcd.`language_id` = '1'

SELECT *
FROM `oc_length_class` mc
LEFT JOIN `oc_length_class_description` mcd ON (mc.`length_class_id` = mcd.`length_class_id`)
WHERE mcd.`language_id` = '1'

DELETE
FROM `oc_cart`
WHERE (`api_id` > '0' OR `customer_id` = '0') AND `date_added` < DATE_SUB(NOW(), INTERVAL 1 HOUR)

SELECT DISTINCT `extension`
FROM `oc_extension`

SELECT *
FROM `oc_startup`
WHERE `status` = '1'
ORDER BY `sort_order` ASC

SELECT *
FROM `oc_cart`
WHERE `api_id` = '0' AND `customer_id` = '0' AND `session_id` = '3d1ad8117aa3fd756a52e5d0e5'

SELECT *
FROM `oc_seo_url`
WHERE (`keyword` = 'blog' OR `keyword` LIKE '%/blog') AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'journal3/blog' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_event`
WHERE `status` = '1'
ORDER BY `sort_order` ASC

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'common/home' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'language' AND `value` = 'en-gb' AND `store_id` = '0' AND `language_id` = '1'

SELECT p.post_id, p.image, p.date_created as date, p.views, pd.name, pd.description, a.username, a.firstname, a.lastname, a.email, ( SELECT count(*)
FROM `oc_journal3_blog_comments` bc
WHERE bc.status = 1 AND bc.post_id = p.post_id AND bc.parent_id = 0 ) as comments
FROM `oc_journal3_blog_post` p
LEFT JOIN `oc_journal3_blog_post_description` pd ON p.post_id = pd.post_id
LEFT JOIN `oc_journal3_blog_post_to_store` p2s ON p.post_id = p2s.post_id
LEFT JOIN `oc_user` a ON p.author_id = a.user_id
WHERE pd.language_id = '1' AND p2s.store_id = '0' AND p.date_created <= NOW() AND p.status = 1 GROUP BY p.post_id
ORDER BY p.date_created DESC LIMIT 0, 12

SELECT COUNT(*) AS total
FROM `oc_journal3_blog_post` p
LEFT JOIN `oc_journal3_blog_post_description` pd ON p.post_id = pd.post_id
LEFT JOIN `oc_journal3_blog_post_to_store` p2s ON p.post_id = p2s.post_id
WHERE pd.language_id = '1' AND p2s.store_id = '0' AND p.date_created <= NOW() AND p.status = 1

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'journal3/blog|post' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'journal_blog_post_id' AND `value` = '27' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'blog/post' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'journal_blog_post_id' AND `value` = '19' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'journal_blog_post_id' AND `value` = '21' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'journal_blog_post_id' AND `value` = '25' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'journal_blog_post_id' AND `value` = '26' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'journal_blog_post_id' AND `value` = '24' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'journal_blog_post_id' AND `value` = '10' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'journal_blog_post_id' AND `value` = '23' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'journal_blog_post_id' AND `value` = '20' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'journal_blog_post_id' AND `value` = '18' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'journal_blog_post_id' AND `value` = '17' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'journal_blog_post_id' AND `value` = '16' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/blog_posts'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'page' AND `value` = '{page}' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'extension/journal_3/common/pagination'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'page' AND `value` = '2' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'journal3/blog|feed' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_layout_route`
WHERE 'journal3/blog' LIKE `route` AND `store_id` = '0'
ORDER BY `route` DESC LIMIT 1

SELECT layout_id, layout_data
FROM `oc_journal3_layout`
WHERE `layout_id` = '15' OR `layout_id` = -1
ORDER BY `layout_id` DESC

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/blog_search'

SELECT *
FROM `oc_journal3_module`

SELECT c.category_id, cd.name
FROM `oc_journal3_blog_category` c
LEFT JOIN `oc_journal3_blog_category_description` cd ON c.category_id = cd.category_id
LEFT JOIN `oc_journal3_blog_category_to_store` c2s ON c.category_id = c2s.category_id
WHERE c.status = 1 AND cd.language_id = '1' AND c2s.store_id = '0'
ORDER BY c.sort_order

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'journal_blog_category_id' AND `value` = '6' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'journal_blog_category_id' AND `value` = '4' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'journal_blog_category_id' AND `value` = '5' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/blog_categories'

SELECT p.post_id, p.image, p.date_created as date, p.views, pd.name, pd.description, a.username, a.firstname, a.lastname, a.email, ( SELECT count(*)
FROM `oc_journal3_blog_comments` bc
WHERE bc.status = 1 AND bc.post_id = p.post_id AND bc.parent_id = 0 ) as comments
FROM `oc_journal3_blog_post` p
LEFT JOIN `oc_journal3_blog_post_description` pd ON p.post_id = pd.post_id
LEFT JOIN `oc_journal3_blog_post_to_store` p2s ON p.post_id = p2s.post_id
LEFT JOIN `oc_user` a ON p.author_id = a.user_id
WHERE pd.language_id = '1' AND p2s.store_id = '0' AND p.date_created <= NOW() AND p.status = 1 GROUP BY p.post_id
ORDER BY p.views DESC LIMIT 0, 5

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'journal_blog_post_id' AND `value` = '4' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'journal_blog_post_id' AND `value` = '11' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'journal_blog_post_id' AND `value` = '15' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'journal_blog_post_id' AND `value` = '14' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/blog_side_posts'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/blog_side_posts'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/blog_comments'

SELECT pd.tags as tags
FROM `oc_journal3_blog_post` p
LEFT JOIN `oc_journal3_blog_post_description` pd ON p.post_id = pd.post_id
LEFT JOIN `oc_journal3_blog_post_to_store` p2s ON p.post_id = p2s.post_id
WHERE p.status = 1 AND pd.language_id = '1' AND p2s.store_id = '0'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'journal_blog_tag' AND `value` = 'promotion' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'journal_blog_tag' AND `value` = 'promotional products' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'journal_blog_tag' AND `value` = 'T-shirt printing' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'journal_blog_tag' AND `value` = 'printing' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'journal_blog_tag' AND `value` = 'silkscreen print' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'journal_blog_tag' AND `value` = 'Screenprinting' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'journal_blog_tag' AND `value` = 'DTG' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'journal_blog_tag' AND `value` = 'Embroidery' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'journal_blog_tag' AND `value` = 'Sublimation' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'journal_blog_tag' AND `value` = 'Transfer print' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/blog_tags'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/grid'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/common/column_left'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/blog_search'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/grid'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/common/content_top'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/notification'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/header_notice'

SELECT *
FROM `oc_translation`
WHERE `store_id` = '0' AND `language_id` = '1' AND `route` = 'product/product'

SELECT p.product_id
FROM `oc_product` p
LEFT JOIN `oc_product_to_store` p2s ON (p.product_id = p2s.product_id)
WHERE p.product_id IN (0) AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'product/product' AND `store_id` = '0' AND `language_id` = '1'

SELECT category_id
FROM oc_product_to_category
WHERE product_id = '430'
ORDER BY main_category DESC LIMIT 1

SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '225'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '225' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '430' AND `store_id` = '0' AND `language_id` = '1'

SELECT category_id
FROM oc_product_to_category
WHERE product_id = '431'
ORDER BY main_category DESC LIMIT 1

SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '229'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '229' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '431' AND `store_id` = '0' AND `language_id` = '1'

SELECT category_id
FROM oc_product_to_category
WHERE product_id = '440'
ORDER BY main_category DESC LIMIT 1

SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '289'

SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '286'

SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '254'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '254_286_289' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '440' AND `store_id` = '0' AND `language_id` = '1'

SELECT category_id
FROM oc_product_to_category
WHERE product_id = '442'
ORDER BY main_category DESC LIMIT 1

SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '225'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '225' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '442' AND `store_id` = '0' AND `language_id` = '1'

SELECT category_id
FROM oc_product_to_category
WHERE product_id = '443'
ORDER BY main_category DESC LIMIT 1

SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '225'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '225' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '443' AND `store_id` = '0' AND `language_id` = '1'

SELECT category_id
FROM oc_product_to_category
WHERE product_id = '444'
ORDER BY main_category DESC LIMIT 1

SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '369'

SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '255'

SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '254'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '254_255_369' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '444' AND `store_id` = '0' AND `language_id` = '1'

SELECT category_id
FROM oc_product_to_category
WHERE product_id = '449'
ORDER BY main_category DESC LIMIT 1

SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '227'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '227' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '449' AND `store_id` = '0' AND `language_id` = '1'

SELECT category_id
FROM oc_product_to_category
WHERE product_id = '450'
ORDER BY main_category DESC LIMIT 1

SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '227'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '227' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '450' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/products'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/image'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/info_blocks'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/catalog'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/newsletter'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/info_blocks'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/icons_menu'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/grid'

SELECT *
FROM `oc_translation`
WHERE `store_id` = '0' AND `language_id` = '1' AND `route` = 'common/footer'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'information/contact' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'account/returns|add' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'information/gdpr' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'information/sitemap' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'product/manufacturer' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'checkout/voucher' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'product/special' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'account/account' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'account/order' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'account/wishlist' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'account/newsletter' AND `store_id` = '0' AND `language_id` = '1'

DELETE
FROM `oc_customer_online`
WHERE `date_added` < '2025-05-30 23:33:05'

REPLACE INTO `oc_customer_online` SET `ip` = '216.73.216.0', `customer_id` = '0', `url` = 'https://gajcom.si/index.php?_route_=/blog', `referer` = 'https://gajcom.si/en/blog', `date_added` = '2025-05-31 00:33:05'

SELECT DISTINCT *
FROM `oc_information` i
LEFT JOIN `oc_information_description` id ON (i.`information_id` = id.`information_id`)
LEFT JOIN `oc_information_to_store` i2s ON (i.`information_id` = i2s.`information_id`)
WHERE i.`information_id` = '3' AND id.`language_id` = '1' AND i2s.`store_id` = '0' AND i.`status` = '1'

SELECT *
FROM `oc_translation`
WHERE `store_id` = '0' AND `language_id` = '1' AND `route` = 'common/cookie'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'information/information|info' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'information_id' AND `value` = '3' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'common/cookie|confirm' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'agree' AND `value` = '1' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'agree' AND `value` = '0' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'common/cookie'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/common/footer'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/categories'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/categories'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/grid'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/categories'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/categories'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/grid'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/manufacturers'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/manufacturers'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/grid'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/main_menu'

SELECT *
FROM `oc_translation`
WHERE `store_id` = '0' AND `language_id` = '1' AND `route` = 'product/product'

SELECT *
FROM `oc_translation`
WHERE `store_id` = '0' AND `language_id` = '1' AND `route` = 'product/product'

SELECT category_id
FROM oc_product_to_category
WHERE product_id = '4338'
ORDER BY main_category DESC LIMIT 1

SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '225'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '225' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '4338' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'product/manufacturer|info' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'manufacturer_id' AND `value` = '3' AND `store_id` = '0' AND `language_id` = '1'

SELECT category_id
FROM oc_product_to_category
WHERE product_id = '454'
ORDER BY main_category DESC LIMIT 1

SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '225'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '225' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '454' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'manufacturer_id' AND `value` = '8' AND `store_id` = '0' AND `language_id` = '1'

SELECT category_id
FROM oc_product_to_category
WHERE product_id = '4399'
ORDER BY main_category DESC LIMIT 1

SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '225'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '225' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '4399' AND `store_id` = '0' AND `language_id` = '1'

SELECT category_id
FROM oc_product_to_category
WHERE product_id = '5932'
ORDER BY main_category DESC LIMIT 1

SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '225'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '225' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '5932' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'manufacturer_id' AND `value` = '51' AND `store_id` = '0' AND `language_id` = '1'

SELECT category_id
FROM oc_product_to_category
WHERE product_id = '4882'
ORDER BY main_category DESC LIMIT 1

SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '225'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '225' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '4882' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'manufacturer_id' AND `value` = '28' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'

SELECT category_id
FROM oc_product_to_category
WHERE product_id = '1305'
ORDER BY main_category DESC LIMIT 1

SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '225'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '225' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '1305' AND `store_id` = '0' AND `language_id` = '1'

SELECT category_id
FROM oc_product_to_category
WHERE product_id = '11201'
ORDER BY main_category DESC LIMIT 1

SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '225'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '225' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '11201' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'manufacturer_id' AND `value` = '4' AND `store_id` = '0' AND `language_id` = '1'

SELECT category_id
FROM oc_product_to_category
WHERE product_id = '5306'
ORDER BY main_category DESC LIMIT 1

SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '225'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '225' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '5306' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'manufacturer_id' AND `value` = '42' AND `store_id` = '0' AND `language_id` = '1'

SELECT category_id
FROM oc_product_to_category
WHERE product_id = '3473'
ORDER BY main_category DESC LIMIT 1

SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '225'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '225' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '3473' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'manufacturer_id' AND `value` = '15' AND `store_id` = '0' AND `language_id` = '1'

SELECT category_id
FROM oc_product_to_category
WHERE product_id = '4399'
ORDER BY main_category DESC LIMIT 1

SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '225'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '225' AND `store_id` = '0' AND `language_id` = '1'

SELECT category_id
FROM oc_product_to_category
WHERE product_id = '12731'
ORDER BY main_category DESC LIMIT 1

SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '225'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '225' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '12731' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'manufacturer_id' AND `value` = '122' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'

SELECT category_id
FROM oc_product_to_category
WHERE product_id = '12723'
ORDER BY main_category DESC LIMIT 1

SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '225'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '225' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '12723' AND `store_id` = '0' AND `language_id` = '1'

SELECT category_id
FROM oc_product_to_category
WHERE product_id = '4414'
ORDER BY main_category DESC LIMIT 1

SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '225'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '225' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '4414' AND `store_id` = '0' AND `language_id` = '1'

SELECT category_id
FROM oc_product_to_category
WHERE product_id = '11632'
ORDER BY main_category DESC LIMIT 1

SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '225'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '225' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '11632' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'manufacturer_id' AND `value` = '113' AND `store_id` = '0' AND `language_id` = '1'

SELECT category_id
FROM oc_product_to_category
WHERE product_id = '5381'
ORDER BY main_category DESC LIMIT 1

SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '225'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '225' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '5381' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'manufacturer_id' AND `value` = '21' AND `store_id` = '0' AND `language_id` = '1'

SELECT category_id
FROM oc_product_to_category
WHERE product_id = '5419'
ORDER BY main_category DESC LIMIT 1

SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '225'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '225' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '5419' AND `store_id` = '0' AND `language_id` = '1'

SELECT category_id
FROM oc_product_to_category
WHERE product_id = '532'
ORDER BY main_category DESC LIMIT 1

SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '225'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '225' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '532' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/products'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/grid'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/manufacturers'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/manufacturers'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/grid'

SELECT *
FROM `oc_translation`
WHERE `store_id` = '0' AND `language_id` = '1' AND `route` = 'product/product'

SELECT category_id
FROM oc_product_to_category
WHERE product_id = '10407'
ORDER BY main_category DESC LIMIT 1

SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '227'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '227' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '10407' AND `store_id` = '0' AND `language_id` = '1'

SELECT category_id
FROM oc_product_to_category
WHERE product_id = '449'
ORDER BY main_category DESC LIMIT 1

SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '227'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '227' AND `store_id` = '0' AND `language_id` = '1'

SELECT category_id
FROM oc_product_to_category
WHERE product_id = '450'
ORDER BY main_category DESC LIMIT 1

SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '227'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '227' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'

SELECT category_id
FROM oc_product_to_category
WHERE product_id = '666'
ORDER BY main_category DESC LIMIT 1

SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '244'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '244' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '666' AND `store_id` = '0' AND `language_id` = '1'

SELECT category_id
FROM oc_product_to_category
WHERE product_id = '665'
ORDER BY main_category DESC LIMIT 1

SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '244'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '244' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '665' AND `store_id` = '0' AND `language_id` = '1'

SELECT category_id
FROM oc_product_to_category
WHERE product_id = '673'
ORDER BY main_category DESC LIMIT 1

SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '244'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '244' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'product_id' AND `value` = '673' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/products'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/grid'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/info_blocks'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/grid'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/image'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/text'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/grid'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/info_blocks'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/grid'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/main_menu'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/main_menu'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/top_menu'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/top_menu'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/top_menu'

SELECT *
FROM `oc_translation`
WHERE `store_id` = '0' AND `language_id` = '1' AND `route` = 'product/product'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/image'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/text'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/grid'

SELECT *
FROM `oc_translation`
WHERE `store_id` = '0' AND `language_id` = '1' AND `route` = 'product/product'

SELECT category_id
FROM oc_product_to_category
WHERE product_id = '10407'
ORDER BY main_category DESC LIMIT 1

SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '227'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '227' AND `store_id` = '0' AND `language_id` = '1'

SELECT category_id
FROM oc_product_to_category
WHERE product_id = '449'
ORDER BY main_category DESC LIMIT 1

SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '227'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '227' AND `store_id` = '0' AND `language_id` = '1'

SELECT category_id
FROM oc_product_to_category
WHERE product_id = '450'
ORDER BY main_category DESC LIMIT 1

SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '227'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '227' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'

SELECT category_id
FROM oc_product_to_category
WHERE product_id = '666'
ORDER BY main_category DESC LIMIT 1

SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '244'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '244' AND `store_id` = '0' AND `language_id` = '1'

SELECT category_id
FROM oc_product_to_category
WHERE product_id = '665'
ORDER BY main_category DESC LIMIT 1

SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '244'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '244' AND `store_id` = '0' AND `language_id` = '1'

SELECT category_id
FROM oc_product_to_category
WHERE product_id = '673'
ORDER BY main_category DESC LIMIT 1

SELECT parent_id, category_id
FROM oc_category
WHERE category_id = '244'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '244' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/products'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/products'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/grid'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/manufacturers'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/manufacturers'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/grid'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/info_blocks'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/grid'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/info_blocks'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/grid'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/info_blocks'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/grid'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/main_menu'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/top_menu'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/module/info_blocks'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/grid'

SELECT *
FROM `oc_translation`
WHERE `store_id` = '0' AND `language_id` = '1' AND `route` = 'common/header'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'account/register' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'account/login' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'checkout/cart' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'checkout/checkout' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_translation`
WHERE `store_id` = '0' AND `language_id` = '1' AND `route` = 'common/language'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'common/home' AND `store_id` = '0' AND `language_id` = '2'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'language' AND `value` = 'sl-SI' AND `store_id` = '0' AND `language_id` = '2'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'common/home' AND `store_id` = '0' AND `language_id` = '3'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'language' AND `value` = 'de-de' AND `store_id` = '0' AND `language_id` = '3'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/common/language'

SELECT *
FROM `oc_translation`
WHERE `store_id` = '0' AND `language_id` = '1' AND `route` = 'common/currency'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'common/currency|save' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/common/currency'

SELECT *
FROM `oc_translation`
WHERE `store_id` = '0' AND `language_id` = '1' AND `route` = 'common/search'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'product/search' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'search' AND `value` = '' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_translation`
WHERE `store_id` = '0' AND `language_id` = '1' AND `route` = 'product/search'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/common/search'

SELECT *
FROM `oc_translation`
WHERE `store_id` = '0' AND `language_id` = '1' AND `route` = 'common/cart'

SELECT *
FROM `oc_cart`
WHERE `api_id` = '0' AND `customer_id` = '0' AND `session_id` = '3d1ad8117aa3fd756a52e5d0e5'

SELECT *
FROM `oc_extension`
WHERE `type` = 'total'

SELECT *
FROM `oc_translation`
WHERE `store_id` = '0' AND `language_id` = '1' AND `route` = 'extension/opencart/total/sub_total'

SELECT *
FROM `oc_cart`
WHERE `api_id` = '0' AND `customer_id` = '0' AND `session_id` = '3d1ad8117aa3fd756a52e5d0e5'

SELECT *
FROM oc_setting
WHERE `code` = 'total_category_product_based_fee'
ORDER BY `key` ASC

SELECT *
FROM oc_country
WHERE country_id = 190

SELECT *
FROM oc_zone
WHERE zone_id = 3963

SELECT *
FROM oc_zone_to_geo_zone
WHERE country_id = 190 AND (zone_id = 0 OR zone_id = 3963)

SELECT *
FROM oc_country
WHERE country_id = 190

SELECT *
FROM oc_zone
WHERE zone_id = 3963

SELECT *
FROM oc_zone_to_geo_zone
WHERE country_id = 190 AND (zone_id = 0 OR zone_id = 3963)

SELECT *
FROM oc_country
WHERE country_id = 190

SELECT *
FROM oc_zone
WHERE zone_id = 3963

SELECT *
FROM oc_zone_to_geo_zone
WHERE country_id = 190 AND (zone_id = 0 OR zone_id = 3963)

SELECT *
FROM `oc_cart`
WHERE `api_id` = '0' AND `customer_id` = '0' AND `session_id` = '3d1ad8117aa3fd756a52e5d0e5'

SELECT *
FROM oc_setting
WHERE `key` = 'config_currency' AND store_id = 0
ORDER BY setting_id DESC LIMIT 1

SELECT *
FROM `oc_translation`
WHERE `store_id` = '0' AND `language_id` = '1' AND `route` = 'extension/opencart/total/credit'

SELECT SUM(`amount`) AS `total`
FROM `oc_customer_transaction`
WHERE `customer_id` = '0'

SELECT *
FROM `oc_cart`
WHERE `api_id` = '0' AND `customer_id` = '0' AND `session_id` = '3d1ad8117aa3fd756a52e5d0e5'

SELECT *
FROM `oc_translation`
WHERE `store_id` = '0' AND `language_id` = '1' AND `route` = 'extension/opencart/total/total'

SELECT *
FROM `oc_cart`
WHERE `api_id` = '0' AND `customer_id` = '0' AND `session_id` = '3d1ad8117aa3fd756a52e5d0e5'

SELECT *
FROM `oc_cart`
WHERE `api_id` = '0' AND `customer_id` = '0' AND `session_id` = '3d1ad8117aa3fd756a52e5d0e5'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'common/cart|info' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'checkout/cart|remove' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'checkout/voucher|remove' AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_cart`
WHERE `api_id` = '0' AND `customer_id` = '0' AND `session_id` = '3d1ad8117aa3fd756a52e5d0e5'

SELECT *
FROM `oc_extension`
WHERE `type` = 'total'

SELECT *
FROM `oc_translation`
WHERE `store_id` = '0' AND `language_id` = '1' AND `route` = 'extension/opencart/total/sub_total'

SELECT *
FROM `oc_cart`
WHERE `api_id` = '0' AND `customer_id` = '0' AND `session_id` = '3d1ad8117aa3fd756a52e5d0e5'

SELECT *
FROM oc_setting
WHERE `code` = 'total_category_product_based_fee'
ORDER BY `key` ASC

SELECT *
FROM oc_country
WHERE country_id = 190

SELECT *
FROM oc_zone
WHERE zone_id = 3963

SELECT *
FROM oc_zone_to_geo_zone
WHERE country_id = 190 AND (zone_id = 0 OR zone_id = 3963)

SELECT *
FROM oc_country
WHERE country_id = 190

SELECT *
FROM oc_zone
WHERE zone_id = 3963

SELECT *
FROM oc_zone_to_geo_zone
WHERE country_id = 190 AND (zone_id = 0 OR zone_id = 3963)

SELECT *
FROM oc_country
WHERE country_id = 190

SELECT *
FROM oc_zone
WHERE zone_id = 3963

SELECT *
FROM oc_zone_to_geo_zone
WHERE country_id = 190 AND (zone_id = 0 OR zone_id = 3963)

SELECT *
FROM `oc_cart`
WHERE `api_id` = '0' AND `customer_id` = '0' AND `session_id` = '3d1ad8117aa3fd756a52e5d0e5'

SELECT *
FROM oc_setting
WHERE `key` = 'config_currency' AND store_id = 0
ORDER BY setting_id DESC LIMIT 1

SELECT *
FROM `oc_translation`
WHERE `store_id` = '0' AND `language_id` = '1' AND `route` = 'extension/opencart/total/credit'

SELECT SUM(`amount`) AS `total`
FROM `oc_customer_transaction`
WHERE `customer_id` = '0'

SELECT *
FROM `oc_cart`
WHERE `api_id` = '0' AND `customer_id` = '0' AND `session_id` = '3d1ad8117aa3fd756a52e5d0e5'

SELECT *
FROM `oc_translation`
WHERE `store_id` = '0' AND `language_id` = '1' AND `route` = 'extension/opencart/total/total'

SELECT *
FROM `oc_cart`
WHERE `api_id` = '0' AND `customer_id` = '0' AND `session_id` = '3d1ad8117aa3fd756a52e5d0e5'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/common/cart'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/css'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/headers/desktop/classic'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/headers/mobile/header_mobile_1'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/common/header'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'journal3/blog' AND `store_id` = '0' AND `language_id` = '2'

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'journal3/blog' AND `store_id` = '0' AND `language_id` = '3'

SELECT *
FROM `oc_theme`
WHERE `store_id` = '0' AND `route` = 'journal3/journal3/blog/posts'