Site Map

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` = 'b5fd9e38db2caca8acbe7e9633' AND `expire` > '2025-06-01 04:22:27'

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` = 'sitemap-en' OR `keyword` LIKE '%/sitemap-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` = 'b5fd9e38db2caca8acbe7e9633'

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` = 'sitemap-en' OR `keyword` LIKE '%/sitemap-en') 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` = '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` = 'information/sitemap'

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

SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.`category_id` = cd.`category_id`)
LEFT JOIN `oc_category_to_store` c2s ON (c.`category_id` = c2s.`category_id`)
WHERE c.`parent_id` = '0' AND cd.`language_id` = '1' AND c2s.`store_id` = '0' AND c.`status` = '1'
ORDER BY c.`sort_order`, LCASE(cd.`name`)

SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.`category_id` = cd.`category_id`)
LEFT JOIN `oc_category_to_store` c2s ON (c.`category_id` = c2s.`category_id`)
WHERE c.`parent_id` = '422' AND cd.`language_id` = '1' AND c2s.`store_id` = '0' AND c.`status` = '1'
ORDER BY c.`sort_order`, LCASE(cd.`name`)

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

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

SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.`category_id` = cd.`category_id`)
LEFT JOIN `oc_category_to_store` c2s ON (c.`category_id` = c2s.`category_id`)
WHERE c.`parent_id` = '225' AND cd.`language_id` = '1' AND c2s.`store_id` = '0' AND c.`status` = '1'
ORDER BY c.`sort_order`, LCASE(cd.`name`)

SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.`category_id` = cd.`category_id`)
LEFT JOIN `oc_category_to_store` c2s ON (c.`category_id` = c2s.`category_id`)
WHERE c.`parent_id` = '396' AND cd.`language_id` = '1' AND c2s.`store_id` = '0' AND c.`status` = '1'
ORDER BY c.`sort_order`, LCASE(cd.`name`)

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

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

SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.`category_id` = cd.`category_id`)
LEFT JOIN `oc_category_to_store` c2s ON (c.`category_id` = c2s.`category_id`)
WHERE c.`parent_id` = '226' AND cd.`language_id` = '1' AND c2s.`store_id` = '0' AND c.`status` = '1'
ORDER BY c.`sort_order`, LCASE(cd.`name`)

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

SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.`category_id` = cd.`category_id`)
LEFT JOIN `oc_category_to_store` c2s ON (c.`category_id` = c2s.`category_id`)
WHERE c.`parent_id` = '227' AND cd.`language_id` = '1' AND c2s.`store_id` = '0' AND c.`status` = '1'
ORDER BY c.`sort_order`, LCASE(cd.`name`)

SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.`category_id` = cd.`category_id`)
LEFT JOIN `oc_category_to_store` c2s ON (c.`category_id` = c2s.`category_id`)
WHERE c.`parent_id` = '397' AND cd.`language_id` = '1' AND c2s.`store_id` = '0' AND c.`status` = '1'
ORDER BY c.`sort_order`, LCASE(cd.`name`)

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

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

SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.`category_id` = cd.`category_id`)
LEFT JOIN `oc_category_to_store` c2s ON (c.`category_id` = c2s.`category_id`)
WHERE c.`parent_id` = '228' AND cd.`language_id` = '1' AND c2s.`store_id` = '0' AND c.`status` = '1'
ORDER BY c.`sort_order`, LCASE(cd.`name`)

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

SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.`category_id` = cd.`category_id`)
LEFT JOIN `oc_category_to_store` c2s ON (c.`category_id` = c2s.`category_id`)
WHERE c.`parent_id` = '229' AND cd.`language_id` = '1' AND c2s.`store_id` = '0' AND c.`status` = '1'
ORDER BY c.`sort_order`, LCASE(cd.`name`)

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

SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.`category_id` = cd.`category_id`)
LEFT JOIN `oc_category_to_store` c2s ON (c.`category_id` = c2s.`category_id`)
WHERE c.`parent_id` = '230' AND cd.`language_id` = '1' AND c2s.`store_id` = '0' AND c.`status` = '1'
ORDER BY c.`sort_order`, LCASE(cd.`name`)

SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.`category_id` = cd.`category_id`)
LEFT JOIN `oc_category_to_store` c2s ON (c.`category_id` = c2s.`category_id`)
WHERE c.`parent_id` = '336' AND cd.`language_id` = '1' AND c2s.`store_id` = '0' AND c.`status` = '1'
ORDER BY c.`sort_order`, LCASE(cd.`name`)

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

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

SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.`category_id` = cd.`category_id`)
LEFT JOIN `oc_category_to_store` c2s ON (c.`category_id` = c2s.`category_id`)
WHERE c.`parent_id` = '337' AND cd.`language_id` = '1' AND c2s.`store_id` = '0' AND c.`status` = '1'
ORDER BY c.`sort_order`, LCASE(cd.`name`)

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

SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.`category_id` = cd.`category_id`)
LEFT JOIN `oc_category_to_store` c2s ON (c.`category_id` = c2s.`category_id`)
WHERE c.`parent_id` = '231' AND cd.`language_id` = '1' AND c2s.`store_id` = '0' AND c.`status` = '1'
ORDER BY c.`sort_order`, LCASE(cd.`name`)

SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.`category_id` = cd.`category_id`)
LEFT JOIN `oc_category_to_store` c2s ON (c.`category_id` = c2s.`category_id`)
WHERE c.`parent_id` = '418' AND cd.`language_id` = '1' AND c2s.`store_id` = '0' AND c.`status` = '1'
ORDER BY c.`sort_order`, LCASE(cd.`name`)

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

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

SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.`category_id` = cd.`category_id`)
LEFT JOIN `oc_category_to_store` c2s ON (c.`category_id` = c2s.`category_id`)
WHERE c.`parent_id` = '232' AND cd.`language_id` = '1' AND c2s.`store_id` = '0' AND c.`status` = '1'
ORDER BY c.`sort_order`, LCASE(cd.`name`)

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

SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.`category_id` = cd.`category_id`)
LEFT JOIN `oc_category_to_store` c2s ON (c.`category_id` = c2s.`category_id`)
WHERE c.`parent_id` = '233' AND cd.`language_id` = '1' AND c2s.`store_id` = '0' AND c.`status` = '1'
ORDER BY c.`sort_order`, LCASE(cd.`name`)

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

SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.`category_id` = cd.`category_id`)
LEFT JOIN `oc_category_to_store` c2s ON (c.`category_id` = c2s.`category_id`)
WHERE c.`parent_id` = '234' AND cd.`language_id` = '1' AND c2s.`store_id` = '0' AND c.`status` = '1'
ORDER BY c.`sort_order`, LCASE(cd.`name`)

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

SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.`category_id` = cd.`category_id`)
LEFT JOIN `oc_category_to_store` c2s ON (c.`category_id` = c2s.`category_id`)
WHERE c.`parent_id` = '235' AND cd.`language_id` = '1' AND c2s.`store_id` = '0' AND c.`status` = '1'
ORDER BY c.`sort_order`, LCASE(cd.`name`)

SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.`category_id` = cd.`category_id`)
LEFT JOIN `oc_category_to_store` c2s ON (c.`category_id` = c2s.`category_id`)
WHERE c.`parent_id` = '332' AND cd.`language_id` = '1' AND c2s.`store_id` = '0' AND c.`status` = '1'
ORDER BY c.`sort_order`, LCASE(cd.`name`)

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

SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.`category_id` = cd.`category_id`)
LEFT JOIN `oc_category_to_store` c2s ON (c.`category_id` = c2s.`category_id`)
WHERE c.`parent_id` = '331' AND cd.`language_id` = '1' AND c2s.`store_id` = '0' AND c.`status` = '1'
ORDER BY c.`sort_order`, LCASE(cd.`name`)

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

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

SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.`category_id` = cd.`category_id`)
LEFT JOIN `oc_category_to_store` c2s ON (c.`category_id` = c2s.`category_id`)
WHERE c.`parent_id` = '244' AND cd.`language_id` = '1' AND c2s.`store_id` = '0' AND c.`status` = '1'
ORDER BY c.`sort_order`, LCASE(cd.`name`)

SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.`category_id` = cd.`category_id`)
LEFT JOIN `oc_category_to_store` c2s ON (c.`category_id` = c2s.`category_id`)
WHERE c.`parent_id` = '410' AND cd.`language_id` = '1' AND c2s.`store_id` = '0' AND c.`status` = '1'
ORDER BY c.`sort_order`, LCASE(cd.`name`)

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

SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.`category_id` = cd.`category_id`)
LEFT JOIN `oc_category_to_store` c2s ON (c.`category_id` = c2s.`category_id`)
WHERE c.`parent_id` = '394' AND cd.`language_id` = '1' AND c2s.`store_id` = '0' AND c.`status` = '1'
ORDER BY c.`sort_order`, LCASE(cd.`name`)

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

SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.`category_id` = cd.`category_id`)
LEFT JOIN `oc_category_to_store` c2s ON (c.`category_id` = c2s.`category_id`)
WHERE c.`parent_id` = '411' AND cd.`language_id` = '1' AND c2s.`store_id` = '0' AND c.`status` = '1'
ORDER BY c.`sort_order`, LCASE(cd.`name`)

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

SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.`category_id` = cd.`category_id`)
LEFT JOIN `oc_category_to_store` c2s ON (c.`category_id` = c2s.`category_id`)
WHERE c.`parent_id` = '408' AND cd.`language_id` = '1' AND c2s.`store_id` = '0' AND c.`status` = '1'
ORDER BY c.`sort_order`, LCASE(cd.`name`)

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

SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.`category_id` = cd.`category_id`)
LEFT JOIN `oc_category_to_store` c2s ON (c.`category_id` = c2s.`category_id`)
WHERE c.`parent_id` = '412' AND cd.`language_id` = '1' AND c2s.`store_id` = '0' AND c.`status` = '1'
ORDER BY c.`sort_order`, LCASE(cd.`name`)

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

SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.`category_id` = cd.`category_id`)
LEFT JOIN `oc_category_to_store` c2s ON (c.`category_id` = c2s.`category_id`)
WHERE c.`parent_id` = '409' AND cd.`language_id` = '1' AND c2s.`store_id` = '0' AND c.`status` = '1'
ORDER BY c.`sort_order`, LCASE(cd.`name`)

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

SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.`category_id` = cd.`category_id`)
LEFT JOIN `oc_category_to_store` c2s ON (c.`category_id` = c2s.`category_id`)
WHERE c.`parent_id` = '407' AND cd.`language_id` = '1' AND c2s.`store_id` = '0' AND c.`status` = '1'
ORDER BY c.`sort_order`, LCASE(cd.`name`)

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

SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.`category_id` = cd.`category_id`)
LEFT JOIN `oc_category_to_store` c2s ON (c.`category_id` = c2s.`category_id`)
WHERE c.`parent_id` = '413' AND cd.`language_id` = '1' AND c2s.`store_id` = '0' AND c.`status` = '1'
ORDER BY c.`sort_order`, LCASE(cd.`name`)

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

SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.`category_id` = cd.`category_id`)
LEFT JOIN `oc_category_to_store` c2s ON (c.`category_id` = c2s.`category_id`)
WHERE c.`parent_id` = '415' AND cd.`language_id` = '1' AND c2s.`store_id` = '0' AND c.`status` = '1'
ORDER BY c.`sort_order`, LCASE(cd.`name`)

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

SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.`category_id` = cd.`category_id`)
LEFT JOIN `oc_category_to_store` c2s ON (c.`category_id` = c2s.`category_id`)
WHERE c.`parent_id` = '414' AND cd.`language_id` = '1' AND c2s.`store_id` = '0' AND c.`status` = '1'
ORDER BY c.`sort_order`, LCASE(cd.`name`)

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

SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.`category_id` = cd.`category_id`)
LEFT JOIN `oc_category_to_store` c2s ON (c.`category_id` = c2s.`category_id`)
WHERE c.`parent_id` = '333' AND cd.`language_id` = '1' AND c2s.`store_id` = '0' AND c.`status` = '1'
ORDER BY c.`sort_order`, LCASE(cd.`name`)

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

SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.`category_id` = cd.`category_id`)
LEFT JOIN `oc_category_to_store` c2s ON (c.`category_id` = c2s.`category_id`)
WHERE c.`parent_id` = '392' AND cd.`language_id` = '1' AND c2s.`store_id` = '0' AND c.`status` = '1'
ORDER BY c.`sort_order`, LCASE(cd.`name`)

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

SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.`category_id` = cd.`category_id`)
LEFT JOIN `oc_category_to_store` c2s ON (c.`category_id` = c2s.`category_id`)
WHERE c.`parent_id` = '391' AND cd.`language_id` = '1' AND c2s.`store_id` = '0' AND c.`status` = '1'
ORDER BY c.`sort_order`, LCASE(cd.`name`)

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

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

SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.`category_id` = cd.`category_id`)
LEFT JOIN `oc_category_to_store` c2s ON (c.`category_id` = c2s.`category_id`)
WHERE c.`parent_id` = '238' AND cd.`language_id` = '1' AND c2s.`store_id` = '0' AND c.`status` = '1'
ORDER BY c.`sort_order`, LCASE(cd.`name`)

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

SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.`category_id` = cd.`category_id`)
LEFT JOIN `oc_category_to_store` c2s ON (c.`category_id` = c2s.`category_id`)
WHERE c.`parent_id` = '239' AND cd.`language_id` = '1' AND c2s.`store_id` = '0' AND c.`status` = '1'
ORDER BY c.`sort_order`, LCASE(cd.`name`)

SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.`category_id` = cd.`category_id`)
LEFT JOIN `oc_category_to_store` c2s ON (c.`category_id` = c2s.`category_id`)
WHERE c.`parent_id` = '406' AND cd.`language_id` = '1' AND c2s.`store_id` = '0' AND c.`status` = '1'
ORDER BY c.`sort_order`, LCASE(cd.`name`)

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

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

SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.`category_id` = cd.`category_id`)
LEFT JOIN `oc_category_to_store` c2s ON (c.`category_id` = c2s.`category_id`)
WHERE c.`parent_id` = '240' AND cd.`language_id` = '1' AND c2s.`store_id` = '0' AND c.`status` = '1'
ORDER BY c.`sort_order`, LCASE(cd.`name`)

SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.`category_id` = cd.`category_id`)
LEFT JOIN `oc_category_to_store` c2s ON (c.`category_id` = c2s.`category_id`)
WHERE c.`parent_id` = '402' AND cd.`language_id` = '1' AND c2s.`store_id` = '0' AND c.`status` = '1'
ORDER BY c.`sort_order`, LCASE(cd.`name`)

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

SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.`category_id` = cd.`category_id`)
LEFT JOIN `oc_category_to_store` c2s ON (c.`category_id` = c2s.`category_id`)
WHERE c.`parent_id` = '403' AND cd.`language_id` = '1' AND c2s.`store_id` = '0' AND c.`status` = '1'
ORDER BY c.`sort_order`, LCASE(cd.`name`)

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

SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.`category_id` = cd.`category_id`)
LEFT JOIN `oc_category_to_store` c2s ON (c.`category_id` = c2s.`category_id`)
WHERE c.`parent_id` = '404' AND cd.`language_id` = '1' AND c2s.`store_id` = '0' AND c.`status` = '1'
ORDER BY c.`sort_order`, LCASE(cd.`name`)

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

SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.`category_id` = cd.`category_id`)
LEFT JOIN `oc_category_to_store` c2s ON (c.`category_id` = c2s.`category_id`)
WHERE c.`parent_id` = '405' AND cd.`language_id` = '1' AND c2s.`store_id` = '0' AND c.`status` = '1'
ORDER BY c.`sort_order`, LCASE(cd.`name`)

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

SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.`category_id` = cd.`category_id`)
LEFT JOIN `oc_category_to_store` c2s ON (c.`category_id` = c2s.`category_id`)
WHERE c.`parent_id` = '342' AND cd.`language_id` = '1' AND c2s.`store_id` = '0' AND c.`status` = '1'
ORDER BY c.`sort_order`, LCASE(cd.`name`)

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

SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.`category_id` = cd.`category_id`)
LEFT JOIN `oc_category_to_store` c2s ON (c.`category_id` = c2s.`category_id`)
WHERE c.`parent_id` = '389' AND cd.`language_id` = '1' AND c2s.`store_id` = '0' AND c.`status` = '1'
ORDER BY c.`sort_order`, LCASE(cd.`name`)

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

SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.`category_id` = cd.`category_id`)
LEFT JOIN `oc_category_to_store` c2s ON (c.`category_id` = c2s.`category_id`)
WHERE c.`parent_id` = '399' AND cd.`language_id` = '1' AND c2s.`store_id` = '0' AND c.`status` = '1'
ORDER BY c.`sort_order`, LCASE(cd.`name`)

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

SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.`category_id` = cd.`category_id`)
LEFT JOIN `oc_category_to_store` c2s ON (c.`category_id` = c2s.`category_id`)
WHERE c.`parent_id` = '242' AND cd.`language_id` = '1' AND c2s.`store_id` = '0' AND c.`status` = '1'
ORDER BY c.`sort_order`, LCASE(cd.`name`)

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

SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.`category_id` = cd.`category_id`)
LEFT JOIN `oc_category_to_store` c2s ON (c.`category_id` = c2s.`category_id`)
WHERE c.`parent_id` = '251' AND cd.`language_id` = '1' AND c2s.`store_id` = '0' AND c.`status` = '1'
ORDER BY c.`sort_order`, LCASE(cd.`name`)

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

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

SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.`category_id` = cd.`category_id`)
LEFT JOIN `oc_category_to_store` c2s ON (c.`category_id` = c2s.`category_id`)
WHERE c.`parent_id` = '243' AND cd.`language_id` = '1' AND c2s.`store_id` = '0' AND c.`status` = '1'
ORDER BY c.`sort_order`, LCASE(cd.`name`)

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

SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.`category_id` = cd.`category_id`)
LEFT JOIN `oc_category_to_store` c2s ON (c.`category_id` = c2s.`category_id`)
WHERE c.`parent_id` = '241' AND cd.`language_id` = '1' AND c2s.`store_id` = '0' AND c.`status` = '1'
ORDER BY c.`sort_order`, LCASE(cd.`name`)

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

SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.`category_id` = cd.`category_id`)
LEFT JOIN `oc_category_to_store` c2s ON (c.`category_id` = c2s.`category_id`)
WHERE c.`parent_id` = '335' AND cd.`language_id` = '1' AND c2s.`store_id` = '0' AND c.`status` = '1'
ORDER BY c.`sort_order`, LCASE(cd.`name`)

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

SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.`category_id` = cd.`category_id`)
LEFT JOIN `oc_category_to_store` c2s ON (c.`category_id` = c2s.`category_id`)
WHERE c.`parent_id` = '224' AND cd.`language_id` = '1' AND c2s.`store_id` = '0' AND c.`status` = '1'
ORDER BY c.`sort_order`, LCASE(cd.`name`)

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

SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.`category_id` = cd.`category_id`)
LEFT JOIN `oc_category_to_store` c2s ON (c.`category_id` = c2s.`category_id`)
WHERE c.`parent_id` = '245' AND cd.`language_id` = '1' AND c2s.`store_id` = '0' AND c.`status` = '1'
ORDER BY c.`sort_order`, LCASE(cd.`name`)

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

SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.`category_id` = cd.`category_id`)
LEFT JOIN `oc_category_to_store` c2s ON (c.`category_id` = c2s.`category_id`)
WHERE c.`parent_id` = '247' AND cd.`language_id` = '1' AND c2s.`store_id` = '0' AND c.`status` = '1'
ORDER BY c.`sort_order`, LCASE(cd.`name`)

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

SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.`category_id` = cd.`category_id`)
LEFT JOIN `oc_category_to_store` c2s ON (c.`category_id` = c2s.`category_id`)
WHERE c.`parent_id` = '334' AND cd.`language_id` = '1' AND c2s.`store_id` = '0' AND c.`status` = '1'
ORDER BY c.`sort_order`, LCASE(cd.`name`)

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

SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.`category_id` = cd.`category_id`)
LEFT JOIN `oc_category_to_store` c2s ON (c.`category_id` = c2s.`category_id`)
WHERE c.`parent_id` = '395' AND cd.`language_id` = '1' AND c2s.`store_id` = '0' AND c.`status` = '1'
ORDER BY c.`sort_order`, LCASE(cd.`name`)

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

SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.`category_id` = cd.`category_id`)
LEFT JOIN `oc_category_to_store` c2s ON (c.`category_id` = c2s.`category_id`)
WHERE c.`parent_id` = '420' AND cd.`language_id` = '1' AND c2s.`store_id` = '0' AND c.`status` = '1'
ORDER BY c.`sort_order`, LCASE(cd.`name`)

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

SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.`category_id` = cd.`category_id`)
LEFT JOIN `oc_category_to_store` c2s ON (c.`category_id` = c2s.`category_id`)
WHERE c.`parent_id` = '401' AND cd.`language_id` = '1' AND c2s.`store_id` = '0' AND c.`status` = '1'
ORDER BY c.`sort_order`, LCASE(cd.`name`)

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

SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.`category_id` = cd.`category_id`)
LEFT JOIN `oc_category_to_store` c2s ON (c.`category_id` = c2s.`category_id`)
WHERE c.`parent_id` = '254' AND cd.`language_id` = '1' AND c2s.`store_id` = '0' AND c.`status` = '1'
ORDER BY c.`sort_order`, LCASE(cd.`name`)

SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.`category_id` = cd.`category_id`)
LEFT JOIN `oc_category_to_store` c2s ON (c.`category_id` = c2s.`category_id`)
WHERE c.`parent_id` = '294' AND cd.`language_id` = '1' AND c2s.`store_id` = '0' AND c.`status` = '1'
ORDER BY c.`sort_order`, LCASE(cd.`name`)

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

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

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

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

SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.`category_id` = cd.`category_id`)
LEFT JOIN `oc_category_to_store` c2s ON (c.`category_id` = c2s.`category_id`)
WHERE c.`parent_id` = '274' AND cd.`language_id` = '1' AND c2s.`store_id` = '0' AND c.`status` = '1'
ORDER BY c.`sort_order`, LCASE(cd.`name`)

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

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

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

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

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

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

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

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

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

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

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

SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.`category_id` = cd.`category_id`)
LEFT JOIN `oc_category_to_store` c2s ON (c.`category_id` = c2s.`category_id`)
WHERE c.`parent_id` = '298' AND cd.`language_id` = '1' AND c2s.`store_id` = '0' AND c.`status` = '1'
ORDER BY c.`sort_order`, LCASE(cd.`name`)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.`category_id` = cd.`category_id`)
LEFT JOIN `oc_category_to_store` c2s ON (c.`category_id` = c2s.`category_id`)
WHERE c.`parent_id` = '339' AND cd.`language_id` = '1' AND c2s.`store_id` = '0' AND c.`status` = '1'
ORDER BY c.`sort_order`, LCASE(cd.`name`)

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

SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.`category_id` = cd.`category_id`)
LEFT JOIN `oc_category_to_store` c2s ON (c.`category_id` = c2s.`category_id`)
WHERE c.`parent_id` = '357' AND cd.`language_id` = '1' AND c2s.`store_id` = '0' AND c.`status` = '1'
ORDER BY c.`sort_order`, LCASE(cd.`name`)

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

SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.`category_id` = cd.`category_id`)
LEFT JOIN `oc_category_to_store` c2s ON (c.`category_id` = c2s.`category_id`)
WHERE c.`parent_id` = '330' AND cd.`language_id` = '1' AND c2s.`store_id` = '0' AND c.`status` = '1'
ORDER BY c.`sort_order`, LCASE(cd.`name`)

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

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

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

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

SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.`category_id` = cd.`category_id`)
LEFT JOIN `oc_category_to_store` c2s ON (c.`category_id` = c2s.`category_id`)
WHERE c.`parent_id` = '365' AND cd.`language_id` = '1' AND c2s.`store_id` = '0' AND c.`status` = '1'
ORDER BY c.`sort_order`, LCASE(cd.`name`)

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

SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.`category_id` = cd.`category_id`)
LEFT JOIN `oc_category_to_store` c2s ON (c.`category_id` = c2s.`category_id`)
WHERE c.`parent_id` = '370' AND cd.`language_id` = '1' AND c2s.`store_id` = '0' AND c.`status` = '1'
ORDER BY c.`sort_order`, LCASE(cd.`name`)

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

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

SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.`category_id` = cd.`category_id`)
LEFT JOIN `oc_category_to_store` c2s ON (c.`category_id` = c2s.`category_id`)
WHERE c.`parent_id` = '286' AND cd.`language_id` = '1' AND c2s.`store_id` = '0' AND c.`status` = '1'
ORDER BY c.`sort_order`, LCASE(cd.`name`)

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

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

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

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

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

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` = 'path' AND `value` = '254_286_288' AND `store_id` = '0' AND `language_id` = '1'

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

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

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

SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.`category_id` = cd.`category_id`)
LEFT JOIN `oc_category_to_store` c2s ON (c.`category_id` = c2s.`category_id`)
WHERE c.`parent_id` = '382' AND cd.`language_id` = '1' AND c2s.`store_id` = '0' AND c.`status` = '1'
ORDER BY c.`sort_order`, LCASE(cd.`name`)

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

SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.`category_id` = cd.`category_id`)
LEFT JOIN `oc_category_to_store` c2s ON (c.`category_id` = c2s.`category_id`)
WHERE c.`parent_id` = '351' AND cd.`language_id` = '1' AND c2s.`store_id` = '0' AND c.`status` = '1'
ORDER BY c.`sort_order`, LCASE(cd.`name`)

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

SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.`category_id` = cd.`category_id`)
LEFT JOIN `oc_category_to_store` c2s ON (c.`category_id` = c2s.`category_id`)
WHERE c.`parent_id` = '361' AND cd.`language_id` = '1' AND c2s.`store_id` = '0' AND c.`status` = '1'
ORDER BY c.`sort_order`, LCASE(cd.`name`)

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

SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.`category_id` = cd.`category_id`)
LEFT JOIN `oc_category_to_store` c2s ON (c.`category_id` = c2s.`category_id`)
WHERE c.`parent_id` = '381' AND cd.`language_id` = '1' AND c2s.`store_id` = '0' AND c.`status` = '1'
ORDER BY c.`sort_order`, LCASE(cd.`name`)

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

SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.`category_id` = cd.`category_id`)
LEFT JOIN `oc_category_to_store` c2s ON (c.`category_id` = c2s.`category_id`)
WHERE c.`parent_id` = '297' AND cd.`language_id` = '1' AND c2s.`store_id` = '0' AND c.`status` = '1'
ORDER BY c.`sort_order`, LCASE(cd.`name`)

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

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

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

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

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

SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.`category_id` = cd.`category_id`)
LEFT JOIN `oc_category_to_store` c2s ON (c.`category_id` = c2s.`category_id`)
WHERE c.`parent_id` = '295' AND cd.`language_id` = '1' AND c2s.`store_id` = '0' AND c.`status` = '1'
ORDER BY c.`sort_order`, LCASE(cd.`name`)

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

SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.`category_id` = cd.`category_id`)
LEFT JOIN `oc_category_to_store` c2s ON (c.`category_id` = c2s.`category_id`)
WHERE c.`parent_id` = '368' AND cd.`language_id` = '1' AND c2s.`store_id` = '0' AND c.`status` = '1'
ORDER BY c.`sort_order`, LCASE(cd.`name`)

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

SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.`category_id` = cd.`category_id`)
LEFT JOIN `oc_category_to_store` c2s ON (c.`category_id` = c2s.`category_id`)
WHERE c.`parent_id` = '315' AND cd.`language_id` = '1' AND c2s.`store_id` = '0' AND c.`status` = '1'
ORDER BY c.`sort_order`, LCASE(cd.`name`)

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

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

SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.`category_id` = cd.`category_id`)
LEFT JOIN `oc_category_to_store` c2s ON (c.`category_id` = c2s.`category_id`)
WHERE c.`parent_id` = '321' AND cd.`language_id` = '1' AND c2s.`store_id` = '0' AND c.`status` = '1'
ORDER BY c.`sort_order`, LCASE(cd.`name`)

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

SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.`category_id` = cd.`category_id`)
LEFT JOIN `oc_category_to_store` c2s ON (c.`category_id` = c2s.`category_id`)
WHERE c.`parent_id` = '362' AND cd.`language_id` = '1' AND c2s.`store_id` = '0' AND c.`status` = '1'
ORDER BY c.`sort_order`, LCASE(cd.`name`)

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

SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.`category_id` = cd.`category_id`)
LEFT JOIN `oc_category_to_store` c2s ON (c.`category_id` = c2s.`category_id`)
WHERE c.`parent_id` = '255' AND cd.`language_id` = '1' AND c2s.`store_id` = '0' AND c.`status` = '1'
ORDER BY c.`sort_order`, LCASE(cd.`name`)

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

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

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` = 'path' AND `value` = '254_255_263' AND `store_id` = '0' AND `language_id` = '1'

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

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

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

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

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

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

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

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

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

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

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

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

SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.`category_id` = cd.`category_id`)
LEFT JOIN `oc_category_to_store` c2s ON (c.`category_id` = c2s.`category_id`)
WHERE c.`parent_id` = '283' AND cd.`language_id` = '1' AND c2s.`store_id` = '0' AND c.`status` = '1'
ORDER BY c.`sort_order`, LCASE(cd.`name`)

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

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

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

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

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

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

SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.`category_id` = cd.`category_id`)
LEFT JOIN `oc_category_to_store` c2s ON (c.`category_id` = c2s.`category_id`)
WHERE c.`parent_id` = '367' AND cd.`language_id` = '1' AND c2s.`store_id` = '0' AND c.`status` = '1'
ORDER BY c.`sort_order`, LCASE(cd.`name`)

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

SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.`category_id` = cd.`category_id`)
LEFT JOIN `oc_category_to_store` c2s ON (c.`category_id` = c2s.`category_id`)
WHERE c.`parent_id` = '393' AND cd.`language_id` = '1' AND c2s.`store_id` = '0' AND c.`status` = '1'
ORDER BY c.`sort_order`, LCASE(cd.`name`)

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

SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.`category_id` = cd.`category_id`)
LEFT JOIN `oc_category_to_store` c2s ON (c.`category_id` = c2s.`category_id`)
WHERE c.`parent_id` = '329' AND cd.`language_id` = '1' AND c2s.`store_id` = '0' AND c.`status` = '1'
ORDER BY c.`sort_order`, LCASE(cd.`name`)

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

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

SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.`category_id` = cd.`category_id`)
LEFT JOIN `oc_category_to_store` c2s ON (c.`category_id` = c2s.`category_id`)
WHERE c.`parent_id` = '317' AND cd.`language_id` = '1' AND c2s.`store_id` = '0' AND c.`status` = '1'
ORDER BY c.`sort_order`, LCASE(cd.`name`)

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

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

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

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

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

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

SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.`category_id` = cd.`category_id`)
LEFT JOIN `oc_category_to_store` c2s ON (c.`category_id` = c2s.`category_id`)
WHERE c.`parent_id` = '322' AND cd.`language_id` = '1' AND c2s.`store_id` = '0' AND c.`status` = '1'
ORDER BY c.`sort_order`, LCASE(cd.`name`)

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

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

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

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

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

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

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

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

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

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

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

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

SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.`category_id` = cd.`category_id`)
LEFT JOIN `oc_category_to_store` c2s ON (c.`category_id` = c2s.`category_id`)
WHERE c.`parent_id` = '316' AND cd.`language_id` = '1' AND c2s.`store_id` = '0' AND c.`status` = '1'
ORDER BY c.`sort_order`, LCASE(cd.`name`)

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

SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.`category_id` = cd.`category_id`)
LEFT JOIN `oc_category_to_store` c2s ON (c.`category_id` = c2s.`category_id`)
WHERE c.`parent_id` = '312' AND cd.`language_id` = '1' AND c2s.`store_id` = '0' AND c.`status` = '1'
ORDER BY c.`sort_order`, LCASE(cd.`name`)

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

SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.`category_id` = cd.`category_id`)
LEFT JOIN `oc_category_to_store` c2s ON (c.`category_id` = c2s.`category_id`)
WHERE c.`parent_id` = '421' AND cd.`language_id` = '1' AND c2s.`store_id` = '0' AND c.`status` = '1'
ORDER BY c.`sort_order`, LCASE(cd.`name`)

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

SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.`category_id` = cd.`category_id`)
LEFT JOIN `oc_category_to_store` c2s ON (c.`category_id` = c2s.`category_id`)
WHERE c.`parent_id` = '390' AND cd.`language_id` = '1' AND c2s.`store_id` = '0' AND c.`status` = '1'
ORDER BY c.`sort_order`, LCASE(cd.`name`)

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

SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.`category_id` = cd.`category_id`)
LEFT JOIN `oc_category_to_store` c2s ON (c.`category_id` = c2s.`category_id`)
WHERE c.`parent_id` = '285' AND cd.`language_id` = '1' AND c2s.`store_id` = '0' AND c.`status` = '1'
ORDER BY c.`sort_order`, LCASE(cd.`name`)

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

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

SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.`category_id` = cd.`category_id`)
LEFT JOIN `oc_category_to_store` c2s ON (c.`category_id` = c2s.`category_id`)
WHERE c.`parent_id` = '400' AND cd.`language_id` = '1' AND c2s.`store_id` = '0' AND c.`status` = '1'
ORDER BY c.`sort_order`, LCASE(cd.`name`)

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

SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.`category_id` = cd.`category_id`)
LEFT JOIN `oc_category_to_store` c2s ON (c.`category_id` = c2s.`category_id`)
WHERE c.`parent_id` = '419' AND cd.`language_id` = '1' AND c2s.`store_id` = '0' AND c.`status` = '1'
ORDER BY c.`sort_order`, LCASE(cd.`name`)

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

SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.`category_id` = cd.`category_id`)
LEFT JOIN `oc_category_to_store` c2s ON (c.`category_id` = c2s.`category_id`)
WHERE c.`parent_id` = '416' AND cd.`language_id` = '1' AND c2s.`store_id` = '0' AND c.`status` = '1'
ORDER BY c.`sort_order`, LCASE(cd.`name`)

SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.`category_id` = cd.`category_id`)
LEFT JOIN `oc_category_to_store` c2s ON (c.`category_id` = c2s.`category_id`)
WHERE c.`parent_id` = '417' AND cd.`language_id` = '1' AND c2s.`store_id` = '0' AND c.`status` = '1'
ORDER BY c.`sort_order`, LCASE(cd.`name`)

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

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'path' AND `value` = '416' 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/edit' AND `store_id` = '0' AND `language_id` = '1'

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

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'route' AND `value` = 'account/address' 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/download' 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_seo_url`
WHERE `key` = 'route' AND `value` = 'product/search' AND `store_id` = '0' AND `language_id` = '1'

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

SELECT *
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 id.`language_id` = '1' AND i2s.`store_id` = '0' AND i.`status` = '1'
ORDER BY i.`sort_order`, LCASE(id.`title`) ASC

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

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

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

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

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

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

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

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

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

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

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

SELECT *
FROM `oc_seo_url`
WHERE `key` = 'information_id' AND `value` = '5' 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` = 'information_id' AND `value` = '11' AND `store_id` = '0' AND `language_id` = '1'

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

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

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

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 (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_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 id.`language_id` = '1' AND i2s.`store_id` = '0' AND i.`status` = '1'
ORDER BY i.`sort_order`, LCASE(id.`title`) ASC

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` = '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` = '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:22:28'

REPLACE INTO `oc_customer_online` SET `ip` = '216.73.216.156', `customer_id` = '0', `url` = 'https://gajcom.si/index.php?_route_=/en/sitemap-en', `referer` = 'https://gajcom.si/sitemap-en', `date_added` = '2025-06-01 06:22:28'

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` = '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` = 'b5fd9e38db2caca8acbe7e9633' AND `expire` > '2025-06-01 04:22:27'

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` = 'sitemap-en' OR `keyword` LIKE '%/sitemap-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` = 'b5fd9e38db2caca8acbe7e9633'

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` = 'sitemap-en' OR `keyword` LIKE '%/sitemap-en') 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` = '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` = 'information/sitemap'

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

SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.`category_id` = cd.`category_id`)
LEFT JOIN `oc_category_to_store` c2s ON (c.`category_id` = c2s.`category_id`)
WHERE c.`parent_id` = '0' AND cd.`language_id` = '1' AND c2s.`store_id` = '0' AND c.`status` = '1'
ORDER BY c.`sort_order`, LCASE(cd.`name`)

SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.`category_id` = cd.`category_id`)
LEFT JOIN `oc_category_to_store` c2s ON (c.`category_id` = c2s.`category_id`)
WHERE c.`parent_id` = '422' AND cd.`language_id` = '1' AND c2s.`store_id` = '0' AND c.`status` = '1'
ORDER BY c.`sort_order`, LCASE(cd.`name`)

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

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

SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.`category_id` = cd.`category_id`)
LEFT JOIN `oc_category_to_store` c2s ON (c.`category_id` = c2s.`category_id`)
WHERE c.`parent_id` = '225' AND cd.`language_id` = '1' AND c2s.`store_id` = '0' AND c.`status` = '1'
ORDER BY c.`sort_order`, LCASE(cd.`name`)

SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.`category_id` = cd.`category_id`)
LEFT JOIN `oc_category_to_store` c2s ON (c.`category_id` = c2s.`category_id`)
WHERE c.`parent_id` = '396' AND cd.`language_id` = '1' AND c2s.`store_id` = '0' AND c.`status` = '1'
ORDER BY c.`sort_order`, LCASE(cd.`name`)

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

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

SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.`category_id` = cd.`category_id`)
LEFT JOIN `oc_category_to_store` c2s ON (c.`category_id` = c2s.`category_id`)
WHERE c.`parent_id` = '226' AND cd.`language_id` = '1' AND c2s.`store_id` = '0' AND c.`status` = '1'
ORDER BY c.`sort_order`, LCASE(cd.`name`)

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

SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.`category_id` = cd.`category_id`)
LEFT JOIN `oc_category_to_store` c2s ON (c.`category_id` = c2s.`category_id`)
WHERE c.`parent_id` = '227' AND cd.`language_id` = '1' AND c2s.`store_id` = '0' AND c.`status` = '1'
ORDER BY c.`sort_order`, LCASE(cd.`name`)

SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.`category_id` = cd.`category_id`)
LEFT JOIN `oc_category_to_store` c2s ON (c.`category_id` = c2s.`category_id`)
WHERE c.`parent_id` = '397' AND cd.`language_id` = '1' AND c2s.`store_id` = '0' AND c.`status` = '1'
ORDER BY c.`sort_order`, LCASE(cd.`name`)

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

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

SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.`category_id` = cd.`category_id`)
LEFT JOIN `oc_category_to_store` c2s ON (c.`category_id` = c2s.`category_id`)
WHERE c.`parent_id` = '228' AND cd.`language_id` = '1' AND c2s.`store_id` = '0' AND c.`status` = '1'
ORDER BY c.`sort_order`, LCASE(cd.`name`)

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

SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.`category_id` = cd.`category_id`)
LEFT JOIN `oc_category_to_store` c2s ON (c.`category_id` = c2s.`category_id`)
WHERE c.`parent_id` = '229' AND cd.`language_id` = '1' AND c2s.`store_id` = '0' AND c.`status` = '1'
ORDER BY c.`sort_order`, LCASE(cd.`name`)

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

SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.`category_id` = cd.`category_id`)
LEFT JOIN `oc_category_to_store` c2s ON (c.`category_id` = c2s.`category_id`)
WHERE c.`parent_id` = '230' AND cd.`language_id` = '1' AND c2s.`store_id` = '0' AND c.`status` = '1'
ORDER BY c.`sort_order`, LCASE(cd.`name`)

SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.`category_id` = cd.`category_id`)
LEFT JOIN `oc_category_to_store` c2s ON (c.`category_id` = c2s.`category_id`)
WHERE c.`parent_id` = '336' AND cd.`language_id` = '1' AND c2s.`store_id` = '0' AND c.`status` = '1'
ORDER BY c.`sort_order`, LCASE(cd.`name`)

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

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

SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.`category_id` = cd.`category_id`)
LEFT JOIN `oc_category_to_store` c2s ON (c.`category_id` = c2s.`category_id`)
WHERE c.`parent_id` = '337' AND cd.`language_id` = '1' AND c2s.`store_id` = '0' AND c.`status` = '1'
ORDER BY c.`sort_order`, LCASE(cd.`name`)

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

SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.`category_id` = cd.`category_id`)
LEFT JOIN `oc_category_to_store` c2s ON (c.`category_id` = c2s.`category_id`)
WHERE c.`parent_id` = '231' AND cd.`language_id` = '1' AND c2s.`store_id` = '0' AND c.`status` = '1'
ORDER BY c.`sort_order`, LCASE(cd.`name`)

SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.`category_id` = cd.`category_id`)
LEFT JOIN `oc_category_to_store` c2s ON (c.`category_id` = c2s.`category_id`)
WHERE c.`parent_id` = '418' AND cd.`language_id` = '1' AND c2s.`store_id` = '0' AND c.`status` = '1'
ORDER BY c.`sort_order`, LCASE(cd.`name`)

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

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

SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.`category_id` = cd.`category_id`)
LEFT JOIN `oc_category_to_store` c2s ON (c.`category_id` = c2s.`category_id`)
WHERE c.`parent_id` = '232' AND cd.`language_id` = '1' AND c2s.`store_id` = '0' AND c.`status` = '1'
ORDER BY c.`sort_order`, LCASE(cd.`name`)

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

SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.`category_id` = cd.`category_id`)
LEFT JOIN `oc_category_to_store` c2s ON (c.`category_id` = c2s.`category_id`)
WHERE c.`parent_id` = '233' AND cd.`language_id` = '1' AND c2s.`store_id` = '0' AND c.`status` = '1'
ORDER BY c.`sort_order`, LCASE(cd.`name`)

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

SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.`category_id` = cd.`category_id`)
LEFT JOIN `oc_category_to_store` c2s ON (c.`category_id` = c2s.`category_id`)
WHERE c.`parent_id` = '234' AND cd.`language_id` = '1' AND c2s.`store_id` = '0' AND c.`status` = '1'
ORDER BY c.`sort_order`, LCASE(cd.`name`)

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

SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.`category_id` = cd.`category_id`)
LEFT JOIN `oc_category_to_store` c2s ON (c.`category_id` = c2s.`category_id`)
WHERE c.`parent_id` = '235' AND cd.`language_id` = '1' AND c2s.`store_id` = '0' AND c.`status` = '1'
ORDER BY c.`sort_order`, LCASE(cd.`name`)

SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.`category_id` = cd.`category_id`)
LEFT JOIN `oc_category_to_store` c2s ON (c.`category_id` = c2s.`category_id`)
WHERE c.`parent_id` = '332' AND cd.`language_id` = '1' AND c2s.`store_id` = '0' AND c.`status` = '1'
ORDER BY c.`sort_order`, LCASE(cd.`name`)

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

SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.`category_id` = cd.`category_id`)
LEFT JOIN `oc_category_to_store` c2s ON (c.`category_id` = c2s.`category_id`)
WHERE c.`parent_id` = '331' AND cd.`language_id` = '1' AND c2s.`store_id` = '0' AND c.`status` = '1'
ORDER BY c.`sort_order`, LCASE(cd.`name`)

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

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

SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.`category_id` = cd.`category_id`)
LEFT JOIN `oc_category_to_store` c2s ON (c.`category_id` = c2s.`category_id`)
WHERE c.`parent_id` = '244' AND cd.`language_id` = '1' AND c2s.`store_id` = '0' AND c.`status` = '1'
ORDER BY c.`sort_order`, LCASE(cd.`name`)

SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.`category_id` = cd.`category_id`)
LEFT JOIN `oc_category_to_store` c2s ON (c.`category_id` = c2s.`category_id`)
WHERE c.`parent_id` = '410' AND cd.`language_id` = '1' AND c2s.`store_id` = '0' AND c.`status` = '1'
ORDER BY c.`sort_order`, LCASE(cd.`name`)

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

SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.`category_id` = cd.`category_id`)
LEFT JOIN `oc_category_to_store` c2s ON (c.`category_id` = c2s.`category_id`)
WHERE c.`parent_id` = '394' AND cd.`language_id` = '1' AND c2s.`store_id` = '0' AND c.`status` = '1'
ORDER BY c.`sort_order`, LCASE(cd.`name`)

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

SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.`category_id` = cd.`category_id`)
LEFT JOIN `oc_category_to_store` c2s ON (c.`category_id` = c2s.`category_id`)
WHERE c.`parent_id` = '411' AND cd.`language_id` = '1' AND c2s.`store_id` = '0' AND c.`status` = '1'
ORDER BY c.`sort_order`, LCASE(cd.`name`)

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

SELECT *
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.`category_id` = cd.`category_id`)
LEFT JOIN `oc_category_to_store` c2s ON (c.`category_id` = c2s.`category_id`)
WHERE c.`parent_id` = '408' AND cd.`language_id` = '1' AND c2s.`store_id` = '0' AND c.`status` = '1'
ORDER BY c.`sort_order`, LCASE(cd.`name`)