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 DISTINCT * 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 i.information_id = '5' AND id.language_id = '1' AND i2s.store_id = '0' AND i.status = '1'
SELECT * FROM oc_DB_url_alias WHERE `query` = 'information_id=5'
SELECT * FROM oc_DB_layout_route WHERE 'information/information' 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_layout_route WHERE 'information/information' 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 'information/information' 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 'information/information' 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_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_url_alias WHERE `query` = 'information_id=5'
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'
政策及条款
商品目录
首页 > 政策及条款

政策及条款

政策及条款

在本政策及条款中, “我们”指全达玩具商行, “您”指客户。

当客户在全达玩具商行下订单之前, 请仔细阅读本政策, 它明确了您及与您购买行为有关的权利和义务。

客户向我们确认送出订单即视为同意本政策及条款, 因此请在点击确认送出订单前确定您完全理解及同意本政策的全部内容。订单确认送出后, 客户不能把其订单取消。

销售政策
1. 目前我们只接受支付宝实时到帐方式支付货款, 运费则采用货到付款方式。
2. 客户必须以人民币支付货款或其它应付款项。
3. 为保障交易安全, 我们或第三方快递人员可能需要客户或收货人提供身份证明。
4. 货品配送范围只限中华人民共和国(“中国”)大陆境内绝大部分大中城市。
5. 当客户在支付宝完成付款后, 我们会把订单资料寄送到客户的电子邮箱, 订单资料以我们系统自动纪录的电子交易资料为准, 如客户发现订单资料有误, 请立即通知我们, 以便尽可能于货物寄出前作出修正。
6. 我们收到客户的订单后, 会进行款项核证, 如确认交易条件无误、付款完成且有存货, 我们则进行配送安排。若不能核证款项、交易条件有误、商品没有存货或有其它我们无法接受订单的情况, 该订单会被取消, 客户不得拒绝。
7. 无论订单是否已经接受, 我们保留随时取消订单之权利。若订单取消, 我们将退还已支付的款项到客户支付时的支付宝账户。
8. 在周末或公休假日提交的订单将会在下一个工作日进行订单处理。
9. 在18周岁以下的客户, 只能在父母或监护人的监护参与下才能提交订单。
10. 我们保留随时修改货品信息、价格及一切折扣的权利, 并不作特别通知。
11. 我们保留随时暂停供应任何货品或赠品的权利, 并不作特别通知。

配送细则
1. 本店默许快递为顺丰速运。
2. 配送地址不能为邮政信箱, 客户必须填写详细地址、收货人姓名和联系电话。
3. 我们保证出货时货品外包装完好无缺, 货品在配送时的风险及损失责任将由客户承担。我们建议选用顺丰速运的保险服务, 万一货品在配送过程中遗失或破损等情况, 将由顺丰速运按照货品价值及其赔偿条例处理赔偿事宜, 详情请参阅顺丰速运之相关附例。
4. 预计的配送时间不包括周末及公休假日, 我们会尽可能在最短时间内安排货品配送, 但实际配送时间可能因货品供应情况、快递情况、天气因素、交通戒严等变化而有所变化。如果配送时间有变化我们会通过电子邮件通知客户。客户亦可进入"订购记录"检视所订购货品的最新配送情况。
5. 在货品安排配送后, 我们会通过电子邮件通知客户。
6. 客户务必在签收货品前即配送人员还在现场时, 检查货品外包装的完好无缺、货品没有任何因配送过程中遗失或破损等情况。如客户已签收或由他人代为签收, 则视为货品没有任何因配送过程中遗失或破损等情况。
7. 如货品在配送过程中遗失或破损等情况, 我们无须承担任何直接或间接的赔偿责任。
8. 如最后货品因送达后无人签收或客户提供的资料不正确未能完成配送而遭退回, 我们会通过电子邮件通知客户, 并在已支付的款项中扣除由此造成的相关运送费用及其它损失后退款到客户支付时的支付宝账户。

换货、退货及退款政策
1. 客户须于收到货品后立即检查货品有否任何错漏或本身质量问题, 并于七日内（以客户收货签收日期为准）向我们提出换货或退货要求。
2.我们并不接受下列情况的换货或退货要求：
- 客户于收到货品七日后向我们提出;
- 货品曾经使用;
- 因疏忽、误用、拆装、碰撞、进液、事故、改动、不正确的安装或保管而导致的货品质量问题;
- 货品非由我们出售;
- 客户因个人喜好等因素。
3. 我们有权拒绝接受折扣货品、推广货品或赠品换货或退货要求。
4. 退回货品必须为全新状态且货品包装完整无污损及相关附属配件齐全(包含商品、配件、包装、说明书、赠品等), 否则, 我们有权拒绝接受换货或退货要求。
5. 客户退回货品前请务必先与我们联系确认, 未通过确认而将货品寄回, 我们有权拒绝相关的换货或退货要求。
6. 客户在寄回货品时务必使用收货时的包装并确保包装牢固, 并于货品内附上客户姓名、订单号、联系方式和货品问题详细说明。
7. 在更换货品之时, 视乎货品的存货量, 我们有可能以其它同等价值的货品代替。
8. 货品在换货或退货时所产生的运送费用, 将视情况而定, 由我们或客户承担。
9. 我们有权拒绝任何换货或退货要求, 或因应情况提出以换货取代退货。
10. 在退货时, 我们将在已支付的货款中扣除由此造成的运送费用及其它相关费用后, 把款项退还到客户支付时的支付宝账户, 运送费用不能退款。

其它条款
1. 任何单位或个人未经我们许可下不得以任何方式非法地全部或部分复制、引用、转载、链接或以其它方式使用本站的信息及内容, 否则我们有权追究责任。
2. 我们随时可酌情决定终止客户的会员资格及登入网站的权利而毋须给予理由。假若客户因此而遭受任何类型的任何损失, 我们不承担任何责任。
3. 如因不可抗力或其它我们无法控制的原因使我们的销售系统无法正常使用导致订单无法完成或丢失有关的信息、记录等, 我们会尽可能合理地协助处理善后事宜, 并尽力使客户免受损失。
4. 在本政策任何条款无效或不可执行时, 不应对剩余条款的有效性和可执行性产生不利影响。我们或客户未执行本政策的任何条款, 不构成对该条款的放弃。
5. 如发生本政策与适用之国家法规相抵触时, 则这些条款将完全按法规重新解释, 而其它有效条款继续有效。
6. 我们对任何排字或印刷上的错误不会负任何责任。
7. 我们保留此政策及条款的最终解释权及决定权。
8. 我们保留随时修改此政策的权利。

继续
© 全达玩具商行　版权所有，并保留所有权利。
(苏ICP备15005609号)