Perdea

SET time_zone = '+00:00'

DELETE
FROM `oc_session`
WHERE `expire` < '2021-12-05 08:02:42'

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` = '8fc07ae604da13b36476fcaeac' AND `expire` > '2021-12-05 08:02:42'

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

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

SET time_zone = '+02:00'

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 = '175' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '2688')
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 = '175' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '2688')
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 = '2'

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 = '2'

DELETE
FROM oc_cart
WHERE (api_id > '0' OR customer_id = '0') AND date_added < DATE_SUB(NOW(), INTERVAL 1 HOUR)

SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '8fc07ae604da13b36476fcaeac'

SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '8fc07ae604da13b36476fcaeac'

SELECT *
FROM oc_seo_url
WHERE keyword = 'Craciun-category_id=1222' AND language_id = 2 AND store_id = 0

SELECT *
FROM oc_seo_url
WHERE keyword = 'Craciun-category_id=1222' AND language_id = 2 AND store_id = 0

SELECT *
FROM oc_seo_url
WHERE keyword = 'Instalatii-de-Craciun-category_id=8' AND language_id = 2 AND store_id = 0

SELECT *
FROM oc_seo_url
WHERE keyword = 'Perdea-category_id=1312' AND language_id = 2 AND store_id = 0

SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '8fc07ae604da13b36476fcaeac'

SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '8fc07ae604da13b36476fcaeac'

SELECT *
FROM oc_seo_url
WHERE keyword = 'Craciun-category_id=1222' AND language_id = 2 AND store_id = 0

SELECT *
FROM oc_seo_url
WHERE keyword = 'Craciun-category_id=1222' AND language_id = 2 AND store_id = 0

SELECT *
FROM oc_seo_url
WHERE keyword = 'Instalatii-de-Craciun-category_id=8' AND language_id = 2 AND store_id = 0

SELECT *
FROM oc_seo_url
WHERE keyword = 'Perdea-category_id=1312' AND language_id = 2 AND store_id = 0

SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '8fc07ae604da13b36476fcaeac'

SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '8fc07ae604da13b36476fcaeac'

SELECT *
FROM oc_seo_url
WHERE keyword = 'Craciun-category_id=1222' AND language_id = 2 AND store_id = 0

SELECT *
FROM oc_seo_url
WHERE keyword = 'Craciun-category_id=1222' AND language_id = 2 AND store_id = 0

SELECT *
FROM oc_seo_url
WHERE keyword = 'Instalatii-de-Craciun-category_id=8' AND language_id = 2 AND store_id = 0

SELECT *
FROM oc_seo_url
WHERE keyword = 'Perdea-category_id=1312' AND language_id = 2 AND store_id = 0

SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '8fc07ae604da13b36476fcaeac'

SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '8fc07ae604da13b36476fcaeac'

SELECT *
FROM oc_seo_url
WHERE keyword = 'Craciun-category_id=1222' AND language_id = 2 AND store_id = 0

SELECT *
FROM oc_seo_url
WHERE keyword = 'Craciun-category_id=1222' AND language_id = 2 AND store_id = 0

SELECT *
FROM oc_seo_url
WHERE keyword = 'Instalatii-de-Craciun-category_id=8' AND language_id = 2 AND store_id = 0

SELECT *
FROM oc_seo_url
WHERE keyword = 'Perdea-category_id=1312' AND language_id = 2 AND store_id = 0

SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '8fc07ae604da13b36476fcaeac'

SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '8fc07ae604da13b36476fcaeac'

SELECT *
FROM oc_seo_url
WHERE keyword = 'Craciun-category_id=1222' AND language_id = 2 AND store_id = 0

SELECT *
FROM oc_seo_url
WHERE keyword = 'Craciun-category_id=1222' AND language_id = 2 AND store_id = 0

SELECT *
FROM oc_seo_url
WHERE keyword = 'Instalatii-de-Craciun-category_id=8' AND language_id = 2 AND store_id = 0

SELECT *
FROM oc_seo_url
WHERE keyword = 'Perdea-category_id=1312' AND language_id = 2 AND store_id = 0

SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '8fc07ae604da13b36476fcaeac'

SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '8fc07ae604da13b36476fcaeac'

SELECT *
FROM oc_seo_url
WHERE keyword = 'Craciun-category_id=1222' AND language_id = 2 AND store_id = 0

SELECT *
FROM oc_seo_url
WHERE keyword = 'Craciun-category_id=1222' AND language_id = 2 AND store_id = 0

SELECT *
FROM oc_seo_url
WHERE keyword = 'Instalatii-de-Craciun-category_id=8' AND language_id = 2 AND store_id = 0

SELECT *
FROM oc_seo_url
WHERE keyword = 'Perdea-category_id=1312' AND language_id = 2 AND store_id = 0

SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '8fc07ae604da13b36476fcaeac'

SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '8fc07ae604da13b36476fcaeac'

SELECT *
FROM oc_seo_url
WHERE keyword = 'Craciun-category_id=1222' AND language_id = 2 AND store_id = 0

SELECT *
FROM oc_seo_url
WHERE keyword = 'Craciun-category_id=1222' AND language_id = 2 AND store_id = 0

SELECT *
FROM oc_seo_url
WHERE keyword = 'Instalatii-de-Craciun-category_id=8' AND language_id = 2 AND store_id = 0

SELECT *
FROM oc_seo_url
WHERE keyword = 'Perdea-category_id=1312' AND language_id = 2 AND store_id = 0

SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '8fc07ae604da13b36476fcaeac'

SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '8fc07ae604da13b36476fcaeac'

SELECT *
FROM oc_seo_url
WHERE keyword = 'Craciun-category_id=1222' AND language_id = 2 AND store_id = 0

SELECT *
FROM oc_seo_url
WHERE keyword = 'Craciun-category_id=1222' AND language_id = 2 AND store_id = 0

SELECT *
FROM oc_seo_url
WHERE keyword = 'Instalatii-de-Craciun-category_id=8' AND language_id = 2 AND store_id = 0

SELECT *
FROM oc_seo_url
WHERE keyword = 'Perdea-category_id=1312' AND language_id = 2 AND store_id = 0

SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '8fc07ae604da13b36476fcaeac'

SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '8fc07ae604da13b36476fcaeac'

SELECT *
FROM oc_seo_url
WHERE keyword = 'Craciun-category_id=1222' AND language_id = 2 AND store_id = 0

SELECT *
FROM oc_seo_url
WHERE keyword = 'Craciun-category_id=1222' AND language_id = 2 AND store_id = 0

SELECT *
FROM oc_seo_url
WHERE keyword = 'Instalatii-de-Craciun-category_id=8' AND language_id = 2 AND store_id = 0

SELECT *
FROM oc_seo_url
WHERE keyword = 'Perdea-category_id=1312' AND language_id = 2 AND store_id = 0

SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '8fc07ae604da13b36476fcaeac'

SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '8fc07ae604da13b36476fcaeac'

SELECT *
FROM oc_seo_url
WHERE keyword = 'Craciun-category_id=1222' AND language_id = 2 AND store_id = 0

SELECT *
FROM oc_seo_url
WHERE keyword = 'Craciun-category_id=1222' AND language_id = 2 AND store_id = 0

SELECT *
FROM oc_seo_url
WHERE keyword = 'Instalatii-de-Craciun-category_id=8' AND language_id = 2 AND store_id = 0

SELECT *
FROM oc_seo_url
WHERE keyword = 'Perdea-category_id=1312' AND language_id = 2 AND store_id = 0

SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '8fc07ae604da13b36476fcaeac'

SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '8fc07ae604da13b36476fcaeac'

SELECT *
FROM oc_seo_url
WHERE keyword = 'Craciun-category_id=1222' AND language_id = 2 AND store_id = 0

SELECT *
FROM oc_seo_url
WHERE keyword = 'Craciun-category_id=1222' AND language_id = 2 AND store_id = 0

SELECT *
FROM oc_seo_url
WHERE keyword = 'Instalatii-de-Craciun-category_id=8' AND language_id = 2 AND store_id = 0

SELECT *
FROM oc_seo_url
WHERE keyword = 'Perdea-category_id=1312' AND language_id = 2 AND store_id = 0

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

SELECT *
FROM oc_seo_url
WHERE keyword = 'Craciun-category_id=1222' AND store_id = '0'

SELECT *
FROM oc_seo_url
WHERE keyword = 'Instalatii-de-Craciun-category_id=8' AND store_id = '0'

SELECT *
FROM oc_seo_url
WHERE keyword = 'Perdea-category_id=1312' AND store_id = '0'

SELECT count(*) AS total
FROM `oc_journal3_skin`

SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '8fc07ae604da13b36476fcaeac'

SELECT *
FROM `oc_journal3_variable`

SELECT *
FROM `oc_journal3_style`

SELECT setting_name, setting_value, serialized
FROM `oc_journal3_setting`
WHERE `store_id` = '0' OR `store_id` = '0'
ORDER BY store_id ASC

SELECT setting_name, setting_value, serialized
FROM `oc_journal3_skin_setting`
WHERE `skin_id` = '1'

SELECT *
FROM oc_category_to_layout
WHERE category_id = '1312' 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 layout_id, layout_data
FROM `oc_journal3_layout`
WHERE `layout_id` = '3' OR `layout_id` = -1
ORDER BY `layout_id` DESC

SELECT *
FROM `oc_journal3_module`
WHERE `module_id` = '240'

SELECT *
FROM `oc_journal3_module`
WHERE `module_id` = '255'

SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/css'

SELECT *
FROM `oc_journal3_module`
WHERE `module_type` = 'product_label'

SELECT p.product_id, ( SELECT AVG(rating) total
FROM `oc_review` r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id ) rating, ( 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 ) 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 ) special, p.viewed
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)
WHERE p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND pd.language_id = '2' GROUP BY p.product_id
ORDER BY p.date_added DESC, LCASE(pd.name) DESC LIMIT 0, 50

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' LIMIT 1) AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') 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 = '2') 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 = '2') 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 IN (115399,115398,115397,115396,115395,115394,115393,115392,115391,115390,115389,115388,115387,115386,115385,115384,115383,115382,115381,115380,115379,115378,115377,115376,115375,115374,115373,115372,115371,115370,115369,115368,115367,115366,115365,115364,115363,115362,115361,115360,115359,115358,115355,115356,115357,115354,115353,115352,115351,115349) AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

SELECT p.product_id, ( SELECT AVG(rating) total
FROM `oc_review` r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id ) rating, ( 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 ) 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 ) special, p.viewed , SUM(op.quantity) AS sales
FROM `oc_order_product` op
LEFT JOIN `oc_order` o ON (o.order_id = op.order_id)
LEFT JOIN `oc_product` p ON (p.product_id = op.product_id)
LEFT JOIN `oc_product_description` pd ON (p.product_id = pd.product_id)
LEFT JOIN `oc_product_to_store` p2s ON (p.product_id = p2s.product_id)
WHERE p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND pd.language_id = '2' AND o.order_status_id > '0' GROUP BY p.product_id
ORDER BY sales DESC, LCASE(pd.name) DESC LIMIT 0, 99

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' LIMIT 1) AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') 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 = '2') 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 = '2') 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 IN (73752,71387,83153,102695,81917,111788,109447,102693,102694,53241,102696,89163,89162,70527,100900,103702,103076,103082,102801,103123,103122,103125,107927,104189,102996,102995,103078,3133,102573,103121,104190,103364,100320,107708,102816,102596,103244,103035,103792,103241,103793,107709,95157,102700,107711,102567,107713,103218,103693,108075,102813,103367,102806,103340,102798,95643,94770,102973,102391,102389,103365,104196,102079,103344,105557,103345,100321,94773,94965,103155,108106,108107,102682,108017,102924,103341,103696,105558,102971,103126,102978,100318,103067,94783,102984,103347,102597,94781,103346,102972,103343,103040,107707,110144,110143,103366,103065,103348,104071) AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

SELECT p.product_id, ( SELECT AVG(rating) total
FROM `oc_review` r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id ) rating, ( 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 ) 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 ) special, p.viewed
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)
WHERE p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND pd.language_id = '2' AND COALESCE( ( 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 ) , ( 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 ) , p.price) <= 0 GROUP BY p.product_id
ORDER BY p.sort_order ASC, LCASE(pd.name) ASC LIMIT 0, 999

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' LIMIT 1) AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') 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 = '2') 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 = '2') 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 IN (104019,107859,52815,3518,92345,80494,38127,53912,53909,53910,53911,53913,3237,3210,3209,3238,3244,3245,3246,3560,3243,3217,3213,3216,3214,3211,3212,3215,3524,3218,3242,53443,94022,73490,5636,4078,4077,4076,4122,4135,4153,4094,4095,4158,4161,4093,4097,4096,4143,4149,4146,4056,4067,4057,4063,4064,4062,4060,4061,4059,4054,4065,4058,4055,4156,4152,4120,4118,4116,4163,4162,4066,4068,4110,4111,4112,4113,4114,4119,4133,4159,4154,4121,4117,4115,4103,4160,4102,4106,4108,4109,4105,4107,4157,4134,4104,4155,4132,4101,4124,4123,4125,4083,4088,4089,4090,4075,4087,4082,4127,4084,4128,4079,4080,4129,4126,4086,4085,4081,4074,4072,4073,4091,4098,4099,4100,4131,4092,4130,4136,4147,4141,4144,4150,4151,4139,4145,4142,4137,4140,4148,4070,4071,4069,4138,70457,72101) AND pd.language_id = '2' 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 = '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' LIMIT 1) AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') 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 = '2') 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 = '2') 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 IN (42,257) AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

SELECT *
FROM `oc_journal3_module`
WHERE `module_type` = 'product_exclude_button'

SELECT *
FROM `oc_journal3_module`
WHERE `module_type` = 'product_extra_button'

SELECT *
FROM `oc_journal3_module`
WHERE `module_type` = 'product_blocks'

SELECT *
FROM `oc_journal3_module`
WHERE `module_type` = 'product_tabs'

SELECT product_id, image
FROM oc_product_image
WHERE sort_order = ( SELECT MIN(sort_order)
FROM oc_product_image AS p
WHERE p.product_id = oc_product_image.product_id )

SELECT *
FROM oc_product_special ps
WHERE ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND ps.date_end != '0000-00-00' AND ps.date_end > NOW()) GROUP BY ps.product_id
ORDER BY ps.priority ASC, ps.price ASC

SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'product/category' OR route = 'ro-ro')

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 = '1222' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'

SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=1222' AND store_id = '0' AND language_id = '2'

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 = '8' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'

SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=1222' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=8' AND store_id = '0' AND language_id = '2'

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 = '1312' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'

SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=1222' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=8' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=1312' AND store_id = '0' AND language_id = '2'

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 = '1312' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT COUNT(DISTINCT p.product_id) total
FROM `oc_product` p
LEFT JOIN `oc_product_to_category` p2c ON (p2c.product_id = p.product_id)
LEFT JOIN `oc_product_description` pd ON (p.product_id = pd.product_id)
LEFT JOIN `oc_product_to_store` p2s ON (p.product_id = p2s.product_id)
WHERE p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND pd.language_id = '2' AND p2c.category_id = '1312' AND p.quantity > 0

SELECT p.product_id, ( SELECT AVG(rating) total
FROM `oc_review` r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id ) rating, ( 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 ) 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 ) special, p.viewed
FROM `oc_product` p
LEFT JOIN `oc_product_to_category` p2c ON (p2c.product_id = p.product_id)
LEFT JOIN `oc_product_description` pd ON (p.product_id = pd.product_id)
LEFT JOIN `oc_product_to_store` p2s ON (p.product_id = p2s.product_id)
WHERE p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND pd.language_id = '2' AND p2c.category_id = '1312' AND p.quantity > 0 GROUP BY p.product_id
ORDER BY p.sort_order ASC, LCASE(pd.name) ASC LIMIT 0, 32

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' LIMIT 1) AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') 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 = '2') 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 = '2') 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 IN (110027,110000,110081,110054,110119,110108,110141,110130,110028,110001,110082,110055,110120,110109,110142,110131,110029,110002,110083,110056,110030,110003,110084,110057,110031,110004,110085,110058,110032,110005,110086,110059) AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

SELECT *
FROM oc_extension
WHERE `type` = 'ka_extensions' AND code = 'wholesale_display'

SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'extension/ka_extensions/wholesale_display/common' OR route = 'ro-ro')

SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'extension/ka_extensions/wholesale_display/common' OR route = 'ro-ro')

SELECT p.tax_class_id, pd.price, pd.quantity
FROM oc_product_discount pd
INNER JOIN oc_product p ON pd.product_id = p.product_id
WHERE pd.product_id = '110027' AND pd.customer_group_id = '1' AND ( (pd.date_start = '0000-00-00' OR pd.date_start < NOW()) AND (pd.date_end = '0000-00-00' OR pd.date_end > NOW()) )
ORDER BY pd.quantity ASC, pd.priority ASC

SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=1222' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=8' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=1312' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=110027' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'extension/ka_extensions/wholesale_display/common' OR route = 'ro-ro')

SELECT p.tax_class_id, pd.price, pd.quantity
FROM oc_product_discount pd
INNER JOIN oc_product p ON pd.product_id = p.product_id
WHERE pd.product_id = '110000' AND pd.customer_group_id = '1' AND ( (pd.date_start = '0000-00-00' OR pd.date_start < NOW()) AND (pd.date_end = '0000-00-00' OR pd.date_end > NOW()) )
ORDER BY pd.quantity ASC, pd.priority ASC

SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=1222' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=8' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=1312' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=110000' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'extension/ka_extensions/wholesale_display/common' OR route = 'ro-ro')

SELECT p.tax_class_id, pd.price, pd.quantity
FROM oc_product_discount pd
INNER JOIN oc_product p ON pd.product_id = p.product_id
WHERE pd.product_id = '110081' AND pd.customer_group_id = '1' AND ( (pd.date_start = '0000-00-00' OR pd.date_start < NOW()) AND (pd.date_end = '0000-00-00' OR pd.date_end > NOW()) )
ORDER BY pd.quantity ASC, pd.priority ASC

SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=1222' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=8' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=1312' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=110081' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'extension/ka_extensions/wholesale_display/common' OR route = 'ro-ro')

SELECT p.tax_class_id, pd.price, pd.quantity
FROM oc_product_discount pd
INNER JOIN oc_product p ON pd.product_id = p.product_id
WHERE pd.product_id = '110054' AND pd.customer_group_id = '1' AND ( (pd.date_start = '0000-00-00' OR pd.date_start < NOW()) AND (pd.date_end = '0000-00-00' OR pd.date_end > NOW()) )
ORDER BY pd.quantity ASC, pd.priority ASC

SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=1222' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=8' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=1312' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=110054' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'extension/ka_extensions/wholesale_display/common' OR route = 'ro-ro')

SELECT p.tax_class_id, pd.price, pd.quantity
FROM oc_product_discount pd
INNER JOIN oc_product p ON pd.product_id = p.product_id
WHERE pd.product_id = '110119' AND pd.customer_group_id = '1' AND ( (pd.date_start = '0000-00-00' OR pd.date_start < NOW()) AND (pd.date_end = '0000-00-00' OR pd.date_end > NOW()) )
ORDER BY pd.quantity ASC, pd.priority ASC

SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=1222' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=8' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=1312' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=110119' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'extension/ka_extensions/wholesale_display/common' OR route = 'ro-ro')

SELECT p.tax_class_id, pd.price, pd.quantity
FROM oc_product_discount pd
INNER JOIN oc_product p ON pd.product_id = p.product_id
WHERE pd.product_id = '110108' AND pd.customer_group_id = '1' AND ( (pd.date_start = '0000-00-00' OR pd.date_start < NOW()) AND (pd.date_end = '0000-00-00' OR pd.date_end > NOW()) )
ORDER BY pd.quantity ASC, pd.priority ASC

SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=1222' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=8' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=1312' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=110108' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'extension/ka_extensions/wholesale_display/common' OR route = 'ro-ro')

SELECT p.tax_class_id, pd.price, pd.quantity
FROM oc_product_discount pd
INNER JOIN oc_product p ON pd.product_id = p.product_id
WHERE pd.product_id = '110141' AND pd.customer_group_id = '1' AND ( (pd.date_start = '0000-00-00' OR pd.date_start < NOW()) AND (pd.date_end = '0000-00-00' OR pd.date_end > NOW()) )
ORDER BY pd.quantity ASC, pd.priority ASC

SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=1222' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=8' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=1312' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=110141' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'extension/ka_extensions/wholesale_display/common' OR route = 'ro-ro')

SELECT p.tax_class_id, pd.price, pd.quantity
FROM oc_product_discount pd
INNER JOIN oc_product p ON pd.product_id = p.product_id
WHERE pd.product_id = '110130' AND pd.customer_group_id = '1' AND ( (pd.date_start = '0000-00-00' OR pd.date_start < NOW()) AND (pd.date_end = '0000-00-00' OR pd.date_end > NOW()) )
ORDER BY pd.quantity ASC, pd.priority ASC

SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=1222' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=8' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=1312' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=110130' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'extension/ka_extensions/wholesale_display/common' OR route = 'ro-ro')

SELECT p.tax_class_id, pd.price, pd.quantity
FROM oc_product_discount pd
INNER JOIN oc_product p ON pd.product_id = p.product_id
WHERE pd.product_id = '110028' AND pd.customer_group_id = '1' AND ( (pd.date_start = '0000-00-00' OR pd.date_start < NOW()) AND (pd.date_end = '0000-00-00' OR pd.date_end > NOW()) )
ORDER BY pd.quantity ASC, pd.priority ASC

SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=1222' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=8' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=1312' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=110028' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'extension/ka_extensions/wholesale_display/common' OR route = 'ro-ro')

SELECT p.tax_class_id, pd.price, pd.quantity
FROM oc_product_discount pd
INNER JOIN oc_product p ON pd.product_id = p.product_id
WHERE pd.product_id = '110001' AND pd.customer_group_id = '1' AND ( (pd.date_start = '0000-00-00' OR pd.date_start < NOW()) AND (pd.date_end = '0000-00-00' OR pd.date_end > NOW()) )
ORDER BY pd.quantity ASC, pd.priority ASC

SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=1222' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=8' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=1312' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=110001' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'extension/ka_extensions/wholesale_display/common' OR route = 'ro-ro')

SELECT p.tax_class_id, pd.price, pd.quantity
FROM oc_product_discount pd
INNER JOIN oc_product p ON pd.product_id = p.product_id
WHERE pd.product_id = '110082' AND pd.customer_group_id = '1' AND ( (pd.date_start = '0000-00-00' OR pd.date_start < NOW()) AND (pd.date_end = '0000-00-00' OR pd.date_end > NOW()) )
ORDER BY pd.quantity ASC, pd.priority ASC

SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=1222' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=8' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=1312' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=110082' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'extension/ka_extensions/wholesale_display/common' OR route = 'ro-ro')

SELECT p.tax_class_id, pd.price, pd.quantity
FROM oc_product_discount pd
INNER JOIN oc_product p ON pd.product_id = p.product_id
WHERE pd.product_id = '110055' AND pd.customer_group_id = '1' AND ( (pd.date_start = '0000-00-00' OR pd.date_start < NOW()) AND (pd.date_end = '0000-00-00' OR pd.date_end > NOW()) )
ORDER BY pd.quantity ASC, pd.priority ASC

SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=1222' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=8' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=1312' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=110055' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'extension/ka_extensions/wholesale_display/common' OR route = 'ro-ro')

SELECT p.tax_class_id, pd.price, pd.quantity
FROM oc_product_discount pd
INNER JOIN oc_product p ON pd.product_id = p.product_id
WHERE pd.product_id = '110120' AND pd.customer_group_id = '1' AND ( (pd.date_start = '0000-00-00' OR pd.date_start < NOW()) AND (pd.date_end = '0000-00-00' OR pd.date_end > NOW()) )
ORDER BY pd.quantity ASC, pd.priority ASC

SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=1222' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=8' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=1312' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=110120' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'extension/ka_extensions/wholesale_display/common' OR route = 'ro-ro')

SELECT p.tax_class_id, pd.price, pd.quantity
FROM oc_product_discount pd
INNER JOIN oc_product p ON pd.product_id = p.product_id
WHERE pd.product_id = '110109' AND pd.customer_group_id = '1' AND ( (pd.date_start = '0000-00-00' OR pd.date_start < NOW()) AND (pd.date_end = '0000-00-00' OR pd.date_end > NOW()) )
ORDER BY pd.quantity ASC, pd.priority ASC

SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=1222' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=8' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=1312' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=110109' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'extension/ka_extensions/wholesale_display/common' OR route = 'ro-ro')

SELECT p.tax_class_id, pd.price, pd.quantity
FROM oc_product_discount pd
INNER JOIN oc_product p ON pd.product_id = p.product_id
WHERE pd.product_id = '110142' AND pd.customer_group_id = '1' AND ( (pd.date_start = '0000-00-00' OR pd.date_start < NOW()) AND (pd.date_end = '0000-00-00' OR pd.date_end > NOW()) )
ORDER BY pd.quantity ASC, pd.priority ASC

SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=1222' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=8' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=1312' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=110142' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'extension/ka_extensions/wholesale_display/common' OR route = 'ro-ro')

SELECT p.tax_class_id, pd.price, pd.quantity
FROM oc_product_discount pd
INNER JOIN oc_product p ON pd.product_id = p.product_id
WHERE pd.product_id = '110131' AND pd.customer_group_id = '1' AND ( (pd.date_start = '0000-00-00' OR pd.date_start < NOW()) AND (pd.date_end = '0000-00-00' OR pd.date_end > NOW()) )
ORDER BY pd.quantity ASC, pd.priority ASC

SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=1222' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=8' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=1312' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=110131' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'extension/ka_extensions/wholesale_display/common' OR route = 'ro-ro')

SELECT p.tax_class_id, pd.price, pd.quantity
FROM oc_product_discount pd
INNER JOIN oc_product p ON pd.product_id = p.product_id
WHERE pd.product_id = '110029' AND pd.customer_group_id = '1' AND ( (pd.date_start = '0000-00-00' OR pd.date_start < NOW()) AND (pd.date_end = '0000-00-00' OR pd.date_end > NOW()) )
ORDER BY pd.quantity ASC, pd.priority ASC

SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=1222' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=8' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=1312' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=110029' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'extension/ka_extensions/wholesale_display/common' OR route = 'ro-ro')

SELECT p.tax_class_id, pd.price, pd.quantity
FROM oc_product_discount pd
INNER JOIN oc_product p ON pd.product_id = p.product_id
WHERE pd.product_id = '110002' AND pd.customer_group_id = '1' AND ( (pd.date_start = '0000-00-00' OR pd.date_start < NOW()) AND (pd.date_end = '0000-00-00' OR pd.date_end > NOW()) )
ORDER BY pd.quantity ASC, pd.priority ASC

SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=1222' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=8' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=1312' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=110002' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'extension/ka_extensions/wholesale_display/common' OR route = 'ro-ro')

SELECT p.tax_class_id, pd.price, pd.quantity
FROM oc_product_discount pd
INNER JOIN oc_product p ON pd.product_id = p.product_id
WHERE pd.product_id = '110083' AND pd.customer_group_id = '1' AND ( (pd.date_start = '0000-00-00' OR pd.date_start < NOW()) AND (pd.date_end = '0000-00-00' OR pd.date_end > NOW()) )
ORDER BY pd.quantity ASC, pd.priority ASC

SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=1222' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=8' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=1312' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=110083' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'extension/ka_extensions/wholesale_display/common' OR route = 'ro-ro')

SELECT p.tax_class_id, pd.price, pd.quantity
FROM oc_product_discount pd
INNER JOIN oc_product p ON pd.product_id = p.product_id
WHERE pd.product_id = '110056' AND pd.customer_group_id = '1' AND ( (pd.date_start = '0000-00-00' OR pd.date_start < NOW()) AND (pd.date_end = '0000-00-00' OR pd.date_end > NOW()) )
ORDER BY pd.quantity ASC, pd.priority ASC

SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=1222' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=8' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=1312' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=110056' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'extension/ka_extensions/wholesale_display/common' OR route = 'ro-ro')

SELECT p.tax_class_id, pd.price, pd.quantity
FROM oc_product_discount pd
INNER JOIN oc_product p ON pd.product_id = p.product_id
WHERE pd.product_id = '110030' AND pd.customer_group_id = '1' AND ( (pd.date_start = '0000-00-00' OR pd.date_start < NOW()) AND (pd.date_end = '0000-00-00' OR pd.date_end > NOW()) )
ORDER BY pd.quantity ASC, pd.priority ASC

SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=1222' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=8' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=1312' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=110030' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'extension/ka_extensions/wholesale_display/common' OR route = 'ro-ro')

SELECT p.tax_class_id, pd.price, pd.quantity
FROM oc_product_discount pd
INNER JOIN oc_product p ON pd.product_id = p.product_id
WHERE pd.product_id = '110003' AND pd.customer_group_id = '1' AND ( (pd.date_start = '0000-00-00' OR pd.date_start < NOW()) AND (pd.date_end = '0000-00-00' OR pd.date_end > NOW()) )
ORDER BY pd.quantity ASC, pd.priority ASC

SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=1222' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=8' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=1312' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=110003' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'extension/ka_extensions/wholesale_display/common' OR route = 'ro-ro')

SELECT p.tax_class_id, pd.price, pd.quantity
FROM oc_product_discount pd
INNER JOIN oc_product p ON pd.product_id = p.product_id
WHERE pd.product_id = '110084' AND pd.customer_group_id = '1' AND ( (pd.date_start = '0000-00-00' OR pd.date_start < NOW()) AND (pd.date_end = '0000-00-00' OR pd.date_end > NOW()) )
ORDER BY pd.quantity ASC, pd.priority ASC

SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=1222' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=8' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=1312' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=110084' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'extension/ka_extensions/wholesale_display/common' OR route = 'ro-ro')

SELECT p.tax_class_id, pd.price, pd.quantity
FROM oc_product_discount pd
INNER JOIN oc_product p ON pd.product_id = p.product_id
WHERE pd.product_id = '110057' AND pd.customer_group_id = '1' AND ( (pd.date_start = '0000-00-00' OR pd.date_start < NOW()) AND (pd.date_end = '0000-00-00' OR pd.date_end > NOW()) )
ORDER BY pd.quantity ASC, pd.priority ASC

SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=1222' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=8' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=1312' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=110057' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'extension/ka_extensions/wholesale_display/common' OR route = 'ro-ro')

SELECT p.tax_class_id, pd.price, pd.quantity
FROM oc_product_discount pd
INNER JOIN oc_product p ON pd.product_id = p.product_id
WHERE pd.product_id = '110031' AND pd.customer_group_id = '1' AND ( (pd.date_start = '0000-00-00' OR pd.date_start < NOW()) AND (pd.date_end = '0000-00-00' OR pd.date_end > NOW()) )
ORDER BY pd.quantity ASC, pd.priority ASC

SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=1222' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=8' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=1312' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=110031' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'extension/ka_extensions/wholesale_display/common' OR route = 'ro-ro')

SELECT p.tax_class_id, pd.price, pd.quantity
FROM oc_product_discount pd
INNER JOIN oc_product p ON pd.product_id = p.product_id
WHERE pd.product_id = '110004' AND pd.customer_group_id = '1' AND ( (pd.date_start = '0000-00-00' OR pd.date_start < NOW()) AND (pd.date_end = '0000-00-00' OR pd.date_end > NOW()) )
ORDER BY pd.quantity ASC, pd.priority ASC

SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=1222' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=8' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=1312' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=110004' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'extension/ka_extensions/wholesale_display/common' OR route = 'ro-ro')

SELECT p.tax_class_id, pd.price, pd.quantity
FROM oc_product_discount pd
INNER JOIN oc_product p ON pd.product_id = p.product_id
WHERE pd.product_id = '110085' AND pd.customer_group_id = '1' AND ( (pd.date_start = '0000-00-00' OR pd.date_start < NOW()) AND (pd.date_end = '0000-00-00' OR pd.date_end > NOW()) )
ORDER BY pd.quantity ASC, pd.priority ASC

SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=1222' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=8' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=1312' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=110085' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'extension/ka_extensions/wholesale_display/common' OR route = 'ro-ro')

SELECT p.tax_class_id, pd.price, pd.quantity
FROM oc_product_discount pd
INNER JOIN oc_product p ON pd.product_id = p.product_id
WHERE pd.product_id = '110058' AND pd.customer_group_id = '1' AND ( (pd.date_start = '0000-00-00' OR pd.date_start < NOW()) AND (pd.date_end = '0000-00-00' OR pd.date_end > NOW()) )
ORDER BY pd.quantity ASC, pd.priority ASC

SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=1222' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=8' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=1312' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=110058' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'extension/ka_extensions/wholesale_display/common' OR route = 'ro-ro')

SELECT p.tax_class_id, pd.price, pd.quantity
FROM oc_product_discount pd
INNER JOIN oc_product p ON pd.product_id = p.product_id
WHERE pd.product_id = '110032' AND pd.customer_group_id = '1' AND ( (pd.date_start = '0000-00-00' OR pd.date_start < NOW()) AND (pd.date_end = '0000-00-00' OR pd.date_end > NOW()) )
ORDER BY pd.quantity ASC, pd.priority ASC

SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=1222' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=8' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=1312' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=110032' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'extension/ka_extensions/wholesale_display/common' OR route = 'ro-ro')

SELECT p.tax_class_id, pd.price, pd.quantity
FROM oc_product_discount pd
INNER JOIN oc_product p ON pd.product_id = p.product_id
WHERE pd.product_id = '110005' AND pd.customer_group_id = '1' AND ( (pd.date_start = '0000-00-00' OR pd.date_start < NOW()) AND (pd.date_end = '0000-00-00' OR pd.date_end > NOW()) )
ORDER BY pd.quantity ASC, pd.priority ASC

SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=1222' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=8' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=1312' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=110005' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'extension/ka_extensions/wholesale_display/common' OR route = 'ro-ro')

SELECT p.tax_class_id, pd.price, pd.quantity
FROM oc_product_discount pd
INNER JOIN oc_product p ON pd.product_id = p.product_id
WHERE pd.product_id = '110086' AND pd.customer_group_id = '1' AND ( (pd.date_start = '0000-00-00' OR pd.date_start < NOW()) AND (pd.date_end = '0000-00-00' OR pd.date_end > NOW()) )
ORDER BY pd.quantity ASC, pd.priority ASC

SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=1222' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=8' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=1312' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=110086' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'extension/ka_extensions/wholesale_display/common' OR route = 'ro-ro')

SELECT p.tax_class_id, pd.price, pd.quantity
FROM oc_product_discount pd
INNER JOIN oc_product p ON pd.product_id = p.product_id
WHERE pd.product_id = '110059' AND pd.customer_group_id = '1' AND ( (pd.date_start = '0000-00-00' OR pd.date_start < NOW()) AND (pd.date_end = '0000-00-00' OR pd.date_end > NOW()) )
ORDER BY pd.quantity ASC, pd.priority ASC

SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=1222' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=8' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=1312' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=110059' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=1222' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=8' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=1312' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=1222' AND store_id = '0' AND language_id = '2'

SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=8' AND store_id = '0' AND language_id = '2'