SELECT value FROM oc_setting WHERE store_id = '0' AND `key`='config_seo_url_type'
SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '0' AND (route = 'engb' OR route = '')
SELECT * FROM oc_extension WHERE `type` = 'openbay'
SELECT `data` FROM `oc_session` WHERE session_id = '54826bc34be29bece4920261de' AND expire > 1788352506
SELECT * FROM oc_store WHERE REPLACE(`ssl`, 'www.', '') = 'https://hortz.ru/'
SELECT * FROM `oc_setting` WHERE store_id = '0' OR store_id = '1' ORDER BY store_id ASC
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 = '176' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '0') 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 = '176' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '0') 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 * FROM oc_extension WHERE `type` = 'openbay'
SELECT * FROM `oc_event` WHERE `trigger` LIKE 'catalog/%' AND status = '1' ORDER BY `sort_order` ASC
SELECT category_id FROM oc_product_to_category WHERE product_id = '11022' ORDER BY main_category DESC LIMIT 1
SELECT * FROM oc_translation WHERE store_id = '1' AND language_id = '1' AND (route = 'extension/module/uni_othertext' OR route = 'ru-ru')
SELECT * FROM oc_translation WHERE store_id = '1' AND language_id = '1' AND (route = 'extension/module/uni_othertext' OR route = 'ru-ru')
SELECT * FROM oc_translation WHERE store_id = '1' AND language_id = '1' AND (route = 'product/product' OR route = 'ru-ru')
SELECT DISTINCT * 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.category_id = '853' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1'
SELECT DISTINCT * 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.category_id = '924' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1'
SELECT DISTINCT * 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.category_id = '975' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1'
SELECT DISTINCT * 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.category_id = '980' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1'
SELECT DISTINCT *, 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_hortz 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') 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) WHERE p.product_id = '11022' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '1'
SELECT product_id FROM oc_seo_url_dubli_3 WHERE product_id = 11022 UNION SELECT product_id FROM oc_seo_url_dubli_4 WHERE product_id = 11022
SELECT pu1.text1 as `url`, hl.meta_h1 as `name`
FROM `oc_product_all_tags_products` pu
left join `oc_product_all_tags_urls_products` pu1 ON pu.link_id = pu1.id
left join `oc_filter_vier_hl_lang` hl on hl.id = pu1.id
WHERE pu.`product_id` = 11022
UNION ALL
SELECT CONCAT('/', u.keyword, '/') as `url`, cd.name as `name`
FROM `oc_product_to_category` ptc
JOIN `oc_product` p ON p.product_id = ptc.product_id
JOIN `oc_category_description` cd ON cd.category_id = ptc.category_id
JOIN `oc_category` c ON c.category_id = ptc.category_id
JOIN `oc_seo_url` u ON u.query = CONCAT('category_id=', ptc.category_id) AND u.store_id = 0
WHERE p.`product_id` = 11022 AND ptc.category_id NOT IN (1095) AND c.parent_id > 0
SELECT `description` FROM `oc_product_description_hortz` WHERE `product_id` = 11022
SELECT short_code FROM oc_product_video WHERE product_id = 11022
SELECT DISTINCT
*
FROM
`oc_oct_product_extra_tabs` pet
LEFT JOIN
`oc_oct_extra_tabs` et
ON (et.extra_tab_id = pet.extra_tab_id)
LEFT JOIN
`oc_oct_extra_tabs_description` etd
ON (etd.extra_tab_id = pet.extra_tab_id)
WHERE
pet.product_id = '11022'
AND pet.language_id = '1'
AND etd.language_id = '1'
AND et.status = '1'
ORDER BY
et.sort_order ASC
SELECT * FROM oc_product_image WHERE product_id = '11022' ORDER BY sort_order ASC
SELECT DISTINCT
*
FROM
`oc_oct_product_extra_tabs` pet
LEFT JOIN
`oc_oct_extra_tabs` et
ON (et.extra_tab_id = pet.extra_tab_id)
LEFT JOIN
`oc_oct_extra_tabs_description` etd
ON (etd.extra_tab_id = pet.extra_tab_id)
WHERE
pet.product_id = '11022'
AND pet.language_id = '1'
AND etd.language_id = '1'
AND et.status = '1'
ORDER BY
et.sort_order ASC
SELECT * FROM oc_product_discount WHERE product_id = '11022' AND customer_group_id = '1' AND quantity > 1 AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY quantity ASC, priority ASC, price ASC
SELECT * FROM oc_product_option po LEFT JOIN `oc_option` o ON (po.option_id = o.option_id) LEFT JOIN oc_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '11022' AND od.language_id = '1' ORDER BY o.sort_order
SELECT * FROM oc_translation WHERE store_id = '1' AND language_id = '1' AND (route = 'extension/module/uni_othertext' OR route = 'ru-ru')
SELECT * FROM oc_translation WHERE store_id = '1' AND language_id = '1' AND (route = 'extension/module/uni_request' OR route = 'ru-ru')
SELECT date_end FROM `oc_product_special_hortz` WHERE product_id = '11022' AND customer_group_id = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, price ASC LIMIT 1
SELECT * FROM oc_translation WHERE store_id = '1' AND language_id = '1' AND (route = 'extension/module/uni_request' OR route = 'ru-ru')
SELECT * FROM oc_translation WHERE store_id = '1' AND language_id = '1' AND (route = 'extension/module/uni_othertext' OR route = 'ru-ru')
SELECT * FROM oc_translation WHERE store_id = '1' AND language_id = '1' AND (route = 'extension/module/uni_request' OR route = 'ru-ru')
SELECT * FROM oc_translation WHERE store_id = '1' AND language_id = '1' AND (route = 'product/product' OR route = 'ru-ru')
SELECT * FROM oc_translation WHERE store_id = '1' AND language_id = '1' AND (route = 'product/review' OR route = 'ru-ru')
SELECT * FROM oc_translation WHERE store_id = '1' AND language_id = '1' AND (route = 'account/register' OR route = 'ru-ru')
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 = '1' AND i.status = '1'
SELECT request_id, type, name, phone, mail, product_id, comment, admin_comment, date_added, date_modified, status FROM `oc_uni_request` WHERE request_id != '0' AND product_id = '11022' AND request_list = '1' AND status = '3' ORDER BY date_added DESC LIMIT 0,5
SELECT * FROM oc_theme WHERE store_id = '1' AND theme = 'unishop2' AND route = 'extension/module/uni_request_list'
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 = '1' AND i.status = '1'
SELECT * FROM oc_translation WHERE store_id = '1' AND language_id = '1' AND (route = 'product/product' OR route = 'ru-ru')
SELECT * FROM oc_translation WHERE store_id = '1' AND language_id = '1' AND (route = 'extension/module/uni_othertext' OR route = 'ru-ru')
SELECT category_id FROM `oc_product_to_category` WHERE product_id = '11022'
SELECT p.product_id FROM oc_product p LEFT JOIN `oc_product_to_category` p2c ON (p.product_id = p2c.product_id) LEFT JOIN `oc_product_to_store` p2s ON (p.product_id = p2s.product_id) WHERE p2c.category_id = '980' AND p.quantity > '0' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '1' AND p.product_id > '11022' GROUP BY p.product_id ORDER BY p.product_id ASC LIMIT 5
SELECT p.product_id FROM oc_product p LEFT JOIN `oc_product_to_category` p2c ON (p.product_id = p2c.product_id) LEFT JOIN `oc_product_to_store` p2s ON (p.product_id = p2s.product_id) WHERE p2c.category_id = '975' AND p.quantity > '0' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '1' AND p.product_id > '11022' GROUP BY p.product_id ORDER BY p.product_id ASC LIMIT 5
SELECT p.product_id FROM oc_product p LEFT JOIN `oc_product_to_category` p2c ON (p.product_id = p2c.product_id) LEFT JOIN `oc_product_to_store` p2s ON (p.product_id = p2s.product_id) WHERE p2c.category_id = '924' AND p.quantity > '0' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '1' AND p.product_id > '11022' GROUP BY p.product_id ORDER BY p.product_id ASC LIMIT 5
SELECT p.product_id FROM oc_product p LEFT JOIN `oc_product_to_category` p2c ON (p.product_id = p2c.product_id) LEFT JOIN `oc_product_to_store` p2s ON (p.product_id = p2s.product_id) WHERE p2c.category_id = '853' AND p.quantity > '0' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '1' AND p.product_id > '11022' GROUP BY p.product_id ORDER BY p.product_id ASC LIMIT 5
SELECT DISTINCT *, 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_hortz 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') 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) WHERE p.product_id = '11024' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '1'
SELECT DISTINCT *, 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_hortz 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') 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) WHERE p.product_id = '11036' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '1'
SELECT DISTINCT *, 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_hortz 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') 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) WHERE p.product_id = '11143' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '1'
SELECT DISTINCT *, 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_hortz 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') 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) WHERE p.product_id = '11144' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '1'
SELECT DISTINCT *, 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_hortz 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') 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) WHERE p.product_id = '11232' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '1'
SELECT * FROM oc_theme WHERE store_id = '1' AND theme = 'unishop2' AND route = 'extension/module/uni_auto_related'
SELECT * FROM oc_translation WHERE store_id = '1' AND language_id = '1' AND (route = 'product/product' OR route = 'ru-ru')
SELECT * FROM oc_translation WHERE store_id = '1' AND language_id = '1' AND (route = 'extension/module/uni_othertext' OR route = 'ru-ru')
SELECT * FROM oc_translation WHERE store_id = '1' AND language_id = '1' AND (route = 'extension/module/uni_reviews' OR route = 'ru-ru')
SELECT r.review_id, r.author, r.rating, r.text, r.plus, r.minus, r.admin_reply, r.votes_plus, r.votes_minus, r.reply, p.product_id, pd.name, p.price, p.image, r.date_added FROM oc_review r LEFT JOIN oc_product p ON (r.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) WHERE p.product_id = '11022' AND p.date_available <= NOW() AND p.status = '1' AND r.status = '1' AND pd.language_id = '1' ORDER BY r.date_added DESC LIMIT 0,5
SELECT * FROM oc_theme WHERE store_id = '1' AND theme = 'unishop2' AND route = 'product/review'
SELECT * FROM oc_translation WHERE store_id = '1' AND language_id = '1' AND (route = 'extension/module/uni_othertext' OR route = 'ru-ru')
SELECT * FROM oc_translation WHERE store_id = '1' AND language_id = '1' AND (route = 'extension/module/uni_request' OR route = 'ru-ru')
SELECT * FROM oc_translation WHERE store_id = '1' AND language_id = '1' AND (route = 'product/product' OR route = 'ru-ru')
SELECT * FROM oc_translation WHERE store_id = '1' AND language_id = '1' AND (route = 'product/product' OR route = 'ru-ru')
SELECT COUNT(*) AS total FROM oc_review r LEFT JOIN oc_product p ON (r.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) WHERE p.product_id = '11022' AND p.date_available <= NOW() AND p.status = '1' AND r.status = '1' AND pd.language_id = '1'
SELECT r.review_id, r.author, r.rating, r.text, r.plus, r.minus, r.admin_reply, r.votes_plus, r.votes_minus, r.reply, p.product_id, pd.name, p.price, p.image, r.date_added FROM oc_review r LEFT JOIN oc_product p ON (r.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) WHERE p.product_id = '11022' AND p.date_available <= NOW() AND p.status = '1' AND r.status = '1' AND pd.language_id = '1' ORDER BY r.date_added DESC LIMIT 0,5
SELECT * FROM oc_theme WHERE store_id = '1' AND theme = 'unishop2' AND route = 'product/review'
SELECT rating FROM oc_review WHERE product_id ='11022' AND status = '1'
SELECT a.attribute_id, ad.name, pa.text,
IFNULL((SELECT CONCAT((SELECT `seo_url` FROM `oc_url_filter_vier` WHERE `main_id` = a.attribute_id && `key_id` = 0),'~', (SELECT `seo_url` FROM `oc_url_filter_vier` WHERE `main_id` = a.attribute_id && `key_id` = (SELECT `text_id` FROM `oc_attribute_filter_vier` WHERE `product_id` = 11022 && `attribute_id` = a.attribute_id && `attr_text` = (SELECT `attr_text` FROM `oc_attribute_filter_vier_lang` WHERE `text` = pa.text && `attribute_id` = a.attribute_id))) ) FROM `oc_attribute_filter_vier` WHERE `product_id` = 11022 GROUP BY `product_id`),'') as `seo_url`,
(
SELECT `keyword` FROM `oc_seo_url` WHERE `query` like CONCAT('category_id=',(SELECT `category_id` FROM `oc_product_to_category` WHERE `product_id` = 11022 && `main_category` = 1 LIMIT 1))
&& `store_id` = 0
) as `category_url`
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.attribute_id != 330
AND pa.product_id = '11022'
AND a.attribute_group_id = '7'
AND ad.language_id = '1'
AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
SELECT DISTINCT `text` FROM `oc_product_attribute` WHERE `product_id` = 11022 && `attribute_id` = 155
SELECT DISTINCT p.product_id as `id`, p.article as `art_razmer`, (SELECT `keyword` FROM `oc_seo_url` WHERE `query` = CONCAT('product_id=',`id`) && `store_id` = 0 LIMIT 1) as `url`,pa.text, (SELECT `text` FROM `oc_product_attribute` WHERE `attribute_id` = 155 && `text` LIKE '%-%' && `product_id` = `id` limit 1) as `dop_text1` FROM oc_product p
LEFT JOIN oc_product_to_category ptc on ptc.product_id = p.product_id
LEFT JOIN oc_product_attribute pa on pa.product_id = p.product_id
WHERE p.price > 0 AND `ptc`.`category_id` = 980 && `ptc`.`main_category` = 1 && pa.attribute_id = 182 && p.status = 1 && p.manufacturer_id = 563 ORDER BY CAST(pa.text AS UNSIGNED)
SELECT DISTINCT * FROM oc_product_to_category ptc LEFT JOIN oc_product p ON (ptc.product_id = p.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE p.product_id != '11022' AND p.status = '1' AND ptc.category_id = '980' AND p.date_available <= NOW() AND p2s.store_id = '1' AND p.price > 0 AND p.quantity > 0 ORDER BY RAND() LIMIT 5
SELECT DISTINCT *, 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_hortz 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') 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) WHERE p.product_id = '3822' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '1'
SELECT DISTINCT *, 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_hortz 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') 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) WHERE p.product_id = '3168' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '1'
SELECT DISTINCT *, 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_hortz 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') 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) WHERE p.product_id = '256126' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '1'
SELECT DISTINCT *, 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_hortz 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') 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) WHERE p.product_id = '243346' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '1'
SELECT DISTINCT *, 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_hortz 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') 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) WHERE p.product_id = '171034' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '1'
SELECT * FROM oc_theme WHERE store_id = '1' AND theme = 'unishop2' AND route = 'octemplates/module/oct_products_modules'
SELECT rd.* FROM oc_product_recurring pr JOIN oc_recurring_description rd ON (rd.language_id = 1 AND rd.recurring_id = pr.recurring_id) JOIN oc_recurring r ON r.recurring_id = rd.recurring_id WHERE pr.product_id = 11022 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC
SELECT * FROM `oc_module` WHERE `code` LIKE 'oct_product_views'
UPDATE oc_product SET viewed = (viewed + 1) WHERE product_id = '11022'
SELECT * FROM oc_product_to_category WHERE product_id = '11022'
SELECT DISTINCT * 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.category_id = '853' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1'
SELECT * FROM oc_product_to_layout WHERE product_id = '11022' AND store_id = '1'
SELECT * FROM oc_layout_route WHERE 'product/product' LIKE route AND store_id = '1' ORDER BY route DESC LIMIT 1
SELECT * FROM oc_layout_module WHERE layout_id = '22' AND position = 'column_left' ORDER BY sort_order
SELECT * FROM oc_theme WHERE store_id = '1' AND theme = 'unishop2' AND route = 'common/column_left'
SELECT * FROM oc_product_to_layout WHERE product_id = '11022' AND store_id = '1'
SELECT * FROM oc_layout_route WHERE 'product/product' LIKE route AND store_id = '1' ORDER BY route DESC LIMIT 1
SELECT * FROM oc_layout_module WHERE layout_id = '22' AND position = 'column_right' ORDER BY sort_order
SELECT * FROM oc_theme WHERE store_id = '1' AND theme = 'unishop2' AND route = 'common/column_right'
SELECT * FROM oc_product_to_layout WHERE product_id = '11022' AND store_id = '1'
SELECT * FROM oc_layout_route WHERE 'product/product' LIKE route AND store_id = '1' ORDER BY route DESC LIMIT 1
SELECT * FROM oc_layout_module WHERE layout_id = '22' AND position = 'content_top' ORDER BY sort_order
SELECT * FROM oc_theme WHERE store_id = '1' AND theme = 'unishop2' AND route = 'common/content_top'
SELECT * FROM oc_product_to_layout WHERE product_id = '11022' AND store_id = '1'
SELECT * FROM oc_layout_route WHERE 'product/product' LIKE route AND store_id = '1' ORDER BY route DESC LIMIT 1
SELECT * FROM oc_layout_module WHERE layout_id = '22' AND position = 'content_bottom' ORDER BY sort_order
SELECT * FROM oc_module WHERE module_id = '45'
SELECT * FROM oc_translation WHERE store_id = '1' AND language_id = '1' AND (route = 'extension/module/uni_viewed' OR route = 'ru-ru')
SELECT * FROM oc_theme WHERE store_id = '1' AND theme = 'unishop2' AND route = 'common/content_bottom'
SELECT * FROM oc_translation WHERE store_id = '1' AND language_id = '1' AND (route = 'common/footer' OR route = 'ru-ru')
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 = '1' AND i.status = '1' ORDER BY i.sort_order, LCASE(id.title) ASC
SELECT * FROM oc_translation WHERE store_id = '1' AND language_id = '1' AND (route = 'extension/module/uni_othertext' OR route = 'ru-ru')
SELECT * FROM oc_theme WHERE store_id = '1' AND theme = 'unishop2' AND route = 'extension/module/uni_notification'
SELECT * FROM oc_theme WHERE store_id = '1' AND theme = 'unishop2' AND route = 'common/footer'
SELECT * FROM oc_extension WHERE `type` = 'analytics'
SELECT * FROM oc_translation WHERE store_id = '1' AND language_id = '1' AND (route = 'common/header' OR route = 'ru-ru')
SELECT * FROM oc_translation WHERE store_id = '1' AND language_id = '1' AND (route = 'common/language' OR route = 'ru-ru')
SELECT * FROM oc_theme WHERE store_id = '1' AND theme = 'unishop2' AND route = 'common/language'
SELECT * FROM oc_translation WHERE store_id = '1' AND language_id = '1' AND (route = 'common/currency' OR route = 'ru-ru')
SELECT * FROM oc_theme WHERE store_id = '1' AND theme = 'unishop2' AND route = 'common/currency'
SELECT * FROM oc_translation WHERE store_id = '1' AND language_id = '1' AND (route = 'common/search' OR route = 'ru-ru')
SELECT * FROM oc_translation WHERE store_id = '1' AND language_id = '1' AND (route = 'extension/module/uni_othertext' OR route = 'ru-ru')
SELECT * FROM oc_theme WHERE store_id = '1' AND theme = 'unishop2' AND route = 'common/search'
SELECT * FROM oc_translation WHERE store_id = '1' AND language_id = '1' AND (route = 'extension/module/uni_othertext' OR route = 'ru-ru')
SELECT * FROM oc_translation WHERE store_id = '1' AND language_id = '1' AND (route = 'common/cart' OR route = 'ru-ru')
SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '54826bc34be29bece4920261de'
SELECT * FROM oc_extension WHERE `type` = 'total'
SELECT * FROM oc_translation WHERE store_id = '1' AND language_id = '1' AND (route = 'extension/total/sub_total' OR route = 'ru-ru')
SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '54826bc34be29bece4920261de'
SELECT * FROM oc_translation WHERE store_id = '1' AND language_id = '1' AND (route = 'extension/total/credit' OR route = 'ru-ru')
SELECT SUM(amount) AS total FROM oc_customer_transaction WHERE customer_id = '0'
SELECT * FROM oc_translation WHERE store_id = '1' AND language_id = '1' AND (route = 'extension/total/total' OR route = 'ru-ru')
SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '54826bc34be29bece4920261de'
SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '54826bc34be29bece4920261de'
SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '54826bc34be29bece4920261de'
SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '54826bc34be29bece4920261de'
SELECT * FROM oc_theme WHERE store_id = '1' AND theme = 'unishop2' AND route = 'common/cart'
SELECT * FROM oc_translation WHERE store_id = '1' AND language_id = '1' AND (route = 'common/menu' OR route = 'ru-ru')
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 = '1' 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 = '1' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '2' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '16' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1038' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '4' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '9' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1099' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '11' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '58' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '64' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1100' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '69' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1076' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '106' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '107' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '112' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '169' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1118' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1042' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1079' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '168' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '501' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '170' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '171' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1022' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '172' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '175' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1715' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '2451' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1723' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '176' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '2453' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '195' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1714' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '200' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '201' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '203' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1030' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1718' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1719' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1716' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '209' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1742' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1721' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1722' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '2454' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1720' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1717' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1724' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '2452' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '216' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1018' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '218' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '228' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '229' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '221' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1120' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '342' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '236' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '245' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '255' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '268' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '270' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '414' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '291' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '307' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '327' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '331' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1' AND c.status = '1' ORDER BY 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 = '333' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '343' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '345' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '347' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '358' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '354' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '359' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '360' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '362' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '369' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '376' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '382' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '383' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '395' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '355' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1' AND c.status = '1' ORDER BY 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 = '1' AND c.status = '1' ORDER BY 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 = '1' AND c.status = '1' ORDER BY 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 = '445' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '471' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '446' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '502' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1102' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1127' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '545' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '579' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '582' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '583' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '584' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '586' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '588' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '589' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '581' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '140' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1040' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '595' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '2450' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '596' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '602' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '611' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '597' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '639' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '805' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '807' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1122' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1126' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '2112' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '824' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '825' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '828' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '829' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1117' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '2114' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '843' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '850' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1133' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '853' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '854' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '924' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1317' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1319' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1443' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '2447' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1321' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1442' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1454' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1450' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1463' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1447' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1448' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1451' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1499' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1446' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1455' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1320' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1457' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1441' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1445' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1453' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1458' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1459' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1460' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1712' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1756' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1757' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1770' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1758' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1759' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1767' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1768' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1769' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1771' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1772' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1773' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1774' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1780' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1783' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1784' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1792' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1795' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1797' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1804' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1809' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1812' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1813' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1814' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1819' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1318' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1327' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1330' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1328' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1325' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1323' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1324' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1322' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1329' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1326' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '2207' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '2208' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '2293' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '2294' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '2299' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '2302' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1041' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '2306' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '2319' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '2325' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '2326' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '2224' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '2339' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '2344' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '2345' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '2346' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '2347' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '2348' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '2357' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '2358' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '2359' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '2286' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '2360' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '2374' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '2375' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '2376' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '2377' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '2378' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '2379' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '2384' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '2385' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '2261' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1136' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1259' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '2386' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1276' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1248' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1286' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1156' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1222' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1195' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1230' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1137' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1149' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1743' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1744' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1745' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1746' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1747' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1748' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1749' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1750' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1751' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1753' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '2196' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1754' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1755' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1826' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1827' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1828' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1831' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1832' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1833' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1834' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1835' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1836' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1837' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1838' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1841' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1842' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1848' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1849' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1853' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '2128' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1862' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '2129' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '2130' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1874' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1886' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1888' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1889' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1908' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1909' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1932' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '2131' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1942' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1946' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1955' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1956' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '2132' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1957' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1968' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '1969' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '2037' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '2133' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '2048' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '2061' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '2135' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '2136' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '2126' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '2137' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '2127' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '2138' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '2197' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '2200' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '2458' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '2493' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '2459' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '2494' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '2464' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '2465' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '2466' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '2479' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '2486' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '2467' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '2495' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '2484' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '2470' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '2487' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '2485' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '2490' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '2476' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '2496' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '2480' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '2474' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '3629' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '2489' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '2482' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '2497' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '2492' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '2483' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '2468' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '2473' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '2472' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '2475' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '2471' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '2481' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '2477' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '2498' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '2488' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '2478' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '2469' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '3299' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '3300' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '3301' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '3304' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '3427' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '3306' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '3319' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '3501' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '3506' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '3531' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '3509' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '3494' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '3513' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '3522' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '3445' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '3518' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '3519' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '3488' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '3491' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '3495' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '3567' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '3423' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '3305' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '3316' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '3312' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '3403' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '3440' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '3486' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '3451' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '3325' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '3597' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '3600' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '3603' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '3478' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '3613' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '3619' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '3631' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '3632' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '3633' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '3634' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '2107' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '3635' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '3636' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY 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 = '3637' AND cd.language_id = '1' AND c2s.store_id = '1' AND c.status = '1' ORDER BY LCASE(cd.name)
SELECT * FROM oc_theme WHERE store_id = '1' AND theme = 'unishop2' AND route = 'common/menu'
SELECT * FROM oc_translation WHERE store_id = '1' AND language_id = '1' AND (route = 'extension/module/uni_othertext' OR route = 'ru-ru')
SELECT * FROM oc_theme WHERE store_id = '1' AND theme = 'unishop2' AND route = 'common/header'
SELECT * FROM oc_setting WHERE store_id = '1' AND `code` = 'advertise_google'
SELECT * FROM oc_theme WHERE store_id = '1' AND theme = 'unishop2' AND route = 'octemplates/module/oct_breadcrumbs'
SELECT * FROM oc_theme WHERE store_id = '1' AND theme = 'unishop2' AND route = 'product/product'
SELECT * FROM oc_setting WHERE store_id = '1' AND `code` = 'advertise_google'
Калибр-пробка М 16х1.0 8g КИ-НЕ ЧИЗ купить в Москве по доступной цене
Мы предлагаем удобные условия доставки для наших клиентов, чтобы вы могли получить заказ максимально быстро и комфортно.
Способы доставки
Самовывоз
Вы можете самостоятельно забрать заказ по адресу: г. Москва, ул. Электродная, д. 2, стр. 19.
Подробную схему проезда можно найти в разделе Контакты.
Самовывоз возможен только после подтверждения заказа менеджером.
Курьерская доставка по Москве и Московской области
Курьерская доставка до двери осуществляется (в том числе курьерскими службами и транспортными компаниями) по предварительному согласованию с персональным менеджером. Стоимость и сроки доставки зависят от объема и адреса.
Доставка до транспортных компаний
Мы бесплатно доставляем ваш заказ от нашего склада до транспортных компаний в Москве.
Вы можете выбрать любую транспортную компанию для дальнейшей доставки, включая СДЭК, ПЭК, Деловые Линии и другие.
Региональная доставка
Доставка в регионы России осуществляется через транспортные компании. Мы бесплатно доставляем ваш заказ от нашего склада до транспортных компаний в Москве. Услуги транспортных компаний оплачиваются клиентом отдельно, согласно их тарифам. Вы можете выбрать любую транспортную компанию для дальнейшей доставки, включая СДЭК, ПЭК, Деловые Линии и другие.
Сроки доставки
Средние сроки доставки зависят от вашего региона и выбранного способа:
По Москве и области: от 1 до 3 рабочих дней.
По регионам России: от 2 до 14 рабочих дней.
Часто задаваемые вопросы по доставке
Где можно забрать заказ самостоятельно?
Вы можете забрать заказ по адресу: г. Москва, ул. Электродная, д. 2, стр. 19. Самовывоз возможен только после подтверждения заказа менеджером.
Доставляете ли вы заказы до транспортных компаний?
Да, мы бесплатно доставляем заказы от нашего склада до транспортных компаний в Москве. Вы можете выбрать любую удобную транспортную компанию для дальнейшей доставки.
Как осуществляется доставка по Москве и Московской области?
Доставка до двери по Москве и области согласовывается индивидуально с персональным менеджером. Условия и стоимость зависят от объема заказа и адреса доставки.
Сколько времени занимает доставка?
По Москве и области: от 1 до 3 рабочих дней.
В регионы России: от 2 до 14 рабочих дней, в зависимости от удалённости региона и работы транспортной компании.
Оплата
Мы предлагаем удобные варианты оплаты как для физических, так и для юридических лиц.
Оплата для физических лиц
Оформите заказ через корзину на нашем сайте, указав адрес доставки или самовывоз.
После оформления наш менеджер свяжется с вами, забронирует товар на 3 рабочих дня и отправит ссылку и QR-код для оплаты в электронном письме.
Оплатите товар по предоставленной ссылке или QR-коду.
После оплаты вы получите чек от платежной системы на указанный электронный адрес.
Мы отправим вам товар и универсальный передаточный документ (УПД).
Оплата для юридических лиц
Оформите заказ через корзину на сайте или отправьте заявку с перечнем товаров на нашу электронную почту.
Менеджер свяжется с вами, забронирует товар и отправит счёт на оплату.
Оплатите счёт.
После получения оплаты мы отправим товар вместе с необходимыми документами.
Особенности работы с юридическими лицами:
Для российских организаций мы работаем с НДС.
Для компаний из Республики Беларусь и Республики Казахстан товары предоставляются без НДС.
Часто задаваемые вопросы об оплате
Какие способы оплаты доступны для физических лиц?
Для физических лиц оплата осуществляется по ссылке или QR-коду, которые отправляет наш менеджер в электронном письме после оформления заказа.
Можно ли оплатить заказ от юридического лица с НДС?
Да, для российских юридических лиц мы работаем с НДС. Для компаний из Республики Беларусь и Казахстан товары предоставляются без НДС.
Что делать, если я не успел оплатить заказ в течение 3 рабочих дней?
Если вы не успели оплатить заказ, бронь на товар может быть снята. В этом случае свяжитесь с нашим менеджером, чтобы продлить срок или оформить заказ повторно.
Какие документы я получу после оплаты?
Физические лица получают чек от платежной системы и универсальный передаточный документ (УПД). Юридические лица получают товар вместе с пакетом необходимых документов, включая накладные и счет-фактуру (при необходимости).