SELECT * FROM oc_setting WHERE `key` = 'config_timezone' AND store_id = '0'
SET time_zone = '+03:00'
SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '0' AND (route = 'engb' OR route = '')
SELECT `data` FROM `oc_session` WHERE `session_id` = 'bfc2edde5f77c36e5099f04211' AND `expire` > '2024-09-21 11:01:21'Warning: Cannot modify header information - headers already sent by (output started at /home/kitaptavsiyecom/public_html/storage/modification/system/library/db.php:237) in /home/kitaptavsiyecom/public_html/catalog/controller/startup/session.php on line 25
SELECT * FROM oc_store WHERE REPLACE(`ssl`, 'www.', '') = 'https://kitaptavsiye.com.tr/'
SELECT * FROM `oc_setting` WHERE store_id = '0' OR store_id = '0' ORDER BY store_id ASC
SET time_zone = '+03:00'Warning: Cannot modify header information - headers already sent by (output started at /home/kitaptavsiyecom/public_html/storage/modification/system/library/db.php:237) in /home/kitaptavsiyecom/public_html/storage/modification/catalog/controller/startup/startup.php on line 132Warning: Cannot modify header information - headers already sent by (output started at /home/kitaptavsiyecom/public_html/storage/modification/system/library/db.php:237) in /home/kitaptavsiyecom/public_html/storage/modification/catalog/controller/startup/startup.php on line 192
SELECT * FROM oc_currency
SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority FROM oc_tax_rule tr1 LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id) INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id) LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id) LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id) WHERE tr1.based = 'shipping' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '215' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '3335') ORDER BY tr1.priority ASC
SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority FROM oc_tax_rule tr1 LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id) INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id) LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id) LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id) WHERE tr1.based = 'store' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '215' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '3335') ORDER BY tr1.priority ASC
SELECT * FROM oc_weight_class wc LEFT JOIN oc_weight_class_description wcd ON (wc.weight_class_id = wcd.weight_class_id) WHERE wcd.language_id = '1'
SELECT * FROM oc_length_class mc LEFT JOIN oc_length_class_description mcd ON (mc.length_class_id = mcd.length_class_id) WHERE mcd.language_id = '1'
DELETE FROM oc_cart WHERE (api_id > '0' OR customer_id = '0') AND date_added < DATE_SUB(NOW(), INTERVAL 1 HOUR)
SELECT * FROM `oc_event` WHERE `trigger` LIKE 'catalog/%' AND status = '1' ORDER BY `sort_order` ASC
SELECT * FROM oc_seo_url WHERE query LIKE 'route=%' AND keyword = 'amerikan-istihbarat-belgeleriyle-kurtler'
SELECT * FROM oc_seo_url WHERE (keyword = 'amerikan-istihbarat-belgeleriyle-kurtler' OR keyword = 'amerikan-istihbarat-belgeleriyle-kurtler') AND store_id = '0'
SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'product/product' OR route = 'tr-tr')
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/search'
SELECT keyword FROM oc_seo_url WHERE `query` = 'tag=Belgeler'
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' 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_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' 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_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_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_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_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_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_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '22566' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
SELECT * FROM oc_seo_manufacturer_description d WHERE manufacturer_id = '57' AND language_id = '1'AND store_id = '0'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/product'
SELECT keyword FROM oc_seo_url WHERE `query` = 'tag=Belgeler'
SELECT * FROM oc_seo_url WHERE `query` = 'product_id=22566' AND store_id = '0' AND language_id = '1'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/product'
SELECT * FROM oc_seo_url WHERE `query` = 'product_id=22566' AND store_id = '0' AND language_id = '1'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=account/login'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=account/register'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/manufacturer/info'
SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=57' AND store_id = '0' AND language_id = '1'
SELECT * FROM oc_product_image WHERE product_id = '22566' ORDER BY sort_order ASC
SELECT * FROM oc_product_discount WHERE product_id = '22566' AND customer_group_id = '1' AND quantity > 1 AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY quantity ASC, priority ASC, price ASC
SELECT * FROM oc_product_option po LEFT JOIN `oc_option` o ON (po.option_id = o.option_id) LEFT JOIN oc_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '22566' AND od.language_id = '1' ORDER BY o.sort_order
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/product'
SELECT * FROM oc_seo_url WHERE `query` = 'product_id=22566' AND store_id = '0' AND language_id = '1'
SELECT ag.attribute_group_id, agd.name FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id = '22566' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
SELECT * FROM oc_product_related pr LEFT JOIN oc_product p ON (pr.related_id = p.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pr.product_id = '22566' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/search'
SELECT keyword FROM oc_seo_url WHERE `query` = 'tag=Amerikan İstihbarat Belgeleriyle Kürtler'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/search'
SELECT keyword FROM oc_seo_url WHERE `query` = 'tag=9786053430865'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/search'
SELECT keyword FROM oc_seo_url WHERE `query` = 'tag=Araştırma İnceleme'
SELECT rd.* FROM oc_product_recurring pr JOIN oc_recurring_description rd ON (rd.language_id = 1 AND rd.recurring_id = pr.recurring_id) JOIN oc_recurring r ON r.recurring_id = rd.recurring_id WHERE pr.product_id = 22566 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC
UPDATE oc_product SET viewed = (viewed + 1) WHERE product_id = '22566'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/product'
SELECT * FROM oc_seo_url WHERE `query` = 'product_id=22566' AND store_id = '0' AND language_id = '1'
SELECT r.review_id, r.author, r.rating, r.text, p.product_id, pd.name, p.price, p.image, r.date_added FROM oc_review r LEFT JOIN oc_product p ON (r.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) WHERE p.product_id = '22566' AND p.date_available <= NOW() AND p.status = '1' AND r.status = '1' AND pd.language_id = '1' ORDER BY r.date_added DESC LIMIT 0,20
SELECT stock_status_id FROM oc_product WHERE product_id = 22566
SELECT * FROM oc_product_to_layout WHERE product_id = '22566' AND store_id = '0'
SELECT * FROM oc_layout_route WHERE 'product/product' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
SELECT * FROM oc_layout_module WHERE layout_id = '2' AND position = 'column_left' ORDER BY sort_order
SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'default' AND route = 'common/column_left'
SELECT * FROM oc_product_to_layout WHERE product_id = '22566' AND store_id = '0'
SELECT * FROM oc_layout_route WHERE 'product/product' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
SELECT * FROM oc_layout_module WHERE layout_id = '2' AND position = 'column_right' ORDER BY sort_order
SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'default' AND route = 'common/column_right'
SELECT * FROM oc_product_to_layout WHERE product_id = '22566' AND store_id = '0'
SELECT * FROM oc_layout_route WHERE 'product/product' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
SELECT * FROM oc_layout_module WHERE layout_id = '2' AND position = 'content_top' ORDER BY sort_order
SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'default' AND route = 'common/content_top'
SELECT * FROM oc_product_to_layout WHERE product_id = '22566' AND store_id = '0'
SELECT * FROM oc_layout_route WHERE 'product/product' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
SELECT * FROM oc_layout_module WHERE layout_id = '2' AND position = 'content_bottom' ORDER BY sort_order
SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'default' AND route = 'common/content_bottom'
SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/footer' OR route = 'tr-tr')
SELECT * FROM oc_information i LEFT JOIN oc_information_description id ON (i.information_id = id.information_id) LEFT JOIN oc_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' ORDER BY i.sort_order, LCASE(id.title) ASC
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=information/information'
SELECT * FROM oc_seo_url WHERE `query` = 'information_id=4' AND store_id = '0' AND language_id = '1'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=information/information'
SELECT * FROM oc_seo_url WHERE `query` = 'information_id=6' AND store_id = '0' AND language_id = '1'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=information/information'
SELECT * FROM oc_seo_url WHERE `query` = 'information_id=3' AND store_id = '0' AND language_id = '1'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=information/information'
SELECT * FROM oc_seo_url WHERE `query` = 'information_id=5' AND store_id = '0' AND language_id = '1'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=information/contact'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=account/return/add'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=information/sitemap'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=information/tracking'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/manufacturer'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=account/voucher'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=affiliate/login'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/special'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=account/account'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=account/order'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=account/wishlist'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=account/newsletter'
SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'default' AND route = 'common/footer'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/product'
SELECT * FROM oc_seo_url WHERE `query` = 'product_id=22566' AND store_id = '0' AND language_id = '1'
SELECT keyword FROM oc_seo_url WHERE `query` = 'tag=Belgeler'
SELECT * FROM oc_extension WHERE `type` = 'analytics'
SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/header' OR route = 'tr-tr')
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=account/account'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=account/logout'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=account/wishlist'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=account/account'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=account/register'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=account/login'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=account/order'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=account/transaction'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=account/download'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=account/logout'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=checkout/cart'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=checkout/checkout'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=information/contact'
SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/language' OR route = 'tr-tr')
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=common/language/language'
SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'default' AND route = 'common/language'
SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/currency' OR route = 'tr-tr')
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=common/currency/currency'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/product'
SELECT keyword FROM oc_seo_url WHERE `query` = 'tag=Belgeler'
SELECT * FROM oc_seo_url WHERE `query` = 'product_id=22566' AND store_id = '0' AND language_id = '1'
SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'default' AND route = 'common/currency'
SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/search' OR route = 'tr-tr')
SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'default' AND route = 'common/search'
SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/cart' OR route = 'tr-tr')
SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'bfc2edde5f77c36e5099f04211'
SELECT * FROM oc_extension WHERE `type` = 'total'
SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/total/sub_total' OR route = 'tr-tr')
SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'bfc2edde5f77c36e5099f04211'
SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'bfc2edde5f77c36e5099f04211'
SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/total/credit' OR route = 'tr-tr')
SELECT SUM(amount) AS total FROM oc_customer_transaction WHERE customer_id = '0'
SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/total/total' OR route = 'tr-tr')
SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'bfc2edde5f77c36e5099f04211'
SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'bfc2edde5f77c36e5099f04211'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=checkout/cart'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=checkout/checkout'
SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'default' AND route = 'common/cart'
SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/menu' OR route = 'tr-tr')
SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_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_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '463' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '544'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=463' AND store_id = '0' AND language_id = '1'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT category_id, parent_id FROM oc_category WHERE category_id = '463'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=463' AND store_id = '0' AND language_id = '1'
SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '69' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '266'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=69' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '275'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=69' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '194'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=69' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '323'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=69' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '722'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=69' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '122'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=69' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '70'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=69' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '229'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=69' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '89'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=69' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '277'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=69' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '139'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=69' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '326'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=69' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '798'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=69' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '72'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=69' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '279'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=69' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '305'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=69' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '176'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=69' AND store_id = '0' AND language_id = '1'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT category_id, parent_id FROM oc_category WHERE category_id = '69'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=69' AND store_id = '0' AND language_id = '1'
SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '32' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '320'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=32' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '66'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=32' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '154'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=32' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '193'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=32' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '270'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=32' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '156'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=32' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '33'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=32' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '307'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=32' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '104'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=32' AND store_id = '0' AND language_id = '1'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT category_id, parent_id FROM oc_category WHERE category_id = '32'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=32' AND store_id = '0' AND language_id = '1'
SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '20' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '261'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=20' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '267'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=20' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '169'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=20' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '26'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=20' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '130'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=20' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '133'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=20' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '155'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=20' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '162'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=20' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '159'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=20' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '165'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=20' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '180'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=20' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '150'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=20' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '262'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=20' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '21'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=20' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '144'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=20' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '102'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=20' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '158'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=20' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '401'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=20' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '257'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=20' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '153'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=20' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '209'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=20' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '265'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=20' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '313'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=20' AND store_id = '0' AND language_id = '1'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT category_id, parent_id FROM oc_category WHERE category_id = '20'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=20' AND store_id = '0' AND language_id = '1'
SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '915' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '964'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=915' AND store_id = '0' AND language_id = '1'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=964' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '916'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=915' AND store_id = '0' AND language_id = '1'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=916' AND store_id = '0' AND language_id = '1'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT category_id, parent_id FROM oc_category WHERE category_id = '915'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=915' AND store_id = '0' AND language_id = '1'
SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '36' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '260'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=36' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '54'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=36' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '190'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=36' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '37'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=36' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '85'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=36' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '222'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=36' AND store_id = '0' AND language_id = '1'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT category_id, parent_id FROM oc_category WHERE category_id = '36'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=36' AND store_id = '0' AND language_id = '1'
SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '9' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '837'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=9' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '173'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=9' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '96'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=9' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '124'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=9' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '68'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=9' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '207'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=9' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '59'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=9' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '27'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=9' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '74'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=9' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '646'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=9' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '125'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=9' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '10'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=9' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '88'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=9' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '25'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=9' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '284'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=9' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '87'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=9' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '221'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=9' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '126'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=9' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '19'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=9' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '24'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=9' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '157'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=9' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '909'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=9' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '91'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=9' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '206'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=9' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '304'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=9' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '120'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=9' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '259'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=9' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '200'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=9' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '141'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=9' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '223'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=9' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '201'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=9' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '248'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=9' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '835'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=9' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '252'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=9' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '132'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=9' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '179'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=9' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '321'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=9' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '263'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=9' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '255'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=9' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '285'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=9' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '175'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=9' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '140'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=9' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '16'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=9' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '92'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=9' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '39'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=9' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '34'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=9' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '330'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=9' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '51'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=9' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '228'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=9' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '13'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=9' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '450'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=9' AND store_id = '0' AND language_id = '1'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT category_id, parent_id FROM oc_category WHERE category_id = '9'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=9' AND store_id = '0' AND language_id = '1'
SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '14' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '15'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=14' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '55'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=14' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '40'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=14' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '97'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=14' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '75'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=14' AND store_id = '0' AND language_id = '1'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT category_id, parent_id FROM oc_category WHERE category_id = '14'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=14' AND store_id = '0' AND language_id = '1'
SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '42' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '163'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=42' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '114'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=42' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '111'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=42' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '149'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=42' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '251'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=42' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '43'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=42' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '217'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=42' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '65'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=42' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '393'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=42' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '198'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=42' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '283'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=42' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '73'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=42' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '250'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=42' AND store_id = '0' AND language_id = '1'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT category_id, parent_id FROM oc_category WHERE category_id = '42'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=42' AND store_id = '0' AND language_id = '1'
SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '1' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '203'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=1' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '2'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=1' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '258'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=1' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '202'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=1' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '219'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=1' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '224'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=1' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '131'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=1' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '95'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=1' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '310'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=1' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '98'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=1' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '226'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=1' AND store_id = '0' AND language_id = '1'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT category_id, parent_id FROM oc_category WHERE category_id = '1'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=1' AND store_id = '0' AND language_id = '1'
SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '3' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '256'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=3' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '64'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=3' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '4'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=3' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '181'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=3' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '52'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=3' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '227'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=3' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '269'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=3' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '63'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=3' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '205'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=3' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '31'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=3' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '249'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=3' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '328'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=3' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '143'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=3' AND store_id = '0' AND language_id = '1'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT category_id, parent_id FROM oc_category WHERE category_id = '3'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=3' AND store_id = '0' AND language_id = '1'
SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '56' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '57'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=56' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '183'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=56' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '142'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=56' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '303'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=56' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '334'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=56' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '319'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=56' AND store_id = '0' AND language_id = '1'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT category_id, parent_id FROM oc_category WHERE category_id = '56'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=56' AND store_id = '0' AND language_id = '1'
SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_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 COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '137'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=60' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '178'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=60' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '204'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=60' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '306'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=60' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '308'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=60' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '61'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=60' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '113'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=60' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '908'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=60' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '112'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=60' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '309'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=60' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '117'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=60' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '213'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=60' AND store_id = '0' AND language_id = '1'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT category_id, parent_id FROM oc_category WHERE category_id = '60'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=60' AND store_id = '0' AND language_id = '1'
SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '118' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '119'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=118' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '218'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=118' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '135'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=118' AND store_id = '0' AND language_id = '1'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT category_id, parent_id FROM oc_category WHERE category_id = '118'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=118' AND store_id = '0' AND language_id = '1'
SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_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 COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '84'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=78' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '79'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=78' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '186'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=78' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '311'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=78' AND store_id = '0' AND language_id = '1'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT category_id, parent_id FROM oc_category WHERE category_id = '78'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=78' AND store_id = '0' AND language_id = '1'
SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '22' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '94'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=22' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '148'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=22' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '50'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=22' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '90'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=22' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '81'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=22' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '225'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=22' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '80'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=22' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '23'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=22' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '327'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=22' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '167'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=22' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '197'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=22' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '86'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=22' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '28'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=22' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '235'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=22' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '53'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=22' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '189'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=22' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '166'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=22' AND store_id = '0' AND language_id = '1'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT category_id, parent_id FROM oc_category WHERE category_id = '22'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=22' AND store_id = '0' AND language_id = '1'
SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '100' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '268'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=100' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '116'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=100' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '314'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=100' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '353'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=100' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '172'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=100' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '101'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=100' AND store_id = '0' AND language_id = '1'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT category_id, parent_id FROM oc_category WHERE category_id = '100'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=100' AND store_id = '0' AND language_id = '1'
SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '17' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '312'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=17' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '18'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=17' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '41'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=17' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '208'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=17' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '174'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=17' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '161'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=17' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '291'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=17' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '83'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=17' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '199'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=17' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '245'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=17' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '182'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=17' AND store_id = '0' AND language_id = '1'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT category_id, parent_id FROM oc_category WHERE category_id = '17'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=17' AND store_id = '0' AND language_id = '1'
SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '7' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '418'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=7' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '8'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=7' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '247'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=7' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '110'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=7' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '216'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=7' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '214'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=7' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '332'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=7' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '121'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=7' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '82'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=7' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '134'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=7' AND store_id = '0' AND language_id = '1'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT category_id, parent_id FROM oc_category WHERE category_id = '7'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=7' AND store_id = '0' AND language_id = '1'
SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '793' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT category_id, parent_id FROM oc_category WHERE category_id = '793'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=793' AND store_id = '0' AND language_id = '1'
SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '5' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '71'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=5' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '67'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=5' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '6'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=5' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '177'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=5' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '115'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=5' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '35'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=5' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '123'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=5' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '62'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=5' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '152'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=5' AND store_id = '0' AND language_id = '1'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT category_id, parent_id FROM oc_category WHERE category_id = '5'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=5' AND store_id = '0' AND language_id = '1'
SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '191' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '234'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=191' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '569'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=191' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '233'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=191' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '264'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=191' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '215'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=191' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '400'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=191' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '232'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=191' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '192'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=191' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '231'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=191' AND store_id = '0' AND language_id = '1'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT category_id, parent_id FROM oc_category WHERE category_id = '191'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=191' AND store_id = '0' AND language_id = '1'
SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '11' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '30'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=11' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '168'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=11' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '12'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=11' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '44'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=11' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '127'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=11' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '29'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=11' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '160'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=11' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '145'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=11' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '128'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=11' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '47'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=11' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '220'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=11' AND store_id = '0' AND language_id = '1'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT category_id, parent_id FROM oc_category WHERE category_id = '11'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=11' AND store_id = '0' AND language_id = '1'
SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '48' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '49'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=48' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '170'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=48' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '138'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=48' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '136'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=48' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '282'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=48' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '77'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=48' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '271'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=48' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '103'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=48' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '274'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=48' AND store_id = '0' AND language_id = '1'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT category_id, parent_id FROM oc_category WHERE category_id = '48'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=48' AND store_id = '0' AND language_id = '1'
SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '108' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT category_id, parent_id FROM oc_category WHERE category_id = '108'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=108' AND store_id = '0' AND language_id = '1'
SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '151' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT category_id, parent_id FROM oc_category WHERE category_id = '151'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=151' AND store_id = '0' AND language_id = '1'
SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '45' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '246'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=45' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '236'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=45' AND store_id = '0' AND language_id = '1'
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 cp.path_id = '46'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=45' AND store_id = '0' AND language_id = '1'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/category'
SELECT category_id, parent_id FROM oc_category WHERE category_id = '45'
SELECT * FROM oc_seo_url WHERE `query` = 'category_id=45' AND store_id = '0' AND language_id = '1'
SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'default' AND route = 'common/menu'
SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'default' AND route = 'common/header'
SELECT * FROM oc_setting WHERE store_id = '0' AND `code` = 'advertise_google'
SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'default' AND route = 'product/product'
SELECT * FROM oc_setting WHERE store_id = '0' AND `code` = 'advertise_google'
Tanıtım MetniEtiketler: Amerikan İstihbarat Belgeleriyle Kürtler, 9786053430865, Araştırma İnceleme
REPLACE INTO `oc_session` SET `session_id` = 'bfc2edde5f77c36e5099f04211', `data` = '{\"language\":\"tr-tr\",\"currency\":\"TRY\"}', `expire` = '2024-09-21 15:01:21'