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 = '3' 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')