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` = '187091a4f4ad751c28bcb8404a' AND `expire` > '2024-09-21 11:00:45'
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 = 'benjamin' 
SELECT * FROM oc_seo_url WHERE (keyword = 'benjamin' OR keyword = 'benjamin') 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=9789754685428'
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 = '39614' 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 = '65' 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=9789754685428'
SELECT * FROM oc_seo_url WHERE `query` = 'product_id=39614' 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=39614' 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=65' AND store_id = '0' AND language_id = '1'
SELECT * FROM oc_product_image WHERE product_id = '39614' ORDER BY sort_order ASC
SELECT * FROM oc_product_discount WHERE product_id = '39614' 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 = '39614' 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=39614' 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 = '39614' 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 = '39614' 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=Benjamin'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/search'
SELECT keyword FROM oc_seo_url WHERE `query` = 'tag=9789754685428'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/search'
SELECT keyword FROM oc_seo_url WHERE `query` = 'tag=Diğer'
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 = 39614 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC
UPDATE oc_product SET viewed = (viewed + 1) WHERE product_id = '39614'
SELECT keyword FROM oc_seo_url WHERE `query` = 'route=product/product'
SELECT * FROM oc_seo_url WHERE `query` = 'product_id=39614' 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 = '39614' 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 * FROM oc_product_to_layout WHERE product_id = '39614' 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 = '39614' 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 = '39614' 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 = '39614' 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=39614' AND store_id = '0' AND language_id = '1'
SELECT keyword FROM oc_seo_url WHERE `query` = 'tag=9789754685428'
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=9789754685428'
SELECT * FROM oc_seo_url WHERE `query` = 'product_id=39614' 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 = '187091a4f4ad751c28bcb8404a'
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 = '187091a4f4ad751c28bcb8404a'
SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '187091a4f4ad751c28bcb8404a'
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 = '187091a4f4ad751c28bcb8404a'
SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '187091a4f4ad751c28bcb8404a'
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'
Benjamin - Say Yayınları

  • Alışveriş sepetiniz boş!

  • Benjamin - Say Yayınları
Hegel, Napolyon’u atının sırtında görünce onu Geist zannetmişti. Marx ise proleteryada aynı şeyi gördü. Benjamin işte tam buna mesih diyordu, mesihçi düşünce diyordu. Belki de Batı düşüncesi başından beri hep aynı şeyin peşindeydi. Ortaçağdan modernliğe geçerken bu düşünce ana eksenini değiştirmedi, sadece hedefe varmak için kullandığı araçları değiştirdi. Görev Tanrıdan insana devredilmişti, Teolojik içerik laik bir dile tercüme edilmişti. Kurtuluş motifi Batı düşüncesinin ciğeridir. Bunu bir mesih, bir peygamber, bir tarihsel kahraman ya da bir toplumsal sınıf başaracaktır. Bunlar aynı soruya yönelik farklı yanıtlardır. Soru hiç değişmemiştir. Aslında proleterya mesih terminolojisini ilk kullanan Lukacs’dır. Lukacs, 1918’de yazdığı Ahlaki Bir Sorun Olarak Bolşevizm başlıklı yazıda proleteryayı dünya tarihinin mesih-sınıfı olarak nitelemiştir. İşte Benjamin’in Tarih Tezleri sadece bunu anlatır. Bizler bu dünyada bekleniyorduk. Benjamin sanki aydınlanmanın yaptığının tersini yapmaya çalışır. Weber demişti ya: dünyanın büyüsünün bozulması. O, dünyayı tekrar büyüsüne kavuşturmaya çalışır. Onun düşüncesinde ilerlemenin, gelişmenin, evrimin zerresine rastlanmaz. Tarihi akışına bırakmak, onu egemenlerin oyuncağı kılmaktır. Onun amacı tarihi tersine işletmektir sanki. Tarihi tersine taramak. Evet bunun adı devrimdir. -Besim F. Dellaloğlu- Tanıtım Metni

Yorum Yap

Not: HTML'e dönüştürülmez!
    Kötü           İyi

Benjamin

  • Marka: Say Yayınları
  • Ürün Kodu: 9789754685428
  • Stok Durumu: Stokta var

  • 30,00₺

  • Vergiler Hariç: 30,00₺

0 yorum / Yorum Yap

Etiketler: Benjamin, 9789754685428, Diğer 

REPLACE INTO `oc_session` SET `session_id` = '187091a4f4ad751c28bcb8404a', `data` = '{\"language\":\"tr-tr\",\"currency\":\"TRY\"}', `expire` = '2024-09-21 15:00:45'