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 COUNT(DISTINCT ps.product_id) AS total FROM oc_DB_product_special ps LEFT JOIN oc_DB_product p ON (ps.product_id = p.product_id) LEFT JOIN oc_DB_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' 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()))
SELECT DISTINCT ps.product_id, (SELECT AVG(rating) FROM oc_DB_review r1 WHERE r1.product_id = ps.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating FROM oc_DB_product_special ps LEFT JOIN oc_DB_product p ON (ps.product_id = p.product_id) LEFT JOIN oc_DB_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_DB_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' 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())) GROUP BY ps.product_id ORDER BY p.sort_order ASC LIMIT 0,15
SELECT * FROM oc_DB_layout_route WHERE 'product/special' 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 'product/special' 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 'product/special' 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 'product/special' 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_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'
