SELECT *
FROM oc_extension
WHERE `type` = 'openbay'

SELECT *
FROM oc_store
WHERE REPLACE(`ssl`, 'www.', '') = 'https://shreebookcentre.com/'

SELECT *
FROM `oc_setting`
WHERE store_id = '0' OR store_id = '0'
ORDER BY store_id ASC

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 = '2' AND z2gz.country_id = '99' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '1493')
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 = '2' AND z2gz.country_id = '99' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '1493')
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_extension
WHERE `type` = 'openbay'

SELECT *
FROM `oc_event`
WHERE `trigger` LIKE 'catalog/%' AND status = '1'
ORDER BY `event_id` ASC

SELECT *
FROM oc_url_alias
WHERE keyword = 'adult'

SELECT DISTINCT *
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.category_id = '678' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'

SELECT *
FROM oc_url_alias
WHERE keyword = 'religion-spirituality'

SELECT DISTINCT *
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.category_id = '679' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'

SELECT DISTINCT *
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.category_id = '679' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'

SELECT DISTINCT *
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.category_id = '974' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'

SELECT *
FROM oc_url_alias
WHERE keyword = 'philosophy'

SELECT DISTINCT *
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.category_id = '957' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'

SELECT DISTINCT *
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.category_id = '957' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'

SELECT DISTINCT *
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.category_id = '1592' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'

SELECT *
FROM oc_url_alias
WHERE `query` = 'route=common/home'

SELECT DISTINCT *
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.category_id = '678' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'

SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/category'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'

SELECT DISTINCT *
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.category_id = '679' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'

SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/category'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=679'

SELECT DISTINCT *
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.category_id = '1592' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'

SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/category'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=679'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=1592'

SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/compare'

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 = '1592' 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_url_alias
WHERE `query` = 'route=product/category'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=679'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=1592'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=1593'

SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_category_path cp
LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN oc_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '1592'

SELECT p.product_id, (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 price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '2' 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 = '2' 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
FROM oc_category_path cp
LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN oc_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '1592' GROUP BY p.product_id
ORDER BY p.sort_order ASC, LCASE(pd.name) ASC LIMIT 0,20

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 = '2' 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 = '2' 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 = '2') 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 = '1948' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '2' 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 = '2' 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 = '2') 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 = '1947' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/product'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=679'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=1592'

SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=1948'

SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/product'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=679'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=1592'

SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=1947'

SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/category'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=679'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=1592'

SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/category'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=679'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=1592'

SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/category'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=679'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=1592'

SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/category'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=679'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=1592'

SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/category'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=679'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=1592'

SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/category'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=679'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=1592'

SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/category'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=679'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=1592'

SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/category'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=679'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=1592'

SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/category'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=679'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=1592'

SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/category'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=679'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=1592'

SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/category'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=679'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=1592'

SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/category'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=679'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=1592'

SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/category'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=679'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=1592'

SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/category'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=679'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=1592'

SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/category'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=679'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=1592'

SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/category'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=1592'

SELECT *
FROM oc_url_alias
WHERE `query` = 'route=common/home'

SELECT *
FROM oc_category_to_layout
WHERE category_id = '1592' AND store_id = '0'

SELECT *
FROM oc_layout_route
WHERE 'product/category' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1

SELECT *
FROM oc_layout_module
WHERE layout_id = '3' AND position = 'column_left'
ORDER BY sort_order

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 = '678' 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 = '681' 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_url_alias
WHERE `query` = 'route=product/category'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=681'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=1680'

SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/category'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=681'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=994'

SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/category'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=681'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=1103'

SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/category'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=681'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=682'

SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/category'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=681'

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 = '683' 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_url_alias
WHERE `query` = 'route=product/category'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=683'

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 = '834' 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_url_alias
WHERE `query` = 'route=product/category'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=834'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=960'

SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/category'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=834'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=944'

SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/category'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=834'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=1023'

SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/category'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=834'

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 = '1021' 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_url_alias
WHERE `query` = 'route=product/category'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=1021'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=1033'

SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/category'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=1021'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=1042'

SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/category'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=1021'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=1022'

SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/category'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=1021'

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 = '1024' 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_url_alias
WHERE `query` = 'route=product/category'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=1024'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=1025'

SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/category'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=1024'

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 = '1039' 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_url_alias
WHERE `query` = 'route=product/category'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=1039'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=1107'

SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/category'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=1039'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=1064'

SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/category'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=1039'

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 = '970' 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_url_alias
WHERE `query` = 'route=product/category'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=970'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=971'

SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/category'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=970'

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 = '876' 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_url_alias
WHERE `query` = 'route=product/category'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=876'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=985'

SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/category'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=876'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=980'

SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/category'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=876'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=979'

SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/category'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=876'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=906'

SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/category'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=876'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=978'

SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/category'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=876'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=981'

SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/category'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=876'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=983'

SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/category'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=876'

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 = '685' 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_url_alias
WHERE `query` = 'route=product/category'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=685'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=686'

SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/category'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=685'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=826'

SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/category'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=685'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=827'

SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/category'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=685'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=1108'

SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/category'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=685'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=1027'

SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/category'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=685'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=830'

SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/category'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=685'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=687'

SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/category'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=685'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=955'

SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/category'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=685'

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 = '1664' 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_url_alias
WHERE `query` = 'route=product/category'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=1664'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=1665'

SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/category'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=1664'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=1667'

SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/category'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=1664'

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 = '841' 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_url_alias
WHERE `query` = 'route=product/category'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=841'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=842'

SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/category'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=841'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=996'

SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/category'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=841'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=1003'

SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/category'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=841'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=886'

SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/category'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=841'

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 = '1037' 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_url_alias
WHERE `query` = 'route=product/category'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=1037'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=1038'

SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/category'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=1037'

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 = '987' 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_url_alias
WHERE `query` = 'route=product/category'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=987'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=1683'

SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/category'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=987'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=988'

SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/category'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=987'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=993'

SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/category'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=987'

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 = '832' 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_url_alias
WHERE `query` = 'route=product/category'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=832'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=961'

SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/category'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=832'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=942'

SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/category'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=832'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=1009'

SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/category'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=832'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=1053'

SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/category'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=832'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=962'

SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/category'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=832'

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 = '836' 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_url_alias
WHERE `query` = 'route=product/category'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=836'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=837'

SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/category'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=836'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=1068'

SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/category'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=836'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=1030'

SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/category'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=836'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=1084'

SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/category'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=836'

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 = '822' 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_url_alias
WHERE `query` = 'route=product/category'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=822'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=1104'

SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/category'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=822'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=823'

SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/category'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=822'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=892'

SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/category'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=822'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=847'

SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/category'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=822'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=1645'

SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/category'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=822'

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 = '844' 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_url_alias
WHERE `query` = 'route=product/category'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=844'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=969'

SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/category'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=844'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=1591'

SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/category'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=844'

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 = '1061' 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_url_alias
WHERE `query` = 'route=product/category'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=1061'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=1062'

SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/category'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=1061'

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 = '810' 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_url_alias
WHERE `query` = 'route=product/category'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=810'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=811'

SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/category'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=810'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=1582'

SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/category'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=810'

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 = '1681' 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_url_alias
WHERE `query` = 'route=product/category'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=1681'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=1682'

SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/category'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=1681'

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 = '1646' 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_url_alias
WHERE `query` = 'route=product/category'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=1646'

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 = '679' 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_url_alias
WHERE `query` = 'route=product/category'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=679'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=1592'

SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/category'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=679'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=966'

SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/category'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=679'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=680'

SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/category'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=679'

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 = '828' 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_url_alias
WHERE `query` = 'route=product/category'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=828'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=831'

SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/category'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=828'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=1687'

SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/category'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=828'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=1620'

SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/category'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=828'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=1621'

SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/category'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=828'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=1622'

SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/category'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=828'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=1106'

SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/category'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=828'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=957'

SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/category'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=828'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=958'

SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/category'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=828'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=890'

SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/category'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=828'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=1626'

SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/category'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=828'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=959'

SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/category'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=828'

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 = '838' 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_url_alias
WHERE `query` = 'route=product/category'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=838'

SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/category'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'

SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/category'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=594'

SELECT DISTINCT *
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.category_id = '1592' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'

SELECT *
FROM oc_url_alias
WHERE `query` = 'route=product/category'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=678'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=679'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=1592'

SELECT filter_id
FROM oc_category_filter
WHERE category_id = '1592'

SELECT DISTINCT f.filter_group_id, fgd.name, fg.sort_order
FROM oc_filter f
LEFT JOIN oc_filter_group fg ON (f.filter_group_id = fg.filter_group_id)
LEFT JOIN oc_filter_group_description fgd ON (fg.filter_group_id = fgd.filter_group_id)
WHERE f.filter_id IN (1153,1154,1155,1156,1157,1158,1159,1160,1161,1162,1163,1164,1165,1166,1169,1175,1176,1177,1178,1179,1180,1181,1182,1183,1184,1185,1186,1187,1188,1189,1190,1191,1192,1193,1194,1195,1196,1197,1198,1199,1200,1201,1202,1203,1204,1205,1206,1207,1208,1209,1210,1211,1212,1213,1214,1215,1216,1217,1218,1219,1220,1221,1222,1223,1224,1225,1226,1227,1228,1229,1230,1231,1232,1233,1234,1235,1236,1237,1279,1458,1459,1460,1461,1462,1463,1464,1465,1466,1506,1546,1586,1587,1588,1589,1590,1591,1592,1593,1594,1595,1596,1613,1615,1616,1634,1635,1636,1637,1638,1639,1640,1647,1648,1649,1650,1651,1652,1653,1654,1655,1656,1657,1658,1695,1696,1697,1698,1699,1700,1701,1702,1703,1704,1705,1706,1707,1708,1709,1710,1711,1712,1713,1714,1715,1716,1717,1718,1719,1720,1721,1722,1723,1724,1725,1726,1727,1728,1729,1730,1731,1732,1733,1734,1735,1736,1737,1738,1739,1740,1741,1742,1743,1744,1745,1746,1747,1748,1749,1750,1751,1752,1753,1754,1755,1756,1757,1758,1759,1760,1761,1762,1763,1764,1765,1766,1767,1768,1769,1770,1771,1772,1773,1774,1775,1776,1777,1778,1779,1780,1781,1782,1783,1784,1785,1786,1787,1788,1789,1790,1791,1792,1793,1794,1795,1796,1797,1798,1799,1800,1801,1802,1803,1804,1805,1806,1807,1808,1809,1810,1811,1812,1813,1814,1815,1816,1817,1818,1819,1820,1821,1822,1823,1824,1825,1826,1827,1828,1829,1830,1831,1832,1833,1834,1835,1836,1837,1838,1839,1840,1841,1842,1843,1844,1845,1846,1847,1848,1849,1850,1851,1852,1853,1854,1855,1856,1857,1858,1859,1860,1861,1862,1863,1864,1865,1866,1867,1868,1869,1870,1871,1872,1873,1874,1875,1876,1877,1878,1879,1880,1881,1882,1883,1884,1885,1886,1887,1888,1889,1890,1891,1892,1893,1894,1895,1896,1897,1898,1899,1900,1901,1902,1903,1904,1905,1906,1907,1908,1909,1910,1911,1912,1913,1914,1915,1916,1917,1918,1919,1920,1921,1922,1923,1924,1925,1926,1927,1928,1929,1930,1931,1932,1933,1934,1935,1936,1937,1938,1939,1940,1941,1942,1943,1944,1945,1946,1947,1948,1949,1950,1951,1952,1953,1954,1955,1956,1957,1958,1959,1960,1961,1962,1963,1964,1965,1966,1967,1968,1969,1970,1971,1972,1973,1974,1975,1976,1977,1978,1979,1980,1981,1982,1983,1984,1985,1986,1987,1988,1989,1990,1991,1992,1993,1994,1995,1996,1997,1998,1999,2000,2001,2002,2003,2004,2005,2006,2007,2008,2009,2010,2011,2012,2013,2015,2016,2017,2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,2046,2047,2048,2049,2050,2051,2052,2053,2054,2055,2056,2057,2058,2059,2060,2061,2062,2063,2064,2065,2066,2067,2068,2069,2070,2071,2072,2073,2074,2075,2076,2077,2078,2079,2080,2081,2082,2083,2084,2085,2086,2087,2088,2089,2090,2091,2092,2093,2094) AND fgd.language_id = '1' GROUP BY f.filter_group_id
ORDER BY fg.sort_order, LCASE(fgd.name)

SELECT DISTINCT f.filter_id, fd.name
FROM oc_filter f
LEFT JOIN oc_filter_description fd ON (f.filter_id = fd.filter_id)
WHERE f.filter_id IN (1153,1154,1155,1156,1157,1158,1159,1160,1161,1162,1163,1164,1165,1166,1169,1175,1176,1177,1178,1179,1180,1181,1182,1183,1184,1185,1186,1187,1188,1189,1190,1191,1192,1193,1194,1195,1196,1197,1198,1199,1200,1201,1202,1203,1204,1205,1206,1207,1208,1209,1210,1211,1212,1213,1214,1215,1216,1217,1218,1219,1220,1221,1222,1223,1224,1225,1226,1227,1228,1229,1230,1231,1232,1233,1234,1235,1236,1237,1279,1458,1459,1460,1461,1462,1463,1464,1465,1466,1506,1546,1586,1587,1588,1589,1590,1591,1592,1593,1594,1595,1596,1613,1615,1616,1634,1635,1636,1637,1638,1639,1640,1647,1648,1649,1650,1651,1652,1653,1654,1655,1656,1657,1658,1695,1696,1697,1698,1699,1700,1701,1702,1703,1704,1705,1706,1707,1708,1709,1710,1711,1712,1713,1714,1715,1716,1717,1718,1719,1720,1721,1722,1723,1724,1725,1726,1727,1728,1729,1730,1731,1732,1733,1734,1735,1736,1737,1738,1739,1740,1741,1742,1743,1744,1745,1746,1747,1748,1749,1750,1751,1752,1753,1754,1755,1756,1757,1758,1759,1760,1761,1762,1763,1764,1765,1766,1767,1768,1769,1770,1771,1772,1773,1774,1775,1776,1777,1778,1779,1780,1781,1782,1783,1784,1785,1786,1787,1788,1789,1790,1791,1792,1793,1794,1795,1796,1797,1798,1799,1800,1801,1802,1803,1804,1805,1806,1807,1808,1809,1810,1811,1812,1813,1814,1815,1816,1817,1818,1819,1820,1821,1822,1823,1824,1825,1826,1827,1828,1829,1830,1831,1832,1833,1834,1835,1836,1837,1838,1839,1840,1841,1842,1843,1844,1845,1846,1847,1848,1849,1850,1851,1852,1853,1854,1855,1856,1857,1858,1859,1860,1861,1862,1863,1864,1865,1866,1867,1868,1869,1870,1871,1872,1873,1874,1875,1876,1877,1878,1879,1880,1881,1882,1883,1884,1885,1886,1887,1888,1889,1890,1891,1892,1893,1894,1895,1896,1897,1898,1899,1900,1901,1902,1903,1904,1905,1906,1907,1908,1909,1910,1911,1912,1913,1914,1915,1916,1917,1918,1919,1920,1921,1922,1923,1924,1925,1926,1927,1928,1929,1930,1931,1932,1933,1934,1935,1936,1937,1938,1939,1940,1941,1942,1943,1944,1945,1946,1947,1948,1949,1950,1951,1952,1953,1954,1955,1956,1957,1958,1959,1960,1961,1962,1963,1964,1965,1966,1967,1968,1969,1970,1971,1972,1973,1974,1975,1976,1977,1978,1979,1980,1981,1982,1983,1984,1985,1986,1987,1988,1989,1990,1991,1992,1993,1994,1995,1996,1997,1998,1999,2000,2001,2002,2003,2004,2005,2006,2007,2008,2009,2010,2011,2012,2013,2015,2016,2017,2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,2046,2047,2048,2049,2050,2051,2052,2053,2054,2055,2056,2057,2058,2059,2060,2061,2062,2063,2064,2065,2066,2067,2068,2069,2070,2071,2072,2073,2074,2075,2076,2077,2078,2079,2080,2081,2082,2083,2084,2085,2086,2087,2088,2089,2090,2091,2092,2093,2094) AND f.filter_group_id = '26' AND fd.language_id = '1'
ORDER BY f.sort_order, LCASE(fd.name)

SELECT DISTINCT f.filter_id, fd.name
FROM oc_filter f
LEFT JOIN oc_filter_description fd ON (f.filter_id = fd.filter_id)
WHERE f.filter_id IN (1153,1154,1155,1156,1157,1158,1159,1160,1161,1162,1163,1164,1165,1166,1169,1175,1176,1177,1178,1179,1180,1181,1182,1183,1184,1185,1186,1187,1188,1189,1190,1191,1192,1193,1194,1195,1196,1197,1198,1199,1200,1201,1202,1203,1204,1205,1206,1207,1208,1209,1210,1211,1212,1213,1214,1215,1216,1217,1218,1219,1220,1221,1222,1223,1224,1225,1226,1227,1228,1229,1230,1231,1232,1233,1234,1235,1236,1237,1279,1458,1459,1460,1461,1462,1463,1464,1465,1466,1506,1546,1586,1587,1588,1589,1590,1591,1592,1593,1594,1595,1596,1613,1615,1616,1634,1635,1636,1637,1638,1639,1640,1647,1648,1649,1650,1651,1652,1653,1654,1655,1656,1657,1658,1695,1696,1697,1698,1699,1700,1701,1702,1703,1704,1705,1706,1707,1708,1709,1710,1711,1712,1713,1714,1715,1716,1717,1718,1719,1720,1721,1722,1723,1724,1725,1726,1727,1728,1729,1730,1731,1732,1733,1734,1735,1736,1737,1738,1739,1740,1741,1742,1743,1744,1745,1746,1747,1748,1749,1750,1751,1752,1753,1754,1755,1756,1757,1758,1759,1760,1761,1762,1763,1764,1765,1766,1767,1768,1769,1770,1771,1772,1773,1774,1775,1776,1777,1778,1779,1780,1781,1782,1783,1784,1785,1786,1787,1788,1789,1790,1791,1792,1793,1794,1795,1796,1797,1798,1799,1800,1801,1802,1803,1804,1805,1806,1807,1808,1809,1810,1811,1812,1813,1814,1815,1816,1817,1818,1819,1820,1821,1822,1823,1824,1825,1826,1827,1828,1829,1830,1831,1832,1833,1834,1835,1836,1837,1838,1839,1840,1841,1842,1843,1844,1845,1846,1847,1848,1849,1850,1851,1852,1853,1854,1855,1856,1857,1858,1859,1860,1861,1862,1863,1864,1865,1866,1867,1868,1869,1870,1871,1872,1873,1874,1875,1876,1877,1878,1879,1880,1881,1882,1883,1884,1885,1886,1887,1888,1889,1890,1891,1892,1893,1894,1895,1896,1897,1898,1899,1900,1901,1902,1903,1904,1905,1906,1907,1908,1909,1910,1911,1912,1913,1914,1915,1916,1917,1918,1919,1920,1921,1922,1923,1924,1925,1926,1927,1928,1929,1930,1931,1932,1933,1934,1935,1936,1937,1938,1939,1940,1941,1942,1943,1944,1945,1946,1947,1948,1949,1950,1951,1952,1953,1954,1955,1956,1957,1958,1959,1960,1961,1962,1963,1964,1965,1966,1967,1968,1969,1970,1971,1972,1973,1974,1975,1976,1977,1978,1979,1980,1981,1982,1983,1984,1985,1986,1987,1988,1989,1990,1991,1992,1993,1994,1995,1996,1997,1998,1999,2000,2001,2002,2003,2004,2005,2006,2007,2008,2009,2010,2011,2012,2013,2015,2016,2017,2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,2046,2047,2048,2049,2050,2051,2052,2053,2054,2055,2056,2057,2058,2059,2060,2061,2062,2063,2064,2065,2066,2067,2068,2069,2070,2071,2072,2073,2074,2075,2076,2077,2078,2079,2080,2081,2082,2083,2084,2085,2086,2087,2088,2089,2090,2091,2092,2093,2094) AND f.filter_group_id = '25' AND fd.language_id = '1'
ORDER BY f.sort_order, LCASE(fd.name)

SELECT DISTINCT f.filter_id, fd.name
FROM oc_filter f
LEFT JOIN oc_filter_description fd ON (f.filter_id = fd.filter_id)
WHERE f.filter_id IN (1153,1154,1155,1156,1157,1158,1159,1160,1161,1162,1163,1164,1165,1166,1169,1175,1176,1177,1178,1179,1180,1181,1182,1183,1184,1185,1186,1187,1188,1189,1190,1191,1192,1193,1194,1195,1196,1197,1198,1199,1200,1201,1202,1203,1204,1205,1206,1207,1208,1209,1210,1211,1212,1213,1214,1215,1216,1217,1218,1219,1220,1221,1222,1223,1224,1225,1226,1227,1228,1229,1230,1231,1232,1233,1234,1235,1236,1237,1279,1458,1459,1460,1461,1462,1463,1464,1465,1466,1506,1546,1586,1587,1588,1589,1590,1591,1592,1593,1594,1595,1596,1613,1615,1616,1634,1635,1636,1637,1638,1639,1640,1647,1648,1649,1650,1651,1652,1653,1654,1655,1656,1657,1658,1695,1696,1697,1698,1699,1700,1701,1702,1703,1704,1705,1706,1707,1708,1709,1710,1711,1712,1713,1714,1715,1716,1717,1718,1719,1720,1721,1722,1723,1724,1725,1726,1727,1728,1729,1730,1731,1732,1733,1734,1735,1736,1737,1738,1739,1740,1741,1742,1743,1744,1745,1746,1747,1748,1749,1750,1751,1752,1753,1754,1755,1756,1757,1758,1759,1760,1761,1762,1763,1764,1765,1766,1767,1768,1769,1770,1771,1772,1773,1774,1775,1776,1777,1778,1779,1780,1781,1782,1783,1784,1785,1786,1787,1788,1789,1790,1791,1792,1793,1794,1795,1796,1797,1798,1799,1800,1801,1802,1803,1804,1805,1806,1807,1808,1809,1810,1811,1812,1813,1814,1815,1816,1817,1818,1819,1820,1821,1822,1823,1824,1825,1826,1827,1828,1829,1830,1831,1832,1833,1834,1835,1836,1837,1838,1839,1840,1841,1842,1843,1844,1845,1846,1847,1848,1849,1850,1851,1852,1853,1854,1855,1856,1857,1858,1859,1860,1861,1862,1863,1864,1865,1866,1867,1868,1869,1870,1871,1872,1873,1874,1875,1876,1877,1878,1879,1880,1881,1882,1883,1884,1885,1886,1887,1888,1889,1890,1891,1892,1893,1894,1895,1896,1897,1898,1899,1900,1901,1902,1903,1904,1905,1906,1907,1908,1909,1910,1911,1912,1913,1914,1915,1916,1917,1918,1919,1920,1921,1922,1923,1924,1925,1926,1927,1928,1929,1930,1931,1932,1933,1934,1935,1936,1937,1938,1939,1940,1941,1942,1943,1944,1945,1946,1947,1948,1949,1950,1951,1952,1953,1954,1955,1956,1957,1958,1959,1960,1961,1962,1963,1964,1965,1966,1967,1968,1969,1970,1971,1972,1973,1974,1975,1976,1977,1978,1979,1980,1981,1982,1983,1984,1985,1986,1987,1988,1989,1990,1991,1992,1993,1994,1995,1996,1997,1998,1999,2000,2001,2002,2003,2004,2005,2006,2007,2008,2009,2010,2011,2012,2013,2015,2016,2017,2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,2046,2047,2048,2049,2050,2051,2052,2053,2054,2055,2056,2057,2058,2059,2060,2061,2062,2063,2064,2065,2066,2067,2068,2069,2070,2071,2072,2073,2074,2075,2076,2077,2078,2079,2080,2081,2082,2083,2084,2085,2086,2087,2088,2089,2090,2091,2092,2093,2094) AND f.filter_group_id = '24' AND fd.language_id = '1'
ORDER BY f.sort_order, LCASE(fd.name)

SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_product_to_category p2c
LEFT JOIN oc_product_filter pf ON (p2c.product_id = pf.product_id)
LEFT JOIN oc_product p ON (pf.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '1592' AND pf.filter_id IN (1886)

SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_product_to_category p2c
LEFT JOIN oc_product_filter pf ON (p2c.product_id = pf.product_id)
LEFT JOIN oc_product p ON (pf.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '1592' AND pf.filter_id IN (1160)

SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_product_to_category p2c
LEFT JOIN oc_product_filter pf ON (p2c.product_id = pf.product_id)
LEFT JOIN oc_product p ON (pf.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '1592' AND pf.filter_id IN (1235)

SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_product_to_category p2c
LEFT JOIN oc_product_filter pf ON (p2c.product_id = pf.product_id)
LEFT JOIN oc_product p ON (pf.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '1592' AND pf.filter_id IN (1223)

SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_product_to_category p2c
LEFT JOIN oc_product_filter pf ON (p2c.product_id = pf.product_id)
LEFT JOIN oc_product p ON (pf.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '1592' AND pf.filter_id IN (1155)

SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_product_to_category p2c
LEFT JOIN oc_product_filter pf ON (p2c.product_id = pf.product_id)
LEFT JOIN oc_product p ON (pf.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '1592' AND pf.filter_id IN (1985)

SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_product_to_category p2c
LEFT JOIN oc_product_filter pf ON (p2c.product_id = pf.product_id)
LEFT JOIN oc_product p ON (pf.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '1592' AND pf.filter_id IN (1229)

SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_product_to_category p2c
LEFT JOIN oc_product_filter pf ON (p2c.product_id = pf.product_id)
LEFT JOIN oc_product p ON (pf.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '1592' AND pf.filter_id IN (2055)

SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_product_to_category p2c
LEFT JOIN oc_product_filter pf ON (p2c.product_id = pf.product_id)
LEFT JOIN oc_product p ON (pf.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '1592' AND pf.filter_id IN (1165)

SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_product_to_category p2c
LEFT JOIN oc_product_filter pf ON (p2c.product_id = pf.product_id)
LEFT JOIN oc_product p ON (pf.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '1592' AND pf.filter_id IN (1957)

SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_product_to_category p2c
LEFT JOIN oc_product_filter pf ON (p2c.product_id = pf.product_id)
LEFT JOIN oc_product p ON (pf.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '1592' AND pf.filter_id IN (1202)

SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_product_to_category p2c
LEFT JOIN oc_product_filter pf ON (p2c.product_id = pf.product_id)
LEFT JOIN oc_product p ON (pf.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '1592' AND pf.filter_id IN (1928)

SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_product_to_category p2c
LEFT JOIN oc_product_filter pf ON (p2c.product_id = pf.product_id)
LEFT JOIN oc_product p ON (pf.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '1592' AND pf.filter_id IN (2083)

SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_product_to_category p2c
LEFT JOIN oc_product_filter pf ON (p2c.product_id = pf.product_id)
LEFT JOIN oc_product p ON (pf.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '1592' AND pf.filter_id IN (1951)

SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_product_to_category p2c
LEFT JOIN oc_product_filter pf ON (p2c.product_id = pf.product_id)
LEFT JOIN oc_product p ON (pf.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '1592' AND pf.filter_id IN (1885)

SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_product_to_category p2c
LEFT JOIN oc_product_filter pf ON (p2c.product_id = pf.product_id)
LEFT JOIN oc_product p ON (pf.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '1592' AND pf.filter_id IN (1952)

SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_product_to_category p2c
LEFT JOIN oc_product_filter pf ON (p2c.product_id = pf.product_id)
LEFT JOIN oc_product p ON (pf.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '1592' AND pf.filter_id IN (2060)

SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_product_to_category p2c
LEFT JOIN oc_product_filter pf ON (p2c.product_id = pf.product_id)
LEFT JOIN oc_product p ON (pf.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '1592' AND pf.filter_id IN (1225)

SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_product_to_category p2c
LEFT JOIN oc_product_filter pf ON (p2c.product_id = pf.product_id)
LEFT JOIN oc_product p ON (pf.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '1592' AND pf.filter_id IN (1905)

SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_product_to_category p2c
LEFT JOIN oc_product_filter pf ON (p2c.product_id = pf.product_id)
LEFT JOIN oc_product p ON (pf.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '1592' AND pf.filter_id IN (1915)

SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_product_to_category p2c
LEFT JOIN oc_product_filter pf ON (p2c.product_id = pf.product_id)
LEFT JOIN oc_product p ON (pf.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '1592' AND pf.filter_id IN (1907)

SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_product_to_category p2c
LEFT JOIN oc_product_filter pf ON (p2c.product_id = pf.product_id)
LEFT JOIN oc_product p ON (pf.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '1592' AND pf.filter_id IN (2026)

SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_product_to_category p2c
LEFT JOIN oc_product_filter pf ON (p2c.product_id = pf.product_id)
LEFT JOIN oc_product p ON (pf.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '1592' AND pf.filter_id IN (1931)

SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_product_to_category p2c
LEFT JOIN oc_product_filter pf ON (p2c.product_id = pf.product_id)
LEFT JOIN oc_product p ON (pf.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '1592' AND pf.filter_id IN (1914)

SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_product_to_category p2c
LEFT JOIN oc_product_filter pf ON (p2c.product_id = pf.product_id)
LEFT JOIN oc_product p ON (pf.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '1592' AND pf.filter_id IN (1175)

SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_product_to_category p2c
LEFT JOIN oc_product_filter pf ON (p2c.product_id = pf.product_id)
LEFT JOIN oc_product p ON (pf.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '1592' AND pf.filter_id IN (1205)

SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_product_to_category p2c
LEFT JOIN oc_product_filter pf ON (p2c.product_id = pf.product_id)
LEFT JOIN oc_product p ON (pf.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '1592' AND pf.filter_id IN (2021)

SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_product_to_category p2c
LEFT JOIN oc_product_filter pf ON (p2c.product_id = pf.product_id)
LEFT JOIN oc_product p ON (pf.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '1592' AND pf.filter_id IN (1220)

SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_product_to_category p2c
LEFT JOIN oc_product_filter pf ON (p2c.product_id = pf.product_id)
LEFT JOIN oc_product p ON (pf.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '1592' AND pf.filter_id IN (1209)

SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_product_to_category p2c
LEFT JOIN oc_product_filter pf ON (p2c.product_id = pf.product_id)
LEFT JOIN oc_product p ON (pf.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '1592' AND pf.filter_id IN (1910)

SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_product_to_category p2c
LEFT JOIN oc_product_filter pf ON (p2c.product_id = pf.product_id)
LEFT JOIN oc_product p ON (pf.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '1592' AND pf.filter_id IN (2036)

SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_product_to_category p2c
LEFT JOIN oc_product_filter pf ON (p2c.product_id = pf.product_id)
LEFT JOIN oc_product p ON (pf.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '1592' AND pf.filter_id IN (1900)

SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_product_to_category p2c
LEFT JOIN oc_product_filter pf ON (p2c.product_id = pf.product_id)
LEFT JOIN oc_product p ON (pf.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '1592' AND pf.filter_id IN (2094)

SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_product_to_category p2c
LEFT JOIN oc_product_filter pf ON (p2c.product_id = pf.product_id)
LEFT JOIN oc_product p ON (pf.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '1592' AND pf.filter_id IN (1961)

SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_product_to_category p2c
LEFT JOIN oc_product_filter pf ON (p2c.product_id = pf.product_id)
LEFT JOIN oc_product p ON (pf.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '1592' AND pf.filter_id IN (2081)

SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_product_to_category p2c
LEFT JOIN oc_product_filter pf ON (p2c.product_id = pf.product_id)
LEFT JOIN oc_product p ON (pf.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '1592' AND pf.filter_id IN (1933)

SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_product_to_category p2c
LEFT JOIN oc_product_filter pf ON (p2c.product_id = pf.product_id)
LEFT JOIN oc_product p ON (pf.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '1592' AND pf.filter_id IN (1932)

SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_product_to_category p2c
LEFT JOIN oc_product_filter pf ON (p2c.product_id = pf.product_id)
LEFT JOIN oc_product p ON (pf.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '1592' AND pf.filter_id IN (2079)

SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_product_to_category p2c
LEFT JOIN oc_product_filter pf ON (p2c.product_id = pf.product_id)
LEFT JOIN oc_product p ON (pf.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '1592' AND pf.filter_id IN (2080)

SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_product_to_category p2c
LEFT JOIN oc_product_filter pf ON (p2c.product_id = pf.product_id)
LEFT JOIN oc_product p ON (pf.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '1592' AND pf.filter_id IN (1198)

SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_product_to_category p2c
LEFT JOIN oc_product_filter pf ON (p2c.product_id = pf.product_id)
LEFT JOIN oc_product p ON (pf.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '1592' AND pf.filter_id IN (1958)

SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_product_to_category p2c
LEFT JOIN oc_product_filter pf ON (p2c.product_id = pf.product_id)
LEFT JOIN oc_product p ON (pf.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '1592' AND pf.filter_id IN (1975)

SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_product_to_category p2c
LEFT JOIN oc_product_filter pf ON (p2c.product_id = pf.product_id)
LEFT JOIN oc_product p ON (pf.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '1592' AND pf.filter_id IN (1959)

SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_product_to_category p2c
LEFT JOIN oc_product_filter pf ON (p2c.product_id = pf.product_id)
LEFT JOIN oc_product p ON (pf.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '1592' AND pf.filter_id IN (2020)

SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_product_to_category p2c
LEFT JOIN oc_product_filter pf ON (p2c.product_id = pf.product_id)
LEFT JOIN oc_product p ON (pf.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '1592' AND pf.filter_id IN (1161)

SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_product_to_category p2c
LEFT JOIN oc_product_filter pf ON (p2c.product_id = pf.product_id)
LEFT JOIN oc_product p ON (pf.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '1592' AND pf.filter_id IN (1954)

SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_product_to_category p2c
LEFT JOIN oc_product_filter pf ON (p2c.product_id = pf.product_id)
LEFT JOIN oc_product p ON (pf.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '1592' AND pf.filter_id IN (1944)

SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_product_to_category p2c
LEFT JOIN oc_product_filter pf ON (p2c.product_id = pf.product_id)
LEFT JOIN oc_product p ON (pf.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '1592' AND pf.filter_id IN (1200)

SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_product_to_category p2c
LEFT JOIN oc_product_filter pf ON (p2c.product_id = pf.product_id)
LEFT JOIN oc_product p ON (pf.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '1592' AND pf.filter_id IN (1923)

SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_product_to_category p2c
LEFT JOIN oc_product_filter pf ON (p2c.product_id = pf.product_id)
LEFT JOIN oc_product p ON (pf.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '1592' AND pf.filter_id IN (2065)

SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_product_to_category p2c
LEFT JOIN oc_product_filter pf ON (p2c.product_id = pf.product_id)
LEFT JOIN oc_product p ON (pf.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '1592' AND pf.filter_id IN (1889)

SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_product_to_category p2c
LEFT JOIN oc_product_filter pf ON (p2c.product_id = pf.product_id)
LEFT JOIN oc_product p ON (pf.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '1592' AND pf.filter_id IN (2003)

SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_product_to_category p2c
LEFT JOIN oc_product_filter pf ON (p2c.product_id = pf.product_id)
LEFT JOIN oc_product p ON (pf.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '1592' AND pf.filter_id IN (2067)

SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_product_to_category p2c
LEFT JOIN oc_product_filter pf ON (p2c.product_id = pf.product_id)
LEFT JOIN oc_product p ON (pf.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '1592' AND pf.filter_id IN (1895)

SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_product_to_category p2c
LEFT JOIN oc_product_filter pf ON (p2c.product_id = pf.product_id)
LEFT JOIN oc_product p ON (pf.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '1592' AND pf.filter_id IN (1930)

SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_product_to_category p2c
LEFT JOIN oc_product_filter pf ON (p2c.product_id = pf.product_id)
LEFT JOIN oc_product p ON (pf.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '1592' AND pf.filter_id IN (1211)

SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_product_to_category p2c
LEFT JOIN oc_product_filter pf ON (p2c.product_id = pf.product_id)
LEFT JOIN oc_product p ON (pf.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '1592' AND pf.filter_id IN (1938)

SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_product_to_category p2c
LEFT JOIN oc_product_filter pf ON (p2c.product_id = pf.product_id)
LEFT JOIN oc_product p ON (pf.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '1592' AND pf.filter_id IN (2048)

SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_product_to_category p2c
LEFT JOIN oc_product_filter pf ON (p2c.product_id = pf.product_id)
LEFT JOIN oc_product p ON (pf.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '1592' AND pf.filter_id IN (2064)

SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_product_to_category p2c
LEFT JOIN oc_product_filter pf ON (p2c.product_id = pf.product_id)
LEFT JOIN oc_product p ON (pf.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '1592' AND pf.filter_id IN (1968)

SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_product_to_category p2c
LEFT JOIN oc_product_filter pf ON (p2c.product_id = pf.product_id)
LEFT JOIN oc_product p ON (pf.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '1592' AND pf.filter_id IN (1924)

SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_product_to_category p2c
LEFT JOIN oc_product_filter pf ON (p2c.product_id = pf.product_id)
LEFT JOIN oc_product p ON (pf.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '1592' AND pf.filter_id IN (2047)