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 = '290' 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=290'
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 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 = '327' 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=327'
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 = '321' 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=321'
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 = '309' 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=309'
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 = '330' 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=330'
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 = '120' 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=120'
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 = '315' 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=315'
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 = '76' 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=76'
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 = '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 = '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 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 = '327' 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=327'
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 = '309' 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=309'
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 = '97' 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=97'
SELECT * FROM oc_DB_manufacturer m LEFT JOIN oc_DB_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id) WHERE m2s.store_id = '0' ORDER BY sort_order
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'
欢迎来临全达玩具商行网上商店!!
商品目录
A335 SkyNova GM070 A300 A340KIT A340 LIPO-SAFE

 本店采用顺丰速运,运费采用货到付款,配送范围只限中國境內, 敬请注意!! 

欢迎来临全达玩具商行网上商店!!

品牌
  • The World Models
  • The Wings Maker
  • RoboPhilo
© 全达玩具商行 版权所有,并保留所有权利。
(苏ICP备15005609号)