Prelungitor Telescopic Carma Trem Aluminiu 70-125cm

SELECT data
FROM `oc_session`
WHERE session_id = '45f047c44d9e20e95be3ba3894'

SELECT *
FROM oc_url_alias
WHERE keyword = 'trem.html'

SELECT *
FROM oc_url_alias
WHERE keyword = 'prelungitor-telescopic-carma-trem-aluminiu-70-125cm.html'

SELECT *
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '862' AND m2s.store_id = '2'

SELECT DISTINCT *, p.product_id, pd.name AS name, p.image, m.name AS manufacturer, (SELECT p2sb.product_id
FROM oc_product_to_store p2sb
WHERE p2sb.product_id = p.product_id AND p2sb.store_id = '1') AS blackfriday, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(1) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN (SELECT os.product_id, os.magazin AS comenzi_magazin, os.online AS comenzi_online
FROM oc_order_stoc os GROUP BY os.product_id) opp ON (opp.product_id = p.product_id)
WHERE p.product_id = '272203' AND pd.language_id = '2' AND p.status = '1' AND p.price > '0' AND p2s.store_id = '2'

SELECT ag.attribute_group_id, agd.name
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '272203' AND agd.language_id = '2' AND ag.attribute_group_id NOT IN (54) GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name

SELECT a.attribute_id, a.arata, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '272203' AND a.attribute_group_id = '22' AND ad.language_id = '2' AND pa.language_id = '2'
ORDER BY a.sort_order, ad.name

SELECT *
FROM oc_product_image
WHERE product_id = '272203'
ORDER BY sort_order ASC

SELECT *
FROM `oc_module`
WHERE `code` = 'similar_products'
ORDER BY `name`

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

SELECT *
FROM `oc_product_locatie`
WHERE product_id = '272203' AND baza_date LIKE 'magazin_ffb'
ORDER BY LENGTH(camera), camera ASC, LENGTH(rand), rand ASC, LENGTH(raft), raft ASC, LENGTH(alveola), alveola ASC

SELECT *
FROM `oc_product_locatie`
WHERE product_id = '272203' AND baza_date LIKE 'magazin_claumar'
ORDER BY LENGTH(camera), camera ASC, LENGTH(rand), rand ASC, LENGTH(raft), raft ASC, LENGTH(alveola), alveola ASC

SELECT COUNT(1) AS total, rating
FROM `oc_review`
WHERE `product_id` = '272203' AND status=1 GROUP BY rating
ORDER BY rating ASC

SELECT COUNT(1) AS total
FROM `oc_review`
WHERE `product_id` = '272203' AND status=1 AND verificat = '1' GROUP BY product_id

SELECT r.review_id, r.author, r.rating, r.text, p.product_id, pd.name, p.price, p.image, r.date_added, r.verificat, r.apreciat, r.depreciat
FROM oc_review r
LEFT JOIN oc_product p ON (r.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
WHERE p.product_id = '272203' AND p.date_available <= NOW() AND p.status = '1' AND r.status = '1' AND pd.language_id = '2'
ORDER BY r.date_added DESC LIMIT 0,100

SELECT *
FROM oc_product_related pr
LEFT JOIN oc_product p ON (pr.related_id = p.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pr.product_id = '272203' AND p.status = '1' AND p2s.store_id = '2'

SELECT `pd`.*
FROM `oc_product_recurring` `pp` JOIN `oc_recurring_description` `pd` ON `pd`.`language_id` = 2 AND `pd`.`recurring_id` = `pp`.`recurring_id` JOIN `oc_recurring` `p` ON `p`.`recurring_id` = `pd`.`recurring_id`
WHERE `product_id` = 272203 AND `status` = 1 AND `customer_group_id` = 1
ORDER BY `sort_order` ASC

SELECT *
FROM `oc_pb_bundles`
WHERE `products` != '' AND `status`= '1' AND type = '1' AND `date_available` <= NOW() AND `customer_type` = 0 AND `products_show` LIKE '%"272203"%' LIMIT 0, 1000

SELECT *
FROM `oc_pb_bundles`
WHERE `products` != '' AND `status`= '1' AND type = '0' AND `date_available` <= NOW() AND `customer_type` = 0 AND `products_show` LIKE '%"272203"%' LIMIT 0, 1000

SELECT *
FROM oc_banner_image bi
LEFT JOIN oc_banner_image_description bid ON (bi.banner_image_id = bid.banner_image_id)
WHERE bi.banner_id = '24' AND bid.language_id = '2'
ORDER BY bi.sort_order ASC

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

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

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

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

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '823' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '483' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '84' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '222' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '279' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '380' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '637' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

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

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

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

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

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '225' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '653' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

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

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

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

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

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

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

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

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

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

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

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

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '487' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '453' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

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

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

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

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

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

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

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

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

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '828' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

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

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

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

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

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

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '262' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '270' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '271' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

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

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '272' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

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

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '293' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

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

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '382' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

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

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '278' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

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

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '274' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '277' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '779' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

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

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '644' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

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

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

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

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '422' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

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

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

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

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

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

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

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

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

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

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

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

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '441' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

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

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

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

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

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

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

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

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '276' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '439' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '220' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '226' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '390' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '392' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '227' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

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

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '393' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '292' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

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

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '383' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '491' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '651' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

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

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

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

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

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

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

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

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

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

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

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '229' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

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

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '230' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

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

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '228' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

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

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

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

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

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

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

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

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

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

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

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '231' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

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

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '421' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

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

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '434' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

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

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '355' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '387' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '405' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '250' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '251' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

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

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '252' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

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

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '661' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

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

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '741' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '256' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

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

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '727' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

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

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '769' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '781' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '257' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '253' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '255' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '632' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '263' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '636' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '221' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '258' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

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

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '269' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

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

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '370' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

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

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '261' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '259' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

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

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '268' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

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

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '824' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

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

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '384' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

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

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '266' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '789' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '719' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '264' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '643' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '817' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

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

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

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

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

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

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

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

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '436' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

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

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '137' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

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

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '693' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

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

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

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

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

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

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

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

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

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

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

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '677' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

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

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

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

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

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '282' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '285' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '286' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '290' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '287' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '650' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '381' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '284' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '288' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '306' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

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

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '419' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '325' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '198' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '787' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '91' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '204' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '96' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '94' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '579' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '202' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '93' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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

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

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

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

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

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

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

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

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