Find Your Favorite Brand

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` = '97e205d3a5d6397d3b74debc70' AND `expire` > '2025-06-01 04:32:10'

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` = 'en' OR `keyword` LIKE '%/en') AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE (`keyword` = 'brands-en' OR `keyword` LIKE '%/brands-en') 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` = '97e205d3a5d6397d3b74debc70'

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

SELECT *
FROM `oc_seo_url`
WHERE (`keyword` = 'brands-en' OR `keyword` LIKE '%/brands-en') 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` = 'language' AND `value` = 'en-gb' AND `store_id` = '0' AND `language_id` = '1'

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

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

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

SELECT *
FROM `oc_manufacturer` m
LEFT JOIN `oc_manufacturer_to_store` m2s ON (m.`manufacturer_id` = m2s.`manufacturer_id`)
WHERE m2s.`store_id` = '0'
ORDER BY `name`

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` = '108' AND `store_id` = '0' AND `language_id` = '1'

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

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

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

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

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'manufacturer_id' AND `value` = '119' 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 *
FROM `oc_seo_url`
WHERE `key` = 'manufacturer_id' AND `value` = '39' AND `store_id` = '0' AND `language_id` = '1'

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

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

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

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'manufacturer_id' AND `value` = '12' 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 *
FROM `oc_seo_url`
WHERE `key` = 'manufacturer_id' AND `value` = '182' AND `store_id` = '0' AND `language_id` = '1'

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

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

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

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

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

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

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

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

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

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

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

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

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

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'manufacturer_id' AND `value` = '6' 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 *
FROM `oc_seo_url`
WHERE `key` = 'manufacturer_id' AND `value` = '154' AND `store_id` = '0' AND `language_id` = '1'

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

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

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

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

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

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

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

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

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'manufacturer_id' AND `value` = '52' 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 *
FROM `oc_seo_url`
WHERE `key` = 'manufacturer_id' AND `value` = '70' AND `store_id` = '0' AND `language_id` = '1'

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

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

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

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

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

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

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

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

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

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

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

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'manufacturer_id' AND `value` = '22' 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 *
FROM `oc_seo_url`
WHERE `key` = 'manufacturer_id' AND `value` = '176' AND `store_id` = '0' AND `language_id` = '1'

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

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

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

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

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

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

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

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'manufacturer_id' AND `value` = '135' 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_seo_url`
WHERE `key` = 'manufacturer_id' AND `value` = '79' AND `store_id` = '0' AND `language_id` = '1'

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'manufacturer_id' AND `value` = '72' 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 *
FROM `oc_seo_url`
WHERE `key` = 'manufacturer_id' AND `value` = '24' AND `store_id` = '0' AND `language_id` = '1'

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

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

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'manufacturer_id' AND `value` = '169' 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 *
FROM `oc_seo_url`
WHERE `key` = 'manufacturer_id' AND `value` = '15' AND `store_id` = '0' AND `language_id` = '1'

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

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

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

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'manufacturer_id' AND `value` = '146' 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_seo_url`
WHERE `key` = 'manufacturer_id' AND `value` = '171' AND `store_id` = '0' AND `language_id` = '1'

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

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

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

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

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

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

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

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

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/notification'

SELECT *
FROM `oc_journal3_module`

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 (8170) AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

SELECT DISTINCT *, p.product_id as product_id, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1' LIMIT 1) AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN oc_product_viewed pw ON (p.product_id = pw.product_id)
WHERE p.product_id IN (8170) AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

SELECT *
FROM oc_product_special ps
WHERE ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND ps.date_end != '0000-00-00' AND ps.date_end > NOW()) AND product_id IN (8170) GROUP BY ps.product_id
ORDER BY ps.priority ASC, ps.price ASC

SELECT pi.product_id, pi.image
FROM oc_product_image pi
INNER JOIN ( SELECT product_id, MIN(sort_order) AS sort_order
FROM oc_product_image
WHERE product_id IN (8170) GROUP BY product_id ) pi2
WHERE pi.product_id = pi2.product_id AND pi.sort_order = pi2.sort_order GROUP BY product_id

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 = '8170'
ORDER BY main_category DESC LIMIT 1

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

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_288' AND `store_id` = '0' AND `language_id` = '1'

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

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

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` = '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-06-01 05:32:10'

REPLACE INTO `oc_customer_online` SET `ip` = '216.73.216.18', `customer_id` = '0', `url` = 'https://gajcom.si/index.php?_route_=/en/brands-en', `referer` = 'https://gajcom.si/brands-en', `date_added` = '2025-06-01 06:32:10'

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` = '97e205d3a5d6397d3b74debc70' AND `expire` > '2025-06-01 04:32:10'

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` = 'en' OR `keyword` LIKE '%/en') AND `store_id` = '0' AND `language_id` = '1'

SELECT *
FROM `oc_seo_url`
WHERE (`keyword` = 'brands-en' OR `keyword` LIKE '%/brands-en') 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` = '97e205d3a5d6397d3b74debc70'

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

SELECT *
FROM `oc_seo_url`
WHERE (`keyword` = 'brands-en' OR `keyword` LIKE '%/brands-en') 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` = 'language' AND `value` = 'en-gb' AND `store_id` = '0' AND `language_id` = '1'

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

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

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

SELECT *
FROM `oc_manufacturer` m
LEFT JOIN `oc_manufacturer_to_store` m2s ON (m.`manufacturer_id` = m2s.`manufacturer_id`)
WHERE m2s.`store_id` = '0'
ORDER BY `name`

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` = '108' AND `store_id` = '0' AND `language_id` = '1'

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

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

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

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

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'manufacturer_id' AND `value` = '119' 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 *
FROM `oc_seo_url`
WHERE `key` = 'manufacturer_id' AND `value` = '39' AND `store_id` = '0' AND `language_id` = '1'

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

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

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

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'manufacturer_id' AND `value` = '12' 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 *
FROM `oc_seo_url`
WHERE `key` = 'manufacturer_id' AND `value` = '182' AND `store_id` = '0' AND `language_id` = '1'

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

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

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

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

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

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

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

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

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

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

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

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

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

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'manufacturer_id' AND `value` = '6' 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 *
FROM `oc_seo_url`
WHERE `key` = 'manufacturer_id' AND `value` = '154' AND `store_id` = '0' AND `language_id` = '1'

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

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

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

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

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

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

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

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

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'manufacturer_id' AND `value` = '52' 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 *
FROM `oc_seo_url`
WHERE `key` = 'manufacturer_id' AND `value` = '70' AND `store_id` = '0' AND `language_id` = '1'

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

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

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

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

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

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

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

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

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

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

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

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'manufacturer_id' AND `value` = '22' 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 *
FROM `oc_seo_url`
WHERE `key` = 'manufacturer_id' AND `value` = '176' AND `store_id` = '0' AND `language_id` = '1'

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

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

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

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

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

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

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

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'manufacturer_id' AND `value` = '135' 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_seo_url`
WHERE `key` = 'manufacturer_id' AND `value` = '79' AND `store_id` = '0' AND `language_id` = '1'

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'manufacturer_id' AND `value` = '72' 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 *
FROM `oc_seo_url`
WHERE `key` = 'manufacturer_id' AND `value` = '24' AND `store_id` = '0' AND `language_id` = '1'

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

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

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'manufacturer_id' AND `value` = '169' 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 *
FROM `oc_seo_url`
WHERE `key` = 'manufacturer_id' AND `value` = '15' AND `store_id` = '0' AND `language_id` = '1'

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

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

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

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'manufacturer_id' AND `value` = '146' 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_seo_url`
WHERE `key` = 'manufacturer_id' AND `value` = '171' AND `store_id` = '0' AND `language_id` = '1'

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

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

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

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

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

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

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

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

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/notification'

SELECT *
FROM `oc_journal3_module`

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 (8170) AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

SELECT DISTINCT *, p.product_id as product_id, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1' LIMIT 1) AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN oc_product_viewed pw ON (p.product_id = pw.product_id)
WHERE p.product_id IN (8170) AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

SELECT *
FROM oc_product_special ps
WHERE ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND ps.date_end != '0000-00-00' AND ps.date_end > NOW()) AND product_id IN (8170) GROUP BY ps.product_id
ORDER BY ps.priority ASC, ps.price ASC

SELECT pi.product_id, pi.image
FROM oc_product_image pi
INNER JOIN ( SELECT product_id, MIN(sort_order) AS sort_order
FROM oc_product_image
WHERE product_id IN (8170) GROUP BY product_id ) pi2
WHERE pi.product_id = pi2.product_id AND pi.sort_order = pi2.sort_order GROUP BY product_id

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 = '8170'
ORDER BY main_category DESC LIMIT 1

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

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_288' AND `store_id` = '0' AND `language_id` = '1'

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

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

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` = '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-06-01 05:32:10'

REPLACE INTO `oc_customer_online` SET `ip` = '216.73.216.18', `customer_id` = '0', `url` = 'https://gajcom.si/index.php?_route_=/en/brands-en', `referer` = 'https://gajcom.si/brands-en', `date_added` = '2025-06-01 06:32:10'

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 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 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 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_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 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 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 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_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 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 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'