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_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.category_id = '77' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=77'
SELECT DISTINCT * 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.category_id = '77' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
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 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 p.product_id, (SELECT AVG(rating) AS total FROM oc_DB_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating 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') ORDER BY p.sort_order ASC LIMIT 0,15
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_DB_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '8' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_DB_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '8' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_DB_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '8') AS reward, (SELECT ss.name FROM oc_DB_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_DB_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_DB_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_DB_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_DB_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews FROM oc_DB_product p LEFT JOIN oc_DB_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_DB_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_DB_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '335' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_DB_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '8' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_DB_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '8' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_DB_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '8') AS reward, (SELECT ss.name FROM oc_DB_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_DB_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_DB_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_DB_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_DB_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews FROM oc_DB_product p LEFT JOIN oc_DB_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_DB_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_DB_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '296' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_DB_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '8' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_DB_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '8' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_DB_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '8') AS reward, (SELECT ss.name FROM oc_DB_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_DB_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_DB_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_DB_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_DB_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews FROM oc_DB_product p LEFT JOIN oc_DB_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_DB_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_DB_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '119' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_DB_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '8' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_DB_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '8' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_DB_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '8') AS reward, (SELECT ss.name FROM oc_DB_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_DB_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_DB_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_DB_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_DB_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews FROM oc_DB_product p LEFT JOIN oc_DB_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_DB_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_DB_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '297' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_DB_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '8' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_DB_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '8' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_DB_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '8') AS reward, (SELECT ss.name FROM oc_DB_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_DB_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_DB_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_DB_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_DB_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews FROM oc_DB_product p LEFT JOIN oc_DB_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_DB_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_DB_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '322' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_DB_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '8' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_DB_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '8' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_DB_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '8') AS reward, (SELECT ss.name FROM oc_DB_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_DB_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_DB_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_DB_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_DB_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews FROM oc_DB_product p LEFT JOIN oc_DB_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_DB_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_DB_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '346' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_DB_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '8' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_DB_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '8' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_DB_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '8') AS reward, (SELECT ss.name FROM oc_DB_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_DB_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_DB_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_DB_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_DB_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews FROM oc_DB_product p LEFT JOIN oc_DB_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_DB_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_DB_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '347' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_DB_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '8' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_DB_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '8' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_DB_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '8') AS reward, (SELECT ss.name FROM oc_DB_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_DB_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_DB_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_DB_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_DB_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews FROM oc_DB_product p LEFT JOIN oc_DB_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_DB_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_DB_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '270' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_DB_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '8' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_DB_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '8' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_DB_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '8') AS reward, (SELECT ss.name FROM oc_DB_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_DB_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_DB_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_DB_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_DB_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews FROM oc_DB_product p LEFT JOIN oc_DB_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_DB_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_DB_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '67' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_DB_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '8' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_DB_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '8' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_DB_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '8') AS reward, (SELECT ss.name FROM oc_DB_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_DB_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_DB_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_DB_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_DB_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews FROM oc_DB_product p LEFT JOIN oc_DB_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_DB_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_DB_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '265' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_DB_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '8' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_DB_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '8' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_DB_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '8') AS reward, (SELECT ss.name FROM oc_DB_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_DB_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_DB_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_DB_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_DB_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews FROM oc_DB_product p LEFT JOIN oc_DB_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_DB_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_DB_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '266' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_DB_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '8' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_DB_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '8' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_DB_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '8') AS reward, (SELECT ss.name FROM oc_DB_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_DB_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_DB_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_DB_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_DB_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews FROM oc_DB_product p LEFT JOIN oc_DB_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_DB_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_DB_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '264' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_DB_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '8' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_DB_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '8' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_DB_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '8') AS reward, (SELECT ss.name FROM oc_DB_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_DB_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_DB_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_DB_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_DB_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews FROM oc_DB_product p LEFT JOIN oc_DB_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_DB_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_DB_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '241' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_DB_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '8' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_DB_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '8' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_DB_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '8') AS reward, (SELECT ss.name FROM oc_DB_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_DB_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_DB_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_DB_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_DB_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews FROM oc_DB_product p LEFT JOIN oc_DB_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_DB_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_DB_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '242' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_DB_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '8' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_DB_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '8' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_DB_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '8') AS reward, (SELECT ss.name FROM oc_DB_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_DB_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_DB_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_DB_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_DB_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews FROM oc_DB_product p LEFT JOIN oc_DB_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_DB_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_DB_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '243' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=77'
SELECT * FROM oc_DB_url_alias WHERE `query` = 'product_id=335'
SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=77'
SELECT * FROM oc_DB_url_alias WHERE `query` = 'product_id=296'
SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=77'
SELECT * FROM oc_DB_url_alias WHERE `query` = 'product_id=119'
SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=77'
SELECT * FROM oc_DB_url_alias WHERE `query` = 'product_id=297'
SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=77'
SELECT * FROM oc_DB_url_alias WHERE `query` = 'product_id=322'
SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=77'
SELECT * FROM oc_DB_url_alias WHERE `query` = 'product_id=346'
SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=77'
SELECT * FROM oc_DB_url_alias WHERE `query` = 'product_id=347'
SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=77'
SELECT * FROM oc_DB_url_alias WHERE `query` = 'product_id=270'
SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=77'
SELECT * FROM oc_DB_url_alias WHERE `query` = 'product_id=67'
SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=77'
SELECT * FROM oc_DB_url_alias WHERE `query` = 'product_id=265'
SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=77'
SELECT * FROM oc_DB_url_alias WHERE `query` = 'product_id=266'
SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=77'
SELECT * FROM oc_DB_url_alias WHERE `query` = 'product_id=264'
SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=77'
SELECT * FROM oc_DB_url_alias WHERE `query` = 'product_id=241'
SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=77'
SELECT * FROM oc_DB_url_alias WHERE `query` = 'product_id=242'
SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=77'
SELECT * FROM oc_DB_url_alias WHERE `query` = 'product_id=243'
SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=77'
SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=77'
SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=77'
SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=77'
SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=77'
SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=77'
SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=77'
SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=77'
SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=77'
SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=77'
SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=77'
SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=77'
SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=77'
SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=77'
SELECT * FROM oc_DB_url_alias WHERE `query` = 'category_id=77'
SELECT * FROM oc_DB_category_to_layout WHERE category_id = '77' AND store_id = '0'
SELECT * FROM oc_DB_layout_route WHERE 'product/category' 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_category_to_layout WHERE category_id = '77' AND store_id = '0'
SELECT * FROM oc_DB_layout_route WHERE 'product/category' 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_to_layout WHERE category_id = '77' AND store_id = '0'
SELECT * FROM oc_DB_layout_route WHERE 'product/category' 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_to_layout WHERE category_id = '77' AND store_id = '0'
SELECT * FROM oc_DB_layout_route WHERE 'product/category' 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` = '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 = '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'
气油机 Gas Powered Models
商品目录

气油机 Gas Powered Models

排列方式: 直列式 / 棋盘式
显示数量:
排序方式:
30% Stearman PT-17 (空机)
翼  展 : 116 in / 2950 mm 机翼面积 : 3700 sq in / 238.7 sq dm 飞行重量 : 36..
¥6,650.00
50cc Paulistinha (空机)
翼  展 : 118 in / 3000 mm 机翼面积 : 1990 sq in / 126 sq dm 飞行重量 : 18.5 lbs..
¥2,750.00
50cc Slick 540 (空机)
翼  展 : 86 in / 2185 mm 机翼面积 : 1408 sq in / 91 sq dm 飞行重量 : 18 lbs / 8..
¥2,950.00
50cc PIPER CUB (空机)
翼  展 : 118 in / 3000 mm 机翼面积 : 1990 sq in / 128 sq dm 飞行重量 : 18.5 lbs..
¥3,475.00
50cc Pilatus PC-6 Porter (组装木件) (不带烫塑膜)
翼  展 : 125 in / 3175 mm 机翼面积 : 2009 sq in / 130 sq dm 飞行重量 : 26 l..
¥2,725.00
50cc Pilatus PC-6 Porter (不带烫塑膜)
翼  展 : 125 in / 3175 mm 机翼面积 : 2009 sq in / 130 sq dm 飞行重量 : 26 l..
¥3,500.00
50cc Pilatus PC-6 Porter (空机)
翼  展 : 125 in / 3175 mm 机翼面积 : 2009 sq in / 130 sq dm 飞行重量 : 26 l..
¥3,750.00
1/3 PAULISTINHA P-56 80cc (空机)
翼  展 : 141 in / 3580 mm 机翼面积 : 2821 sq in / 182 sq dm 飞行重量 : 28.5 lbs..
¥4,250.00
Piper PA-25 Pawnee 50cc (空机)
翼  展 : 108 in / 2740 mm 机翼面积 : 1643 sq in / 106 sq dm 飞行重量 : 20.5..
¥3,250.00
50cc SKY LINK (空机)
翼  展 : 108 in / 2745 mm 机翼面积 : 1574.8 sq in / 101.6 sq dm 飞..
¥4,000.00
29% Cap 232 50cc (空机)
翼  展 : 85 in / 2160 mm 机翼面积 : 1302 sq in / 84 sq dm 飞行重..
¥2,750.00
100CC SKY LINK (空机)
翼  展 : 144 in / 3650 mm 机翼面积 : 2731 sq in / 176.2 sq dm ..
¥6,250.00
1/3 Clipped Wing Cub 80cc (空机)
翼  展 : 120 in / 3050 mm 机翼面积 : 2402 sq in / 155 sq dm 飞..
¥3,900.00
1/3 PIPER J-3 CUB 80cc (空机)
翼  展 : 141 in / 3580 mm 机翼面积 : 2821 sq in / 182 sq dm 飞行重量 : 28.5 lbs..
¥4,100.00
1/3 SUPER CUB 80cc (空机)
翼  展 : 141 in / 3580 mm 机翼面积 : 2821 sq in / 182 sq dm 飞行重量 : 28.5 lbs..
¥4,250.00
© 全达玩具商行 版权所有,并保留所有权利。
(苏ICP备15005609号)