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_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 i.new_id = '2' AND id.language_id = '1' AND i2s.store_id = '0' AND i.status = '1'
SELECT * FROM oc_DB_layout_route WHERE 'new/new' 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_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_layout_route WHERE 'new/new' 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 'new/new' 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 'new/new' 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'
