SELECT * FROM oc_DB_store WHERE REPLACE(`url`, 'www.', '') = 'http://radarrc.cn/'

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

SELECT * FROM oc_DB_language

SELECT * FROM oc_DB_currency

SELECT tr.tax_class_id, tr.rate, tr.description, tr.priority FROM oc_DB_tax_rate tr LEFT JOIN oc_DB_zone_to_geo_zone z2gz ON (tr.geo_zone_id = z2gz.geo_zone_id) LEFT JOIN oc_DB_geo_zone gz ON (tr.geo_zone_id = gz.geo_zone_id) WHERE (z2gz.country_id = '0' OR z2gz.country_id = '0') AND (z2gz.zone_id = '0' OR z2gz.zone_id = '0') ORDER BY tr.priority ASC

SELECT * FROM oc_DB_weight_class wc LEFT JOIN oc_DB_weight_class_description wcd ON (wc.weight_class_id = wcd.weight_class_id) WHERE wcd.language_id = '1'

SELECT * FROM oc_DB_length_class mc LEFT JOIN oc_DB_length_class_description mcd ON (mc.length_class_id = mcd.length_class_id) WHERE mcd.language_id = '1'

SELECT * FROM oc_DB_layout_route WHERE 'common/home' LIKE CONCAT(route, '%') AND store_id = '0' ORDER BY route ASC LIMIT 1

SELECT * FROM oc_DB_extension WHERE `type` = 'module'

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

SELECT * FROM oc_DB_category c LEFT JOIN oc_DB_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_DB_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '59' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT category_id FROM oc_DB_category WHERE parent_id = '59'

SELECT COUNT(*) AS total FROM oc_DB_product p LEFT JOIN oc_DB_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_DB_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.product_id IN (SELECT p2c.product_id FROM oc_DB_product_to_category p2c WHERE p2c.category_id = '59')

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=59'

SELECT * FROM oc_DB_category c LEFT JOIN oc_DB_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_DB_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '60' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT category_id FROM oc_DB_category WHERE parent_id = '122'

SELECT COUNT(*) AS total FROM oc_DB_product p LEFT JOIN oc_DB_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_DB_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.product_id IN (SELECT p2c.product_id FROM oc_DB_product_to_category p2c WHERE p2c.category_id = '122')

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=60'

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=122'

SELECT category_id FROM oc_DB_category WHERE parent_id = '124'

SELECT COUNT(*) AS total FROM oc_DB_product p LEFT JOIN oc_DB_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_DB_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.product_id IN (SELECT p2c.product_id FROM oc_DB_product_to_category p2c WHERE p2c.category_id = '124')

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=60'

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=124'

SELECT category_id FROM oc_DB_category WHERE parent_id = '127'

SELECT COUNT(*) AS total FROM oc_DB_product p LEFT JOIN oc_DB_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_DB_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.product_id IN (SELECT p2c.product_id FROM oc_DB_product_to_category p2c WHERE p2c.category_id = '127')

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=60'

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=127'

SELECT category_id FROM oc_DB_category WHERE parent_id = '126'

SELECT COUNT(*) AS total FROM oc_DB_product p LEFT JOIN oc_DB_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_DB_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.product_id IN (SELECT p2c.product_id FROM oc_DB_product_to_category p2c WHERE p2c.category_id = '126')

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=60'

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=126'

SELECT category_id FROM oc_DB_category WHERE parent_id = '125'

SELECT COUNT(*) AS total FROM oc_DB_product p LEFT JOIN oc_DB_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_DB_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.product_id IN (SELECT p2c.product_id FROM oc_DB_product_to_category p2c WHERE p2c.category_id = '125')

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=60'

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=125'

SELECT category_id FROM oc_DB_category WHERE parent_id = '129'

SELECT COUNT(*) AS total FROM oc_DB_product p LEFT JOIN oc_DB_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_DB_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.product_id IN (SELECT p2c.product_id FROM oc_DB_product_to_category p2c WHERE p2c.category_id = '129')

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=60'

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=129'

SELECT category_id FROM oc_DB_category WHERE parent_id = '128'

SELECT COUNT(*) AS total FROM oc_DB_product p LEFT JOIN oc_DB_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_DB_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.product_id IN (SELECT p2c.product_id FROM oc_DB_product_to_category p2c WHERE p2c.category_id = '128')

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=60'

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=128'

SELECT category_id FROM oc_DB_category WHERE parent_id = '123'

SELECT COUNT(*) AS total FROM oc_DB_product p LEFT JOIN oc_DB_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_DB_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.product_id IN (SELECT p2c.product_id FROM oc_DB_product_to_category p2c WHERE p2c.category_id = '123')

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=60'

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=123'

SELECT category_id FROM oc_DB_category WHERE parent_id = '60'

SELECT category_id FROM oc_DB_category WHERE parent_id = '122'

SELECT category_id FROM oc_DB_category WHERE parent_id = '123'

SELECT category_id FROM oc_DB_category WHERE parent_id = '124'

SELECT category_id FROM oc_DB_category WHERE parent_id = '125'

SELECT category_id FROM oc_DB_category WHERE parent_id = '126'

SELECT category_id FROM oc_DB_category WHERE parent_id = '127'

SELECT category_id FROM oc_DB_category WHERE parent_id = '128'

SELECT category_id FROM oc_DB_category WHERE parent_id = '129'

SELECT COUNT(*) AS total FROM oc_DB_product p LEFT JOIN oc_DB_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_DB_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.product_id IN (SELECT p2c.product_id FROM oc_DB_product_to_category p2c WHERE p2c.category_id = '129' OR p2c.category_id = '128' OR p2c.category_id = '127' OR p2c.category_id = '126' OR p2c.category_id = '125' OR p2c.category_id = '124' OR p2c.category_id = '123' OR p2c.category_id = '122' OR p2c.category_id = '60')

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=60'

SELECT * FROM oc_DB_category c LEFT JOIN oc_DB_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_DB_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '61' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT category_id FROM oc_DB_category WHERE parent_id = '62'

SELECT COUNT(*) AS total FROM oc_DB_product p LEFT JOIN oc_DB_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_DB_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.product_id IN (SELECT p2c.product_id FROM oc_DB_product_to_category p2c WHERE p2c.category_id = '62')

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=61'

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=62'

SELECT category_id FROM oc_DB_category WHERE parent_id = '64'

SELECT COUNT(*) AS total FROM oc_DB_product p LEFT JOIN oc_DB_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_DB_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.product_id IN (SELECT p2c.product_id FROM oc_DB_product_to_category p2c WHERE p2c.category_id = '64')

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=61'

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=64'

SELECT category_id FROM oc_DB_category WHERE parent_id = '67'

SELECT COUNT(*) AS total FROM oc_DB_product p LEFT JOIN oc_DB_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_DB_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.product_id IN (SELECT p2c.product_id FROM oc_DB_product_to_category p2c WHERE p2c.category_id = '67')

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=61'

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=67'

SELECT category_id FROM oc_DB_category WHERE parent_id = '66'

SELECT COUNT(*) AS total FROM oc_DB_product p LEFT JOIN oc_DB_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_DB_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.product_id IN (SELECT p2c.product_id FROM oc_DB_product_to_category p2c WHERE p2c.category_id = '66')

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=61'

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=66'

SELECT category_id FROM oc_DB_category WHERE parent_id = '65'

SELECT COUNT(*) AS total FROM oc_DB_product p LEFT JOIN oc_DB_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_DB_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.product_id IN (SELECT p2c.product_id FROM oc_DB_product_to_category p2c WHERE p2c.category_id = '65')

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=61'

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=65'

SELECT category_id FROM oc_DB_category WHERE parent_id = '69'

SELECT COUNT(*) AS total FROM oc_DB_product p LEFT JOIN oc_DB_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_DB_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.product_id IN (SELECT p2c.product_id FROM oc_DB_product_to_category p2c WHERE p2c.category_id = '69')

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=61'

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=69'

SELECT category_id FROM oc_DB_category WHERE parent_id = '68'

SELECT COUNT(*) AS total FROM oc_DB_product p LEFT JOIN oc_DB_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_DB_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.product_id IN (SELECT p2c.product_id FROM oc_DB_product_to_category p2c WHERE p2c.category_id = '68')

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=61'

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=68'

SELECT category_id FROM oc_DB_category WHERE parent_id = '63'

SELECT COUNT(*) AS total FROM oc_DB_product p LEFT JOIN oc_DB_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_DB_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.product_id IN (SELECT p2c.product_id FROM oc_DB_product_to_category p2c WHERE p2c.category_id = '63')

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=61'

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=63'

SELECT category_id FROM oc_DB_category WHERE parent_id = '61'

SELECT category_id FROM oc_DB_category WHERE parent_id = '69'

SELECT category_id FROM oc_DB_category WHERE parent_id = '68'

SELECT category_id FROM oc_DB_category WHERE parent_id = '67'

SELECT category_id FROM oc_DB_category WHERE parent_id = '66'

SELECT category_id FROM oc_DB_category WHERE parent_id = '65'

SELECT category_id FROM oc_DB_category WHERE parent_id = '64'

SELECT category_id FROM oc_DB_category WHERE parent_id = '63'

SELECT category_id FROM oc_DB_category WHERE parent_id = '62'

SELECT COUNT(*) AS total FROM oc_DB_product p LEFT JOIN oc_DB_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_DB_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.product_id IN (SELECT p2c.product_id FROM oc_DB_product_to_category p2c WHERE p2c.category_id = '62' OR p2c.category_id = '63' OR p2c.category_id = '64' OR p2c.category_id = '65' OR p2c.category_id = '66' OR p2c.category_id = '67' OR p2c.category_id = '68' OR p2c.category_id = '69' OR p2c.category_id = '61')

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=61'

SELECT * FROM oc_DB_category c LEFT JOIN oc_DB_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_DB_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '70' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT category_id FROM oc_DB_category WHERE parent_id = '71'

SELECT COUNT(*) AS total FROM oc_DB_product p LEFT JOIN oc_DB_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_DB_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.product_id IN (SELECT p2c.product_id FROM oc_DB_product_to_category p2c WHERE p2c.category_id = '71')

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=70'

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=71'

SELECT category_id FROM oc_DB_category WHERE parent_id = '72'

SELECT COUNT(*) AS total FROM oc_DB_product p LEFT JOIN oc_DB_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_DB_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.product_id IN (SELECT p2c.product_id FROM oc_DB_product_to_category p2c WHERE p2c.category_id = '72')

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=70'

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=72'

SELECT category_id FROM oc_DB_category WHERE parent_id = '73'

SELECT COUNT(*) AS total FROM oc_DB_product p LEFT JOIN oc_DB_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_DB_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.product_id IN (SELECT p2c.product_id FROM oc_DB_product_to_category p2c WHERE p2c.category_id = '73')

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=70'

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=73'

SELECT category_id FROM oc_DB_category WHERE parent_id = '74'

SELECT COUNT(*) AS total FROM oc_DB_product p LEFT JOIN oc_DB_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_DB_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.product_id IN (SELECT p2c.product_id FROM oc_DB_product_to_category p2c WHERE p2c.category_id = '74')

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=70'

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=74'

SELECT category_id FROM oc_DB_category WHERE parent_id = '76'

SELECT COUNT(*) AS total FROM oc_DB_product p LEFT JOIN oc_DB_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_DB_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.product_id IN (SELECT p2c.product_id FROM oc_DB_product_to_category p2c WHERE p2c.category_id = '76')

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=70'

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=76'

SELECT category_id FROM oc_DB_category WHERE parent_id = '75'

SELECT COUNT(*) AS total FROM oc_DB_product p LEFT JOIN oc_DB_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_DB_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.product_id IN (SELECT p2c.product_id FROM oc_DB_product_to_category p2c WHERE p2c.category_id = '75')

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=70'

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=75'

SELECT category_id FROM oc_DB_category WHERE parent_id = '70'

SELECT category_id FROM oc_DB_category WHERE parent_id = '73'

SELECT category_id FROM oc_DB_category WHERE parent_id = '74'

SELECT category_id FROM oc_DB_category WHERE parent_id = '75'

SELECT category_id FROM oc_DB_category WHERE parent_id = '76'

SELECT category_id FROM oc_DB_category WHERE parent_id = '72'

SELECT category_id FROM oc_DB_category WHERE parent_id = '71'

SELECT COUNT(*) AS total FROM oc_DB_product p LEFT JOIN oc_DB_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_DB_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.product_id IN (SELECT p2c.product_id FROM oc_DB_product_to_category p2c WHERE p2c.category_id = '71' OR p2c.category_id = '72' OR p2c.category_id = '76' OR p2c.category_id = '75' OR p2c.category_id = '74' OR p2c.category_id = '73' OR p2c.category_id = '70')

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=70'

SELECT * FROM oc_DB_category c LEFT JOIN oc_DB_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_DB_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '77' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT category_id FROM oc_DB_category WHERE parent_id = '77'

SELECT COUNT(*) AS total FROM oc_DB_product p LEFT JOIN oc_DB_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_DB_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.product_id IN (SELECT p2c.product_id FROM oc_DB_product_to_category p2c WHERE p2c.category_id = '77')

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=77'

SELECT * FROM oc_DB_category c LEFT JOIN oc_DB_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_DB_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '78' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT category_id FROM oc_DB_category WHERE parent_id = '78'

SELECT COUNT(*) AS total FROM oc_DB_product p LEFT JOIN oc_DB_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_DB_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.product_id IN (SELECT p2c.product_id FROM oc_DB_product_to_category p2c WHERE p2c.category_id = '78')

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=78'

SELECT * FROM oc_DB_category c LEFT JOIN oc_DB_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_DB_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '79' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT category_id FROM oc_DB_category WHERE parent_id = '79'

SELECT COUNT(*) AS total FROM oc_DB_product p LEFT JOIN oc_DB_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_DB_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.product_id IN (SELECT p2c.product_id FROM oc_DB_product_to_category p2c WHERE p2c.category_id = '79')

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=79'

SELECT * FROM oc_DB_category c LEFT JOIN oc_DB_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_DB_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '80' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT category_id FROM oc_DB_category WHERE parent_id = '81'

SELECT COUNT(*) AS total FROM oc_DB_product p LEFT JOIN oc_DB_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_DB_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.product_id IN (SELECT p2c.product_id FROM oc_DB_product_to_category p2c WHERE p2c.category_id = '81')

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=80'

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=81'

SELECT category_id FROM oc_DB_category WHERE parent_id = '82'

SELECT COUNT(*) AS total FROM oc_DB_product p LEFT JOIN oc_DB_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_DB_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.product_id IN (SELECT p2c.product_id FROM oc_DB_product_to_category p2c WHERE p2c.category_id = '82')

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=80'

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=82'

SELECT category_id FROM oc_DB_category WHERE parent_id = '80'

SELECT category_id FROM oc_DB_category WHERE parent_id = '81'

SELECT category_id FROM oc_DB_category WHERE parent_id = '82'

SELECT COUNT(*) AS total FROM oc_DB_product p LEFT JOIN oc_DB_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_DB_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.product_id IN (SELECT p2c.product_id FROM oc_DB_product_to_category p2c WHERE p2c.category_id = '82' OR p2c.category_id = '81' OR p2c.category_id = '80')

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=80'

SELECT * FROM oc_DB_category c LEFT JOIN oc_DB_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_DB_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '83' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT category_id FROM oc_DB_category WHERE parent_id = '84'

SELECT COUNT(*) AS total FROM oc_DB_product p LEFT JOIN oc_DB_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_DB_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.product_id IN (SELECT p2c.product_id FROM oc_DB_product_to_category p2c WHERE p2c.category_id = '84')

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=83'

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=84'

SELECT category_id FROM oc_DB_category WHERE parent_id = '85'

SELECT COUNT(*) AS total FROM oc_DB_product p LEFT JOIN oc_DB_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_DB_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.product_id IN (SELECT p2c.product_id FROM oc_DB_product_to_category p2c WHERE p2c.category_id = '85')

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=83'

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=85'

SELECT category_id FROM oc_DB_category WHERE parent_id = '83'

SELECT category_id FROM oc_DB_category WHERE parent_id = '84'

SELECT category_id FROM oc_DB_category WHERE parent_id = '85'

SELECT COUNT(*) AS total FROM oc_DB_product p LEFT JOIN oc_DB_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_DB_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.product_id IN (SELECT p2c.product_id FROM oc_DB_product_to_category p2c WHERE p2c.category_id = '85' OR p2c.category_id = '84' OR p2c.category_id = '83')

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=83'

SELECT * FROM oc_DB_category c LEFT JOIN oc_DB_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_DB_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '86' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT category_id FROM oc_DB_category WHERE parent_id = '87'

SELECT COUNT(*) AS total FROM oc_DB_product p LEFT JOIN oc_DB_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_DB_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.product_id IN (SELECT p2c.product_id FROM oc_DB_product_to_category p2c WHERE p2c.category_id = '87')

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=86'

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=87'

SELECT category_id FROM oc_DB_category WHERE parent_id = '88'

SELECT COUNT(*) AS total FROM oc_DB_product p LEFT JOIN oc_DB_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_DB_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.product_id IN (SELECT p2c.product_id FROM oc_DB_product_to_category p2c WHERE p2c.category_id = '88')

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=86'

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=88'

SELECT category_id FROM oc_DB_category WHERE parent_id = '86'

SELECT category_id FROM oc_DB_category WHERE parent_id = '87'

SELECT category_id FROM oc_DB_category WHERE parent_id = '88'

SELECT COUNT(*) AS total FROM oc_DB_product p LEFT JOIN oc_DB_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_DB_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.product_id IN (SELECT p2c.product_id FROM oc_DB_product_to_category p2c WHERE p2c.category_id = '88' OR p2c.category_id = '87' OR p2c.category_id = '86')

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=86'

SELECT * FROM oc_DB_category c LEFT JOIN oc_DB_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_DB_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '89' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT category_id FROM oc_DB_category WHERE parent_id = '89'

SELECT COUNT(*) AS total FROM oc_DB_product p LEFT JOIN oc_DB_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_DB_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.product_id IN (SELECT p2c.product_id FROM oc_DB_product_to_category p2c WHERE p2c.category_id = '89')

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=89'

SELECT * FROM oc_DB_category c LEFT JOIN oc_DB_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_DB_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '90' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT category_id FROM oc_DB_category WHERE parent_id = '91'

SELECT COUNT(*) AS total FROM oc_DB_product p LEFT JOIN oc_DB_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_DB_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.product_id IN (SELECT p2c.product_id FROM oc_DB_product_to_category p2c WHERE p2c.category_id = '91')

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=90'

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=91'

SELECT category_id FROM oc_DB_category WHERE parent_id = '92'

SELECT COUNT(*) AS total FROM oc_DB_product p LEFT JOIN oc_DB_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_DB_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.product_id IN (SELECT p2c.product_id FROM oc_DB_product_to_category p2c WHERE p2c.category_id = '92')

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=90'

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=92'

SELECT category_id FROM oc_DB_category WHERE parent_id = '93'

SELECT COUNT(*) AS total FROM oc_DB_product p LEFT JOIN oc_DB_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_DB_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.product_id IN (SELECT p2c.product_id FROM oc_DB_product_to_category p2c WHERE p2c.category_id = '93')

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=90'

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=93'

SELECT category_id FROM oc_DB_category WHERE parent_id = '94'

SELECT COUNT(*) AS total FROM oc_DB_product p LEFT JOIN oc_DB_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_DB_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.product_id IN (SELECT p2c.product_id FROM oc_DB_product_to_category p2c WHERE p2c.category_id = '94')

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=90'

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=94'

SELECT category_id FROM oc_DB_category WHERE parent_id = '95'

SELECT COUNT(*) AS total FROM oc_DB_product p LEFT JOIN oc_DB_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_DB_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.product_id IN (SELECT p2c.product_id FROM oc_DB_product_to_category p2c WHERE p2c.category_id = '95')

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=90'

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=95'

SELECT category_id FROM oc_DB_category WHERE parent_id = '96'

SELECT COUNT(*) AS total FROM oc_DB_product p LEFT JOIN oc_DB_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_DB_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.product_id IN (SELECT p2c.product_id FROM oc_DB_product_to_category p2c WHERE p2c.category_id = '96')

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=90'

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=96'

SELECT category_id FROM oc_DB_category WHERE parent_id = '97'

SELECT COUNT(*) AS total FROM oc_DB_product p LEFT JOIN oc_DB_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_DB_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.product_id IN (SELECT p2c.product_id FROM oc_DB_product_to_category p2c WHERE p2c.category_id = '97')

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=90'

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=97'

SELECT category_id FROM oc_DB_category WHERE parent_id = '90'

SELECT category_id FROM oc_DB_category WHERE parent_id = '91'

SELECT category_id FROM oc_DB_category WHERE parent_id = '92'

SELECT category_id FROM oc_DB_category WHERE parent_id = '93'

SELECT category_id FROM oc_DB_category WHERE parent_id = '94'

SELECT category_id FROM oc_DB_category WHERE parent_id = '95'

SELECT category_id FROM oc_DB_category WHERE parent_id = '96'

SELECT category_id FROM oc_DB_category WHERE parent_id = '97'

SELECT COUNT(*) AS total FROM oc_DB_product p LEFT JOIN oc_DB_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_DB_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.product_id IN (SELECT p2c.product_id FROM oc_DB_product_to_category p2c WHERE p2c.category_id = '97' OR p2c.category_id = '96' OR p2c.category_id = '95' OR p2c.category_id = '94' OR p2c.category_id = '93' OR p2c.category_id = '92' OR p2c.category_id = '91' OR p2c.category_id = '90')

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=90'

SELECT * FROM oc_DB_category c LEFT JOIN oc_DB_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_DB_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '98' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT category_id FROM oc_DB_category WHERE parent_id = '99'

SELECT COUNT(*) AS total FROM oc_DB_product p LEFT JOIN oc_DB_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_DB_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.product_id IN (SELECT p2c.product_id FROM oc_DB_product_to_category p2c WHERE p2c.category_id = '99')

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=98'

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=99'

SELECT category_id FROM oc_DB_category WHERE parent_id = '100'

SELECT COUNT(*) AS total FROM oc_DB_product p LEFT JOIN oc_DB_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_DB_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.product_id IN (SELECT p2c.product_id FROM oc_DB_product_to_category p2c WHERE p2c.category_id = '100')

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=98'

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=100'

SELECT category_id FROM oc_DB_category WHERE parent_id = '101'

SELECT COUNT(*) AS total FROM oc_DB_product p LEFT JOIN oc_DB_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_DB_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.product_id IN (SELECT p2c.product_id FROM oc_DB_product_to_category p2c WHERE p2c.category_id = '101')

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=98'

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=101'

SELECT category_id FROM oc_DB_category WHERE parent_id = '102'

SELECT COUNT(*) AS total FROM oc_DB_product p LEFT JOIN oc_DB_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_DB_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.product_id IN (SELECT p2c.product_id FROM oc_DB_product_to_category p2c WHERE p2c.category_id = '102')

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=98'

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=102'

SELECT category_id FROM oc_DB_category WHERE parent_id = '103'

SELECT COUNT(*) AS total FROM oc_DB_product p LEFT JOIN oc_DB_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_DB_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.product_id IN (SELECT p2c.product_id FROM oc_DB_product_to_category p2c WHERE p2c.category_id = '103')

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=98'

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=103'

SELECT category_id FROM oc_DB_category WHERE parent_id = '104'

SELECT COUNT(*) AS total FROM oc_DB_product p LEFT JOIN oc_DB_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_DB_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.product_id IN (SELECT p2c.product_id FROM oc_DB_product_to_category p2c WHERE p2c.category_id = '104')

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=98'

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=104'

SELECT category_id FROM oc_DB_category WHERE parent_id = '105'

SELECT COUNT(*) AS total FROM oc_DB_product p LEFT JOIN oc_DB_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_DB_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.product_id IN (SELECT p2c.product_id FROM oc_DB_product_to_category p2c WHERE p2c.category_id = '105')

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=98'

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=105'

SELECT category_id FROM oc_DB_category WHERE parent_id = '98'

SELECT category_id FROM oc_DB_category WHERE parent_id = '99'

SELECT category_id FROM oc_DB_category WHERE parent_id = '100'

SELECT category_id FROM oc_DB_category WHERE parent_id = '101'

SELECT category_id FROM oc_DB_category WHERE parent_id = '102'

SELECT category_id FROM oc_DB_category WHERE parent_id = '103'

SELECT category_id FROM oc_DB_category WHERE parent_id = '104'

SELECT category_id FROM oc_DB_category WHERE parent_id = '105'

SELECT COUNT(*) AS total FROM oc_DB_product p LEFT JOIN oc_DB_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_DB_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.product_id IN (SELECT p2c.product_id FROM oc_DB_product_to_category p2c WHERE p2c.category_id = '105' OR p2c.category_id = '104' OR p2c.category_id = '103' OR p2c.category_id = '102' OR p2c.category_id = '101' OR p2c.category_id = '100' OR p2c.category_id = '99' OR p2c.category_id = '98')

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=98'

SELECT * FROM oc_DB_category c LEFT JOIN oc_DB_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_DB_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 = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT category_id FROM oc_DB_category WHERE parent_id = '106'

SELECT COUNT(*) AS total FROM oc_DB_product p LEFT JOIN oc_DB_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_DB_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.product_id IN (SELECT p2c.product_id FROM oc_DB_product_to_category p2c WHERE p2c.category_id = '106')

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=106'

SELECT * FROM oc_DB_category c LEFT JOIN oc_DB_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_DB_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 = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT category_id FROM oc_DB_category WHERE parent_id = '108'

SELECT COUNT(*) AS total FROM oc_DB_product p LEFT JOIN oc_DB_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_DB_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.product_id IN (SELECT p2c.product_id FROM oc_DB_product_to_category p2c WHERE p2c.category_id = '108')

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=107'

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=108'

SELECT category_id FROM oc_DB_category WHERE parent_id = '109'

SELECT COUNT(*) AS total FROM oc_DB_product p LEFT JOIN oc_DB_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_DB_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.product_id IN (SELECT p2c.product_id FROM oc_DB_product_to_category p2c WHERE p2c.category_id = '109')

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=107'

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=109'

SELECT category_id FROM oc_DB_category WHERE parent_id = '110'

SELECT COUNT(*) AS total FROM oc_DB_product p LEFT JOIN oc_DB_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_DB_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.product_id IN (SELECT p2c.product_id FROM oc_DB_product_to_category p2c WHERE p2c.category_id = '110')

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=107'

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=110'

SELECT category_id FROM oc_DB_category WHERE parent_id = '111'

SELECT COUNT(*) AS total FROM oc_DB_product p LEFT JOIN oc_DB_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_DB_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.product_id IN (SELECT p2c.product_id FROM oc_DB_product_to_category p2c WHERE p2c.category_id = '111')

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=107'

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=111'

SELECT category_id FROM oc_DB_category WHERE parent_id = '112'

SELECT COUNT(*) AS total FROM oc_DB_product p LEFT JOIN oc_DB_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_DB_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.product_id IN (SELECT p2c.product_id FROM oc_DB_product_to_category p2c WHERE p2c.category_id = '112')

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=107'

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=112'

SELECT category_id FROM oc_DB_category WHERE parent_id = '113'

SELECT COUNT(*) AS total FROM oc_DB_product p LEFT JOIN oc_DB_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_DB_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.product_id IN (SELECT p2c.product_id FROM oc_DB_product_to_category p2c WHERE p2c.category_id = '113')

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=107'

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=113'

SELECT category_id FROM oc_DB_category WHERE parent_id = '114'

SELECT COUNT(*) AS total FROM oc_DB_product p LEFT JOIN oc_DB_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_DB_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.product_id IN (SELECT p2c.product_id FROM oc_DB_product_to_category p2c WHERE p2c.category_id = '114')

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=107'

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=114'

SELECT category_id FROM oc_DB_category WHERE parent_id = '107'

SELECT category_id FROM oc_DB_category WHERE parent_id = '108'

SELECT category_id FROM oc_DB_category WHERE parent_id = '109'

SELECT category_id FROM oc_DB_category WHERE parent_id = '110'

SELECT category_id FROM oc_DB_category WHERE parent_id = '111'

SELECT category_id FROM oc_DB_category WHERE parent_id = '112'

SELECT category_id FROM oc_DB_category WHERE parent_id = '113'

SELECT category_id FROM oc_DB_category WHERE parent_id = '114'

SELECT COUNT(*) AS total FROM oc_DB_product p LEFT JOIN oc_DB_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_DB_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.product_id IN (SELECT p2c.product_id FROM oc_DB_product_to_category p2c WHERE p2c.category_id = '114' OR p2c.category_id = '113' OR p2c.category_id = '112' OR p2c.category_id = '111' OR p2c.category_id = '110' OR p2c.category_id = '109' OR p2c.category_id = '108' OR p2c.category_id = '107')

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=107'

SELECT * FROM oc_DB_category c LEFT JOIN oc_DB_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_DB_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '115' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT category_id FROM oc_DB_category WHERE parent_id = '116'

SELECT COUNT(*) AS total FROM oc_DB_product p LEFT JOIN oc_DB_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_DB_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.product_id IN (SELECT p2c.product_id FROM oc_DB_product_to_category p2c WHERE p2c.category_id = '116')

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=115'

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=116'

SELECT category_id FROM oc_DB_category WHERE parent_id = '117'

SELECT COUNT(*) AS total FROM oc_DB_product p LEFT JOIN oc_DB_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_DB_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.product_id IN (SELECT p2c.product_id FROM oc_DB_product_to_category p2c WHERE p2c.category_id = '117')

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=115'

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=117'

SELECT category_id FROM oc_DB_category WHERE parent_id = '118'

SELECT COUNT(*) AS total FROM oc_DB_product p LEFT JOIN oc_DB_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_DB_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.product_id IN (SELECT p2c.product_id FROM oc_DB_product_to_category p2c WHERE p2c.category_id = '118')

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=115'

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=118'

SELECT category_id FROM oc_DB_category WHERE parent_id = '115'

SELECT category_id FROM oc_DB_category WHERE parent_id = '116'

SELECT category_id FROM oc_DB_category WHERE parent_id = '117'

SELECT category_id FROM oc_DB_category WHERE parent_id = '118'

SELECT COUNT(*) AS total FROM oc_DB_product p LEFT JOIN oc_DB_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_DB_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.product_id IN (SELECT p2c.product_id FROM oc_DB_product_to_category p2c WHERE p2c.category_id = '118' OR p2c.category_id = '117' OR p2c.category_id = '116' OR p2c.category_id = '115')

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=115'

SELECT * FROM oc_DB_category c LEFT JOIN oc_DB_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_DB_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '119' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT category_id FROM oc_DB_category WHERE parent_id = '120'

SELECT COUNT(*) AS total FROM oc_DB_product p LEFT JOIN oc_DB_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_DB_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.product_id IN (SELECT p2c.product_id FROM oc_DB_product_to_category p2c WHERE p2c.category_id = '120')

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=119'

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=120'

SELECT category_id FROM oc_DB_category WHERE parent_id = '121'

SELECT COUNT(*) AS total FROM oc_DB_product p LEFT JOIN oc_DB_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_DB_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.product_id IN (SELECT p2c.product_id FROM oc_DB_product_to_category p2c WHERE p2c.category_id = '121')

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=119'

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=121'

SELECT category_id FROM oc_DB_category WHERE parent_id = '119'

SELECT category_id FROM oc_DB_category WHERE parent_id = '120'

SELECT category_id FROM oc_DB_category WHERE parent_id = '121'

SELECT COUNT(*) AS total FROM oc_DB_product p LEFT JOIN oc_DB_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_DB_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.product_id IN (SELECT p2c.product_id FROM oc_DB_product_to_category p2c WHERE p2c.category_id = '121' OR p2c.category_id = '120' OR p2c.category_id = '119')

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=119'

SELECT * FROM oc_DB_banner_image bi LEFT JOIN oc_DB_banner_image_description bid ON (bi.banner_image_id = bid.banner_image_id) WHERE bi.banner_id = '13' AND bid.language_id = '1'

SELECT * FROM oc_DB_banner_image bi LEFT JOIN oc_DB_banner_image_description bid ON (bi.banner_image_id = bid.banner_image_id) WHERE bi.banner_id = '9' AND bid.language_id = '1'

SELECT * FROM oc_DB_new i LEFT JOIN oc_DB_new_description id ON (i.new_id = id.new_id) LEFT JOIN oc_DB_new_to_store i2s ON (i.new_id = i2s.new_id) WHERE id.language_id = '1' AND i2s.store_id = '0' AND i.status = '1' AND i.sort_order <> '-1' ORDER BY i.sort_order, LCASE(id.title) ASC

SELECT * FROM oc_DB_banner_image bi LEFT JOIN oc_DB_banner_image_description bid ON (bi.banner_image_id = bid.banner_image_id) WHERE bi.banner_id = '8' AND bid.language_id = '1'

SELECT * FROM oc_DB_layout_route WHERE 'common/home' LIKE CONCAT(route, '%') AND store_id = '0' ORDER BY route ASC LIMIT 1

SELECT * FROM oc_DB_extension WHERE `type` = 'module'

SELECT * FROM oc_DB_layout_route WHERE 'common/home' LIKE CONCAT(route, '%') AND store_id = '0' ORDER BY route ASC LIMIT 1

SELECT * FROM oc_DB_extension WHERE `type` = 'module'

SELECT * FROM oc_DB_banner_image bi LEFT JOIN oc_DB_banner_image_description bid ON (bi.banner_image_id = bid.banner_image_id) WHERE bi.banner_id = '7' AND bid.language_id = '1'

SELECT * FROM oc_DB_layout_route WHERE 'common/home' LIKE CONCAT(route, '%') AND store_id = '0' ORDER BY route ASC LIMIT 1

SELECT * FROM oc_DB_extension WHERE `type` = 'module'

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_DB_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '8' 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_DB_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '8' 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_DB_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '8') AS reward, (SELECT ss.name FROM oc_DB_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_DB_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_DB_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_DB_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_DB_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews FROM oc_DB_product p LEFT JOIN oc_DB_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_DB_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_DB_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '332' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

SELECT * FROM oc_DB_url_alias WHERE `query` = 'product_id=332'

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_DB_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '8' 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_DB_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '8' 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_DB_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '8') AS reward, (SELECT ss.name FROM oc_DB_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_DB_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_DB_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_DB_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_DB_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews FROM oc_DB_product p LEFT JOIN oc_DB_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_DB_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_DB_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '334' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

SELECT * FROM oc_DB_url_alias WHERE `query` = 'product_id=334'

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_DB_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '8' 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_DB_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '8' 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_DB_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '8') AS reward, (SELECT ss.name FROM oc_DB_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_DB_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_DB_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_DB_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_DB_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews FROM oc_DB_product p LEFT JOIN oc_DB_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_DB_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_DB_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '297' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

SELECT * FROM oc_DB_url_alias WHERE `query` = 'product_id=297'

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_DB_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '8' 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_DB_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '8' 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_DB_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '8') AS reward, (SELECT ss.name FROM oc_DB_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_DB_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_DB_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_DB_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_DB_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews FROM oc_DB_product p LEFT JOIN oc_DB_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_DB_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_DB_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '300' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

SELECT * FROM oc_DB_url_alias WHERE `query` = 'product_id=300'

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_DB_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '8' 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_DB_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '8' 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_DB_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '8') AS reward, (SELECT ss.name FROM oc_DB_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_DB_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_DB_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_DB_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_DB_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews FROM oc_DB_product p LEFT JOIN oc_DB_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_DB_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_DB_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '183' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

SELECT * FROM oc_DB_url_alias WHERE `query` = 'product_id=183'

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_DB_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '8' 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_DB_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '8' 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_DB_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '8') AS reward, (SELECT ss.name FROM oc_DB_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_DB_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_DB_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_DB_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_DB_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews FROM oc_DB_product p LEFT JOIN oc_DB_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_DB_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_DB_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '318' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

SELECT * FROM oc_DB_url_alias WHERE `query` = 'product_id=318'

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_DB_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '8' 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_DB_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '8' 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_DB_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '8') AS reward, (SELECT ss.name FROM oc_DB_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_DB_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_DB_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_DB_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_DB_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews FROM oc_DB_product p LEFT JOIN oc_DB_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_DB_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_DB_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '337' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

SELECT * FROM oc_DB_url_alias WHERE `query` = 'product_id=337'

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_DB_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '8' 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_DB_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '8' 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_DB_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '8') AS reward, (SELECT ss.name FROM oc_DB_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_DB_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_DB_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_DB_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_DB_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews FROM oc_DB_product p LEFT JOIN oc_DB_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_DB_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_DB_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '331' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

SELECT * FROM oc_DB_url_alias WHERE `query` = 'product_id=331'

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_DB_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '8' 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_DB_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '8' 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_DB_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '8') AS reward, (SELECT ss.name FROM oc_DB_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_DB_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_DB_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_DB_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_DB_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews FROM oc_DB_product p LEFT JOIN oc_DB_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_DB_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_DB_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '318' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

SELECT * FROM oc_DB_url_alias WHERE `query` = 'product_id=318'

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_DB_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '8' 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_DB_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '8' 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_DB_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '8') AS reward, (SELECT ss.name FROM oc_DB_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_DB_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_DB_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_DB_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_DB_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews FROM oc_DB_product p LEFT JOIN oc_DB_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_DB_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_DB_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '99' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

SELECT * FROM oc_DB_url_alias WHERE `query` = 'product_id=99'

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_DB_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '8' 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_DB_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '8' 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_DB_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '8') AS reward, (SELECT ss.name FROM oc_DB_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_DB_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_DB_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_DB_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_DB_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews FROM oc_DB_product p LEFT JOIN oc_DB_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_DB_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_DB_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '311' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

SELECT * FROM oc_DB_url_alias WHERE `query` = 'product_id=311'

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_DB_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '8' 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_DB_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '8' 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_DB_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '8') AS reward, (SELECT ss.name FROM oc_DB_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_DB_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_DB_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_DB_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_DB_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews FROM oc_DB_product p LEFT JOIN oc_DB_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_DB_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_DB_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '298' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_DB_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '8' 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_DB_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '8' 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_DB_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '8') AS reward, (SELECT ss.name FROM oc_DB_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_DB_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_DB_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_DB_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_DB_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews FROM oc_DB_product p LEFT JOIN oc_DB_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_DB_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_DB_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '312' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_DB_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '8' 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_DB_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '8' 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_DB_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '8') AS reward, (SELECT ss.name FROM oc_DB_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_DB_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_DB_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_DB_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_DB_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews FROM oc_DB_product p LEFT JOIN oc_DB_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_DB_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_DB_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '183' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

SELECT * FROM oc_DB_url_alias WHERE `query` = 'product_id=183'

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_DB_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '8' 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_DB_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '8' 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_DB_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '8') AS reward, (SELECT ss.name FROM oc_DB_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_DB_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_DB_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_DB_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_DB_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews FROM oc_DB_product p LEFT JOIN oc_DB_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_DB_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_DB_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '335' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

SELECT * FROM oc_DB_url_alias WHERE `query` = 'product_id=335'

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_DB_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '8' 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_DB_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '8' 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_DB_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '8') AS reward, (SELECT ss.name FROM oc_DB_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_DB_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_DB_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_DB_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_DB_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews FROM oc_DB_product p LEFT JOIN oc_DB_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_DB_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_DB_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '316' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

SELECT * FROM oc_DB_url_alias WHERE `query` = 'product_id=316'

SELECT * FROM oc_DB_information i LEFT JOIN oc_DB_information_description id ON (i.information_id = id.information_id) LEFT JOIN oc_DB_information_to_store i2s ON (i.information_id = i2s.information_id) WHERE id.language_id = '1' AND i2s.store_id = '0' AND i.status = '1' AND i.sort_order <> '-1' ORDER BY i.sort_order, LCASE(id.title) ASC

SELECT * FROM oc_DB_url_alias WHERE `query` = 'information_id=4'

SELECT * FROM oc_DB_url_alias WHERE `query` = 'information_id=6'

SELECT * FROM oc_DB_url_alias WHERE `query` = 'information_id=5'

SELECT * FROM oc_DB_url_alias WHERE `query` = 'information_id=3'

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

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

SELECT * FROM oc_DB_category c LEFT JOIN oc_DB_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_DB_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '59' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=59'

SELECT * FROM oc_DB_category c LEFT JOIN oc_DB_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_DB_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '60' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT category_id FROM oc_DB_category WHERE parent_id = '122'

SELECT COUNT(*) AS total FROM oc_DB_product p LEFT JOIN oc_DB_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_DB_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.product_id IN (SELECT p2c.product_id FROM oc_DB_product_to_category p2c WHERE p2c.category_id = '122')

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=60'

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=122'

SELECT category_id FROM oc_DB_category WHERE parent_id = '124'

SELECT COUNT(*) AS total FROM oc_DB_product p LEFT JOIN oc_DB_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_DB_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.product_id IN (SELECT p2c.product_id FROM oc_DB_product_to_category p2c WHERE p2c.category_id = '124')

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=60'

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=124'

SELECT category_id FROM oc_DB_category WHERE parent_id = '127'

SELECT COUNT(*) AS total FROM oc_DB_product p LEFT JOIN oc_DB_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_DB_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.product_id IN (SELECT p2c.product_id FROM oc_DB_product_to_category p2c WHERE p2c.category_id = '127')

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=60'

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=127'

SELECT category_id FROM oc_DB_category WHERE parent_id = '126'

SELECT COUNT(*) AS total FROM oc_DB_product p LEFT JOIN oc_DB_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_DB_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.product_id IN (SELECT p2c.product_id FROM oc_DB_product_to_category p2c WHERE p2c.category_id = '126')

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=60'

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=126'

SELECT category_id FROM oc_DB_category WHERE parent_id = '125'

SELECT COUNT(*) AS total FROM oc_DB_product p LEFT JOIN oc_DB_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_DB_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.product_id IN (SELECT p2c.product_id FROM oc_DB_product_to_category p2c WHERE p2c.category_id = '125')

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=60'

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=125'

SELECT category_id FROM oc_DB_category WHERE parent_id = '129'

SELECT COUNT(*) AS total FROM oc_DB_product p LEFT JOIN oc_DB_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_DB_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.product_id IN (SELECT p2c.product_id FROM oc_DB_product_to_category p2c WHERE p2c.category_id = '129')

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=60'

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=129'

SELECT category_id FROM oc_DB_category WHERE parent_id = '128'

SELECT COUNT(*) AS total FROM oc_DB_product p LEFT JOIN oc_DB_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_DB_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.product_id IN (SELECT p2c.product_id FROM oc_DB_product_to_category p2c WHERE p2c.category_id = '128')

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=60'

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=128'

SELECT category_id FROM oc_DB_category WHERE parent_id = '123'

SELECT COUNT(*) AS total FROM oc_DB_product p LEFT JOIN oc_DB_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_DB_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.product_id IN (SELECT p2c.product_id FROM oc_DB_product_to_category p2c WHERE p2c.category_id = '123')

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=60'

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=123'

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=60'

SELECT * FROM oc_DB_category c LEFT JOIN oc_DB_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_DB_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '61' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT category_id FROM oc_DB_category WHERE parent_id = '62'

SELECT COUNT(*) AS total FROM oc_DB_product p LEFT JOIN oc_DB_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_DB_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.product_id IN (SELECT p2c.product_id FROM oc_DB_product_to_category p2c WHERE p2c.category_id = '62')

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=61'

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=62'

SELECT category_id FROM oc_DB_category WHERE parent_id = '64'

SELECT COUNT(*) AS total FROM oc_DB_product p LEFT JOIN oc_DB_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_DB_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.product_id IN (SELECT p2c.product_id FROM oc_DB_product_to_category p2c WHERE p2c.category_id = '64')

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=61'

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=64'

SELECT category_id FROM oc_DB_category WHERE parent_id = '67'

SELECT COUNT(*) AS total FROM oc_DB_product p LEFT JOIN oc_DB_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_DB_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.product_id IN (SELECT p2c.product_id FROM oc_DB_product_to_category p2c WHERE p2c.category_id = '67')

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=61'

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=67'

SELECT category_id FROM oc_DB_category WHERE parent_id = '66'

SELECT COUNT(*) AS total FROM oc_DB_product p LEFT JOIN oc_DB_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_DB_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.product_id IN (SELECT p2c.product_id FROM oc_DB_product_to_category p2c WHERE p2c.category_id = '66')

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=61'

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=66'

SELECT category_id FROM oc_DB_category WHERE parent_id = '65'

SELECT COUNT(*) AS total FROM oc_DB_product p LEFT JOIN oc_DB_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_DB_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.product_id IN (SELECT p2c.product_id FROM oc_DB_product_to_category p2c WHERE p2c.category_id = '65')

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=61'

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=65'

SELECT category_id FROM oc_DB_category WHERE parent_id = '69'

SELECT COUNT(*) AS total FROM oc_DB_product p LEFT JOIN oc_DB_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_DB_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.product_id IN (SELECT p2c.product_id FROM oc_DB_product_to_category p2c WHERE p2c.category_id = '69')

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=61'

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=69'

SELECT category_id FROM oc_DB_category WHERE parent_id = '68'

SELECT COUNT(*) AS total FROM oc_DB_product p LEFT JOIN oc_DB_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_DB_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.product_id IN (SELECT p2c.product_id FROM oc_DB_product_to_category p2c WHERE p2c.category_id = '68')

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=61'

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=68'

SELECT category_id FROM oc_DB_category WHERE parent_id = '63'

SELECT COUNT(*) AS total FROM oc_DB_product p LEFT JOIN oc_DB_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_DB_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.product_id IN (SELECT p2c.product_id FROM oc_DB_product_to_category p2c WHERE p2c.category_id = '63')

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=61'

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=63'

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=61'

SELECT * FROM oc_DB_category c LEFT JOIN oc_DB_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_DB_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '86' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)

SELECT category_id FROM oc_DB_category WHERE parent_id = '87'

SELECT COUNT(*) AS total FROM oc_DB_product p LEFT JOIN oc_DB_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_DB_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.product_id IN (SELECT p2c.product_id FROM oc_DB_product_to_category p2c WHERE p2c.category_id = '87')

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=86'

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=87'

SELECT category_id FROM oc_DB_category WHERE parent_id = '88'

SELECT COUNT(*) AS total FROM oc_DB_product p LEFT JOIN oc_DB_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_DB_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.product_id IN (SELECT p2c.product_id FROM oc_DB_product_to_category p2c WHERE p2c.category_id = '88')

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=86'

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=88'

SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=86'