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

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

SELECT *
FROM `ba_setting`
WHERE store_id = '0' OR store_id = '1'
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 = 'store' AND tr2cg.customer_group_id = '2' AND z2gz.country_id = '56' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '899')
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 = '3'

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

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 = '1'
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 = '3' AND c2s.store_id = '1' 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=81'

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

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 = '1'
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 = '3'
ORDER BY bi.sort_order ASC

SELECT *
FROM ba_layout_route
WHERE 'common/home' LIKE route AND store_id = '1'
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 = '1' AND ps.customer_group_id = '2' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) GROUP BY ps.product_id
ORDER BY LCASE(pd.name) ASC, LCASE(pd.name) ASC LIMIT 0,15

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 = '3' AND c2s.store_id = '1' 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 = '3' AND c2s.store_id = '1' 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 = '3' AND c2s.store_id = '1' 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 = '3' AND c2s.store_id = '1' 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 = '3' AND c2s.store_id = '1' 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 = '3' AND c2s.store_id = '1' 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 = '3' AND c2s.store_id = '1' 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 = '3' AND c2s.store_id = '1' 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 = '3' AND c2s.store_id = '1' 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 = '3' AND c2s.store_id = '1' 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 = '3' AND c2s.store_id = '1' 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 = '3' AND c2s.store_id = '1' 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 = '3' AND c2s.store_id = '1' 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 = '3' AND c2s.store_id = '1' 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 = '3' AND c2s.store_id = '1' 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 = '3' AND c2s.store_id = '1' 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 = '3' AND c2s.store_id = '1' 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 = '3' AND c2s.store_id = '1' 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 = '3' AND c2s.store_id = '1' 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 = '3' AND c2s.store_id = '1' 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 = '3' AND c2s.store_id = '1' 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 = '3' AND c2s.store_id = '1' 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 = '3' AND c2s.store_id = '1' 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 = '3' AND c2s.store_id = '1' 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 = '3' AND c2s.store_id = '1' 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 = '3' AND c2s.store_id = '1' 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 = '3' AND c2s.store_id = '1' 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 = '3' AND c2s.store_id = '1' 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 = '3' AND c2s.store_id = '1' 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 = '3' AND c2s.store_id = '1' 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 = '3' AND c2s.store_id = '1' 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 = '3' AND c2s.store_id = '1' 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 = '3' AND c2s.store_id = '1' 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 = '3' AND c2s.store_id = '1' 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 = '3' AND c2s.store_id = '1' 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 = '3' AND c2s.store_id = '1' 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 = '3' AND c2s.store_id = '1' 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 = '3' AND c2s.store_id = '1' 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 = '3' AND c2s.store_id = '1' 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 = '3' AND c2s.store_id = '1' 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 = '3' AND c2s.store_id = '1' 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 = '3' AND c2s.store_id = '1' 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 = '3' AND c2s.store_id = '1' 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 = '3' AND c2s.store_id = '1' 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 = '3' AND c2s.store_id = '1' 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 = '3' AND c2s.store_id = '1' 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 = '3' AND c2s.store_id = '1' 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 = '3' AND c2s.store_id = '1' 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 = '3' AND c2s.store_id = '1' 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 = '3' AND c2s.store_id = '1' 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 = '3' AND c2s.store_id = '1' 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 = '3' AND c2s.store_id = '1' 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 = '3' AND c2s.store_id = '1' 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 = '3' AND c2s.store_id = '1' 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 = '3' AND c2s.store_id = '1' 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 = '3' AND c2s.store_id = '1' 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 = '3' AND c2s.store_id = '1' 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 = '3' AND c2s.store_id = '1' 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 = '3' AND c2s.store_id = '1' 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 = '3' AND c2s.store_id = '1' 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 = '3' AND c2s.store_id = '1' 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 = '3' AND c2s.store_id = '1' 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 = '3' AND c2s.store_id = '1' 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 = '3' AND c2s.store_id = '1' 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 = '3' AND c2s.store_id = '1' 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 = '3' AND c2s.store_id = '1' 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 = '3' AND c2s.store_id = '1' 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 = '3' AND c2s.store_id = '1' 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 = '3' AND c2s.store_id = '1' 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 = '3' AND c2s.store_id = '1' 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 = '3' AND c2s.store_id = '1' 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 = '3' AND c2s.store_id = '1' 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 = '3' AND c2s.store_id = '1' 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 = '3' AND c2s.store_id = '1' 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 = '3' AND c2s.store_id = '1' 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 = '3' AND c2s.store_id = '1' 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 = '3' AND c2s.store_id = '1' 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 = '3' AND c2s.store_id = '1' 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 = '3' AND c2s.store_id = '1' 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 = '3' AND c2s.store_id = '1' 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 = '3' AND c2s.store_id = '1' 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 = '3' AND c2s.store_id = '1' 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 = '3' AND c2s.store_id = '1' 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 = '3' AND c2s.store_id = '1' 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 = '3' AND c2s.store_id = '1' 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 = '3' AND c2s.store_id = '1' 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 = '3' AND c2s.store_id = '1' 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 = '3' AND c2s.store_id = '1' 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 = '3' AND c2s.store_id = '1' 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 = '3' AND c2s.store_id = '1' 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 = '3' AND c2s.store_id = '1' 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 = '3' AND c2s.store_id = '1' 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 = '3' AND c2s.store_id = '1' 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 = '3' AND c2s.store_id = '1' 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 = '3' AND c2s.store_id = '1' 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 = '3' AND c2s.store_id = '1' 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 = '3' AND c2s.store_id = '1' 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 = '3' AND c2s.store_id = '1' 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 = '3' AND c2s.store_id = '1' 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 = '3' AND c2s.store_id = '1' 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 = '3' AND c2s.store_id = '1' 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 = '3' AND c2s.store_id = '1' 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 = '3' AND c2s.store_id = '1' 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 = '3' AND c2s.store_id = '1' 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 = '3' AND c2s.store_id = '1' 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 = '3' AND c2s.store_id = '1' 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 = '3' AND c2s.store_id = '1' 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 = '3' AND c2s.store_id = '1' 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 = '3' AND c2s.store_id = '1' 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 = '3' AND c2s.store_id = '1' 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 = '3' AND c2s.store_id = '1' 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 = '3' AND c2s.store_id = '1' 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 = '3' AND c2s.store_id = '1' 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 = '3' AND c2s.store_id = '1' 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 = '3' AND c2s.store_id = '1' 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 = '3' AND c2s.store_id = '1' 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 = '3' AND c2s.store_id = '1' 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 = '3' AND c2s.store_id = '1' 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 = '3' AND c2s.store_id = '1' 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 = '3' AND c2s.store_id = '1' 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 = '3' AND c2s.store_id = '1' 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 = '3' AND c2s.store_id = '1' 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 = '3' AND c2s.store_id = '1' 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 = '3' AND c2s.store_id = '1' 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 = '3' AND c2s.store_id = '1' 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 = '3' AND c2s.store_id = '1' 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 = '3' AND c2s.store_id = '1' 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 = '3' AND c2s.store_id = '1' 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 = '3' AND c2s.store_id = '1' 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 = '1'
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 = '3' AND i2s.store_id = '1' 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=5'

DELETE
FROM `ba_customer_online`
WHERE date_added < '2017-07-28 09:45:40'

REPLACE INTO `ba_customer_online` SET `ip` = '23.20.193.33', `customer_id` = '0', `url` = 'http://www.baribalkids.cz/', `referer` = '', `date_added` = '2017-07-28 10:45:40'

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 = '3' AND c2s.store_id = '1' 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 = '3' AND c2s.store_id = '1' 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 = '3' AND c2s.store_id = '1' 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 = 'k4q6i217v0m2fv45po2kh51lk0'

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

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

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

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

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