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

SELECT *
FROM ba_store
WHERE REPLACE(`ssl`, 'www.', '') = 'https://baribal.sk/'

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

SELECT *
FROM ba_currency

SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM ba_tax_rule tr1
LEFT JOIN ba_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN ba_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN ba_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN ba_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.based = 'shipping' AND tr2cg.customer_group_id = '3' AND z2gz.country_id = '189' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '2929')
ORDER BY tr1.priority ASC

SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM ba_tax_rule tr1
LEFT JOIN ba_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN ba_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN ba_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN ba_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.based = 'store' AND tr2cg.customer_group_id = '3' AND z2gz.country_id = '189' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '2929')
ORDER BY tr1.priority ASC

SELECT *
FROM ba_weight_class wc
LEFT JOIN ba_weight_class_description wcd ON (wc.weight_class_id = wcd.weight_class_id)
WHERE wcd.language_id = '2'

SELECT *
FROM ba_length_class mc
LEFT JOIN ba_length_class_description mcd ON (mc.length_class_id = mcd.length_class_id)
WHERE mcd.language_id = '2'

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

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

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

SELECT *
FROM ba_layout_route
WHERE 'common/home' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1

SELECT *
FROM ba_layout_module
WHERE layout_id = '1' AND position = 'column_left'
ORDER BY sort_order

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '61' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM ba_url_alias
WHERE `query` = 'category_id=72'

SELECT *
FROM ba_url_alias
WHERE `query` = 'category_id=329'

SELECT *
FROM ba_url_alias
WHERE `query` = 'category_id=395'

SELECT *
FROM ba_url_alias
WHERE `query` = 'category_id=396'

SELECT *
FROM ba_url_alias
WHERE `query` = 'category_id=352'

SELECT *
FROM ba_url_alias
WHERE `query` = 'category_id=192'

SELECT *
FROM ba_url_alias
WHERE `query` = 'category_id=185'

SELECT *
FROM ba_url_alias
WHERE `query` = 'category_id=189'

SELECT *
FROM ba_url_alias
WHERE `query` = 'category_id=187'

SELECT *
FROM ba_url_alias
WHERE `query` = 'category_id=190'

SELECT *
FROM ba_url_alias
WHERE `query` = 'category_id=191'

SELECT *
FROM ba_url_alias
WHERE `query` = 'category_id=308'

SELECT *
FROM ba_url_alias
WHERE `query` = 'category_id=81'

SELECT *
FROM ba_url_alias
WHERE `query` = 'category_id=89'

SELECT *
FROM ba_url_alias
WHERE `query` = 'category_id=74'

SELECT *
FROM ba_url_alias
WHERE `query` = 'category_id=80'

SELECT *
FROM ba_url_alias
WHERE `query` = 'category_id=85'

SELECT *
FROM ba_url_alias
WHERE `query` = 'category_id=76'

SELECT *
FROM ba_url_alias
WHERE `query` = 'category_id=86'

SELECT *
FROM ba_url_alias
WHERE `query` = 'category_id=79'

SELECT *
FROM ba_url_alias
WHERE `query` = 'category_id=78'

SELECT *
FROM ba_url_alias
WHERE `query` = 'category_id=73'

SELECT *
FROM ba_url_alias
WHERE `query` = 'category_id=75'

SELECT *
FROM ba_url_alias
WHERE `query` = 'category_id=82'

SELECT *
FROM ba_url_alias
WHERE `query` = 'category_id=88'

SELECT *
FROM ba_url_alias
WHERE `query` = 'category_id=90'

SELECT *
FROM ba_url_alias
WHERE `query` = 'category_id=87'

SELECT *
FROM ba_url_alias
WHERE `query` = 'category_id=223'

SELECT *
FROM ba_layout_route
WHERE 'common/home' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1

SELECT *
FROM ba_layout_module
WHERE layout_id = '1' AND position = 'column_right'
ORDER BY sort_order

SELECT *
FROM ba_module
WHERE module_id = '27'

SELECT *
FROM ba_banner b
LEFT JOIN ba_banner_image bi ON (b.banner_id = bi.banner_id)
WHERE b.banner_id = '9' AND b.status = '1' AND bi.language_id = '2'
ORDER BY bi.sort_order ASC

SELECT *
FROM ba_layout_route
WHERE 'common/home' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1

SELECT *
FROM ba_layout_module
WHERE layout_id = '1' AND position = 'content_top'
ORDER BY sort_order

SELECT *
FROM ba_module
WHERE module_id = '32'

SELECT DISTINCT ps.product_id, (SELECT AVG(rating)
FROM ba_review r1
WHERE r1.product_id = ps.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating
FROM ba_product_special ps
LEFT JOIN ba_product p ON (ps.product_id = p.product_id)
LEFT JOIN ba_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN ba_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 ps.customer_group_id = '3' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) GROUP BY ps.product_id
ORDER BY LCASE(pd.name) ASC, LCASE(pd.name) ASC LIMIT 0,15

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM ba_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '3' 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 ba_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '3' 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 ba_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '3') AS reward, (SELECT ss.name
FROM ba_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM ba_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 ba_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 ba_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 ba_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM ba_product p
LEFT JOIN ba_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN ba_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN ba_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '3361' 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 ba_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '3' 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 ba_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '3' 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 ba_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '3') AS reward, (SELECT ss.name
FROM ba_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM ba_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 ba_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 ba_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 ba_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM ba_product p
LEFT JOIN ba_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN ba_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN ba_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '2352' 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 ba_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '3' 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 ba_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '3' 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 ba_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '3') AS reward, (SELECT ss.name
FROM ba_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM ba_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 ba_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 ba_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 ba_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM ba_product p
LEFT JOIN ba_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN ba_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN ba_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '870' 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 ba_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '3' 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 ba_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '3' 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 ba_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '3') AS reward, (SELECT ss.name
FROM ba_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM ba_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 ba_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 ba_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 ba_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM ba_product p
LEFT JOIN ba_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN ba_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN ba_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '871' 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 ba_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '3' 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 ba_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '3' 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 ba_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '3') AS reward, (SELECT ss.name
FROM ba_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM ba_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 ba_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 ba_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 ba_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM ba_product p
LEFT JOIN ba_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN ba_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN ba_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '2353' 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 ba_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '3' 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 ba_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '3' 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 ba_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '3') AS reward, (SELECT ss.name
FROM ba_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM ba_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 ba_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 ba_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 ba_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM ba_product p
LEFT JOIN ba_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN ba_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN ba_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '3628' 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 ba_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '3' 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 ba_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '3' 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 ba_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '3') AS reward, (SELECT ss.name
FROM ba_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM ba_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 ba_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 ba_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 ba_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM ba_product p
LEFT JOIN ba_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN ba_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN ba_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '3629' 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 ba_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '3' 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 ba_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '3' 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 ba_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '3') AS reward, (SELECT ss.name
FROM ba_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM ba_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 ba_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 ba_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 ba_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM ba_product p
LEFT JOIN ba_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN ba_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN ba_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '2312' 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 ba_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '3' 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 ba_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '3' 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 ba_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '3') AS reward, (SELECT ss.name
FROM ba_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM ba_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 ba_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 ba_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 ba_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM ba_product p
LEFT JOIN ba_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN ba_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN ba_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '2326' 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 ba_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '3' 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 ba_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '3' 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 ba_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '3') AS reward, (SELECT ss.name
FROM ba_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM ba_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 ba_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 ba_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 ba_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM ba_product p
LEFT JOIN ba_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN ba_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN ba_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '3343' 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 ba_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '3' 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 ba_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '3' 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 ba_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '3') AS reward, (SELECT ss.name
FROM ba_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM ba_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 ba_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 ba_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 ba_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM ba_product p
LEFT JOIN ba_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN ba_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN ba_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '933' 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 ba_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '3' 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 ba_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '3' 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 ba_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '3') AS reward, (SELECT ss.name
FROM ba_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM ba_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 ba_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 ba_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 ba_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM ba_product p
LEFT JOIN ba_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN ba_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN ba_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '934' 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 ba_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '3' 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 ba_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '3' 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 ba_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '3') AS reward, (SELECT ss.name
FROM ba_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM ba_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 ba_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 ba_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 ba_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM ba_product p
LEFT JOIN ba_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN ba_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN ba_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '3362' 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 ba_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '3' 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 ba_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '3' 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 ba_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '3') AS reward, (SELECT ss.name
FROM ba_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM ba_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 ba_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 ba_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 ba_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM ba_product p
LEFT JOIN ba_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN ba_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN ba_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '2776' 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 ba_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '3' 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 ba_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '3' 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 ba_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '3') AS reward, (SELECT ss.name
FROM ba_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM ba_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 ba_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 ba_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 ba_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM ba_product p
LEFT JOIN ba_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN ba_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN ba_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1576' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

SELECT *
FROM ba_url_alias
WHERE `query` = 'product_id=3361'

SELECT *
FROM ba_url_alias
WHERE `query` = 'product_id=2352'

SELECT *
FROM ba_url_alias
WHERE `query` = 'product_id=870'

SELECT *
FROM ba_url_alias
WHERE `query` = 'product_id=871'

SELECT *
FROM ba_url_alias
WHERE `query` = 'product_id=2353'

SELECT *
FROM ba_url_alias
WHERE `query` = 'product_id=3628'

SELECT *
FROM ba_url_alias
WHERE `query` = 'product_id=3629'

SELECT *
FROM ba_url_alias
WHERE `query` = 'product_id=2312'

SELECT *
FROM ba_url_alias
WHERE `query` = 'product_id=2326'

SELECT *
FROM ba_url_alias
WHERE `query` = 'product_id=3343'

SELECT *
FROM ba_url_alias
WHERE `query` = 'product_id=933'

SELECT *
FROM ba_url_alias
WHERE `query` = 'product_id=934'

SELECT *
FROM ba_url_alias
WHERE `query` = 'product_id=3362'

SELECT *
FROM ba_url_alias
WHERE `query` = 'product_id=2776'

SELECT *
FROM ba_url_alias
WHERE `query` = 'product_id=1576'

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '0' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT keyword,SUBSTRING_INDEX(query, '=', -1) as cat_id
FROM ba_url_alias
WHERE query like 'cat%'

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '430' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '429' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '60' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '61' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '72' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '329' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '395' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '396' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '352' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '192' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '185' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '189' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '187' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '190' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '191' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '308' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '81' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '89' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '74' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '80' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '85' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '76' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '86' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '79' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '78' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '73' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '75' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '82' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '88' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '90' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '87' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '223' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '397' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '398' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '399' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '400' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '401' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '62' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '97' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '98' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '99' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '100' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '83' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '214' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '215' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '216' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '217' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '218' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '219' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '63' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '102' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '103' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '104' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '105' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '317' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '64' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '107' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '108' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '110' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '111' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '112' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '113' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '114' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '115' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '116' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '117' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '118' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '119' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '120' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '121' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '122' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '123' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '124' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '125' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '420' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '310' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '65' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '127' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '128' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '129' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '130' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '435' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '131' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '132' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '133' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '423' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '428' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '135' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '426' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '425' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '321' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '138' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '66' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '141' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '142' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '143' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '144' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '145' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '146' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '147' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '148' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '149' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '151' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '152' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '153' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '311' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '315' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '67' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '155' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '156' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '158' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '159' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '161' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '68' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '166' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '167' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '169' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '170' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '427' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '424' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '171' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '172' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '69' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '174' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '175' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '178' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '179' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '180' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '181' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM ba_layout_route
WHERE 'common/home' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1

SELECT *
FROM ba_layout_module
WHERE layout_id = '1' AND position = 'content_bottom'
ORDER BY sort_order

SELECT *
FROM ba_information i
LEFT JOIN ba_information_description id ON (i.information_id = id.information_id)
LEFT JOIN ba_information_to_store i2s ON (i.information_id = i2s.information_id)
WHERE id.language_id = '2' AND i2s.store_id = '0' AND i.status = '1'
ORDER BY i.sort_order, LCASE(id.title) ASC

SELECT *
FROM ba_url_alias
WHERE `query` = 'information_id=10'

SELECT *
FROM ba_url_alias
WHERE `query` = 'information_id=7'

SELECT *
FROM ba_url_alias
WHERE `query` = 'information_id=9'

SELECT *
FROM ba_url_alias
WHERE `query` = 'information_id=4'

SELECT *
FROM ba_url_alias
WHERE `query` = 'information_id=6'

SELECT *
FROM ba_url_alias
WHERE `query` = 'information_id=3'

SELECT *
FROM ba_url_alias
WHERE `query` = 'information_id=5'

DELETE
FROM `ba_customer_online`
WHERE date_added < '2017-09-20 04:37:22'

REPLACE INTO `ba_customer_online` SET `ip` = '54.156.47.142', `customer_id` = '0', `url` = 'http://www.baribal.sk/', `referer` = '', `date_added` = '2017-09-20 05:37:22'

SELECT *
FROM ba_extension
WHERE `type` = 'analytics'

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '0' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '92' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM ba_url_alias
WHERE `query` = 'category_id=92'

SELECT *
FROM ba_category c
LEFT JOIN ba_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN ba_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '95' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM ba_url_alias
WHERE `query` = 'category_id=95'

SELECT *
FROM ba_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '5i2ma7qag5qqf8oj6ui8glvrt5'

SELECT *
FROM ba_extension
WHERE `type` = 'total'

SELECT *
FROM ba_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '5i2ma7qag5qqf8oj6ui8glvrt5'

SELECT *
FROM ba_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '5i2ma7qag5qqf8oj6ui8glvrt5'

SELECT *
FROM ba_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '5i2ma7qag5qqf8oj6ui8glvrt5'

SELECT *
FROM ba_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '5i2ma7qag5qqf8oj6ui8glvrt5'