Иэк

Конфигуратор позволяет подобрать оптимальное решение по ключевым параметрам оборудования, или рассчитает его по размещенным приборам/оборудованию.

Оборудование производителя IEK

SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM tax_rule tr1
LEFT JOIN tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.based = ‘shipping’ AND tr2cg.customer_group_id = ‘1’ AND z2gz.country_id = ‘176’ AND (z2gz.zone_id = ‘0’ OR z2gz.zone_id = ‘2761’)
ORDER BY tr1.priority ASC

13 (0.307)

SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM tax_rule tr1
LEFT JOIN tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.based = ‘store’ AND tr2cg.customer_group_id = ‘1’ AND z2gz.country_id = ‘176’ AND (z2gz.zone_id = ‘0’ OR z2gz.zone_id = ‘2761’)
ORDER BY tr1.priority ASC

14 (0.384)

SELECT *
FROM weight_class wc
LEFT JOIN weight_class_description wcd ON (wc.weight_class_id = wcd.weight_class_id)
WHERE wcd.language_id = ‘1’

/var/www/electro-katalog.ru/data/www/electro-katalog.ru/system/library/cart/weight.php:10
15 (0.415)

SELECT *
FROM length_class mc
LEFT JOIN length_class_description mcd ON (mc.length_class_id = mcd.length_class_id)
WHERE mcd.language_id = ‘1’

/var/www/electro-katalog.ru/data/www/electro-katalog.ru/system/library/cart/length.php:10
16 (0.287)

DELETE
FROM cart
WHERE (api_id > ‘0’ OR customer_id = ‘0’) AND date_added SELECT *
FROM `event`
WHERE `trigger` LIKE ‘catalog/%’ AND status = ‘1’
ORDER BY `sort_order` ASC

/var/www/electro-katalog.ru/data/www/electro-katalog.ru/catalog/model/setting/event.php:4
18 (0.304)
SELECT language_id
FROM language
WHERE code = ‘0’ AND status = ‘1’ LIMIT 1
19 (0.688)

SELECT *
FROM translation
WHERE store_id = ‘0’ AND language_id = ‘1’ AND (route = ‘product/manufacturer’ OR route = ‘ru-ru’)

/var/www/electro-katalog.ru/data/www/electro-katalog.ru/catalog/model/design/translation.php:6
20 (0.956)

SELECT DISTINCT *
FROM manufacturer m
LEFT JOIN manufacturer_description md ON (m.manufacturer_id = md.manufacturer_id)
LEFT JOIN manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = ’22’ AND md.language_id = ‘1’ AND m2s.store_id = ‘0’

/var/www/electro-katalog.ru/data/www/electro-katalog.ru/catalog/model/catalog/manufacturer.php:17
21 (0.295)

SELECT *
FROM translation
WHERE store_id = ‘0’ AND language_id = ‘1’ AND (route = ‘extension/theme/prostore’ OR route = ‘ru-ru’)

/var/www/electro-katalog.ru/data/www/electro-katalog.ru/catalog/model/design/translation.php:6
22 (0.247)

SELECT *
FROM translation
WHERE store_id = ‘0’ AND language_id = ‘1’ AND (route = ‘checkout/checkout’ OR route = ‘ru-ru’)

/var/www/electro-katalog.ru/data/www/electro-katalog.ru/catalog/model/design/translation.php:6
23 (64.031)

SELECT COUNT (DISTINCT p.product_id) AS total
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = ‘1’ AND p.status = ‘1’ AND p.date_available AND p2s.store_id = ‘0’ AND p.manufacturer_id = ’22’ GROUP BY p.product_id

24 (313.899)

SELECT p.product_id, ( SELECT AVG(rating) AS total
FROM review r1
WHERE r1.product_id = p.product_id AND r1.status = ‘1’ GROUP BY r1.product_id) AS rating, ( SELECT price
FROM 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 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 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 AND (ps.date_end = ‘0000-00-00’ OR ps.date_end > NOW()))
ORDER BY ps.priority ASC , ps.price ASC LIMIT 1) AS special, coalesce(( SELECT price
FROM 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 AND (pd2.date_end = ‘0000-00-00’ OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC , pd2.price ASC LIMIT 1), ( SELECT price
FROM 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 AND (ps.date_end = ‘0000-00-00’ OR ps.date_end > NOW()))
ORDER BY ps.priority ASC , ps.price ASC LIMIT 1), p.price) as realprice, p.quantity
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = ‘1’ AND p.status = ‘1’ AND p.date_available AND p2s.store_id = ‘0’ AND p.manufacturer_id = ’22’ GROUP BY p.product_id
ORDER BY (p.quantity>0) DESC , p.sort_order ASC , LCASE(pd.name) ASC LIMIT 0,9

25 (3.247)

SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, ( SELECT price
FROM 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 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 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 AND (ps.date_end = ‘0000-00-00’ OR ps.date_end > NOW()))
ORDER BY ps.priority ASC , ps.price ASC LIMIT 1) AS special, ( SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = ‘1’) AS reward, ( SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = ‘1’) AS stock_status, ( SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = ‘1’) AS weight_class, ( SELECT lcd.unit
FROM length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = ‘1’) AS length_class, ( SELECT AVG(rating) AS total
FROM review r1
WHERE r1.product_id = p.product_id AND r1.status = ‘1’ GROUP BY r1.product_id) AS rating, ( SELECT COUNT (*) AS total
FROM review r2
WHERE r2.product_id = p.product_id AND r2.status = ‘1’ GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = ‘44475’ AND pd.language_id = ‘1’ AND p.status = ‘1’ AND p.date_available AND p2s.store_id = ‘0’

26 (0.949)

SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, ( SELECT price
FROM 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 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 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 AND (ps.date_end = ‘0000-00-00’ OR ps.date_end > NOW()))
ORDER BY ps.priority ASC , ps.price ASC LIMIT 1) AS special, ( SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = ‘1’) AS reward, ( SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = ‘1’) AS stock_status, ( SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = ‘1’) AS weight_class, ( SELECT lcd.unit
FROM length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = ‘1’) AS length_class, ( SELECT AVG(rating) AS total
FROM review r1
WHERE r1.product_id = p.product_id AND r1.status = ‘1’ GROUP BY r1.product_id) AS rating, ( SELECT COUNT (*) AS total
FROM review r2
WHERE r2.product_id = p.product_id AND r2.status = ‘1’ GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = ‘44476’ AND pd.language_id = ‘1’ AND p.status = ‘1’ AND p.date_available AND p2s.store_id = ‘0’

27 (0.823)

SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, ( SELECT price
FROM 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 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 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 AND (ps.date_end = ‘0000-00-00’ OR ps.date_end > NOW()))
ORDER BY ps.priority ASC , ps.price ASC LIMIT 1) AS special, ( SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = ‘1’) AS reward, ( SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = ‘1’) AS stock_status, ( SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = ‘1’) AS weight_class, ( SELECT lcd.unit
FROM length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = ‘1’) AS length_class, ( SELECT AVG(rating) AS total
FROM review r1
WHERE r1.product_id = p.product_id AND r1.status = ‘1’ GROUP BY r1.product_id) AS rating, ( SELECT COUNT (*) AS total
FROM review r2
WHERE r2.product_id = p.product_id AND r2.status = ‘1’ GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = ‘44502’ AND pd.language_id = ‘1’ AND p.status = ‘1’ AND p.date_available AND p2s.store_id = ‘0’

28 (0.796)

SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, ( SELECT price
FROM 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 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 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 AND (ps.date_end = ‘0000-00-00’ OR ps.date_end > NOW()))
ORDER BY ps.priority ASC , ps.price ASC LIMIT 1) AS special, ( SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = ‘1’) AS reward, ( SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = ‘1’) AS stock_status, ( SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = ‘1’) AS weight_class, ( SELECT lcd.unit
FROM length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = ‘1’) AS length_class, ( SELECT AVG(rating) AS total
FROM review r1
WHERE r1.product_id = p.product_id AND r1.status = ‘1’ GROUP BY r1.product_id) AS rating, ( SELECT COUNT (*) AS total
FROM review r2
WHERE r2.product_id = p.product_id AND r2.status = ‘1’ GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = ‘44511’ AND pd.language_id = ‘1’ AND p.status = ‘1’ AND p.date_available AND p2s.store_id = ‘0’

29 (0.708)

SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, ( SELECT price
FROM 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 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 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 AND (ps.date_end = ‘0000-00-00’ OR ps.date_end > NOW()))
ORDER BY ps.priority ASC , ps.price ASC LIMIT 1) AS special, ( SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = ‘1’) AS reward, ( SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = ‘1’) AS stock_status, ( SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = ‘1’) AS weight_class, ( SELECT lcd.unit
FROM length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = ‘1’) AS length_class, ( SELECT AVG(rating) AS total
FROM review r1
WHERE r1.product_id = p.product_id AND r1.status = ‘1’ GROUP BY r1.product_id) AS rating, ( SELECT COUNT (*) AS total
FROM review r2
WHERE r2.product_id = p.product_id AND r2.status = ‘1’ GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = ‘44516’ AND pd.language_id = ‘1’ AND p.status = ‘1’ AND p.date_available AND p2s.store_id = ‘0’

30 (0.828)

SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, ( SELECT price
FROM 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 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 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 AND (ps.date_end = ‘0000-00-00’ OR ps.date_end > NOW()))
ORDER BY ps.priority ASC , ps.price ASC LIMIT 1) AS special, ( SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = ‘1’) AS reward, ( SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = ‘1’) AS stock_status, ( SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = ‘1’) AS weight_class, ( SELECT lcd.unit
FROM length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = ‘1’) AS length_class, ( SELECT AVG(rating) AS total
FROM review r1
WHERE r1.product_id = p.product_id AND r1.status = ‘1’ GROUP BY r1.product_id) AS rating, ( SELECT COUNT (*) AS total
FROM review r2
WHERE r2.product_id = p.product_id AND r2.status = ‘1’ GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = ‘44521’ AND pd.language_id = ‘1’ AND p.status = ‘1’ AND p.date_available AND p2s.store_id = ‘0’

31 (0.701)

SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, ( SELECT price
FROM 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 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 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 AND (ps.date_end = ‘0000-00-00’ OR ps.date_end > NOW()))
ORDER BY ps.priority ASC , ps.price ASC LIMIT 1) AS special, ( SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = ‘1’) AS reward, ( SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = ‘1’) AS stock_status, ( SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = ‘1’) AS weight_class, ( SELECT lcd.unit
FROM length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = ‘1’) AS length_class, ( SELECT AVG(rating) AS total
FROM review r1
WHERE r1.product_id = p.product_id AND r1.status = ‘1’ GROUP BY r1.product_id) AS rating, ( SELECT COUNT (*) AS total
FROM review r2
WHERE r2.product_id = p.product_id AND r2.status = ‘1’ GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = ‘44518’ AND pd.language_id = ‘1’ AND p.status = ‘1’ AND p.date_available AND p2s.store_id = ‘0’

32 (0.823)

SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, ( SELECT price
FROM 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 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 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 AND (ps.date_end = ‘0000-00-00’ OR ps.date_end > NOW()))
ORDER BY ps.priority ASC , ps.price ASC LIMIT 1) AS special, ( SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = ‘1’) AS reward, ( SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = ‘1’) AS stock_status, ( SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = ‘1’) AS weight_class, ( SELECT lcd.unit
FROM length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = ‘1’) AS length_class, ( SELECT AVG(rating) AS total
FROM review r1
WHERE r1.product_id = p.product_id AND r1.status = ‘1’ GROUP BY r1.product_id) AS rating, ( SELECT COUNT (*) AS total
FROM review r2
WHERE r2.product_id = p.product_id AND r2.status = ‘1’ GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = ‘44520’ AND pd.language_id = ‘1’ AND p.status = ‘1’ AND p.date_available AND p2s.store_id = ‘0’

33 (0.723)

SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, ( SELECT price
FROM 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 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 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 AND (ps.date_end = ‘0000-00-00’ OR ps.date_end > NOW()))
ORDER BY ps.priority ASC , ps.price ASC LIMIT 1) AS special, ( SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = ‘1’) AS reward, ( SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = ‘1’) AS stock_status, ( SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = ‘1’) AS weight_class, ( SELECT lcd.unit
FROM length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = ‘1’) AS length_class, ( SELECT AVG(rating) AS total
FROM review r1
WHERE r1.product_id = p.product_id AND r1.status = ‘1’ GROUP BY r1.product_id) AS rating, ( SELECT COUNT (*) AS total
FROM review r2
WHERE r2.product_id = p.product_id AND r2.status = ‘1’ GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = ‘44514’ AND pd.language_id = ‘1’ AND p.status = ‘1’ AND p.date_available AND p2s.store_id = ‘0’

34 (1.105)

SELECT count (*) as c
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_SCHEMA=’electro-katalog.ru’ AND TABLE_NAME=’category’ AND COLUMN_NAME=’noindex’

/var/www/electro-katalog.ru/data/www/electro-katalog.ru/system/library/themes899/helper.php:363
35 (0.681)

SELECT *
FROM cart
WHERE api_id = ‘0’ AND customer_id = ‘0’ AND session_id = ‘f8482cf155164c4a6893d557e3’

Все категории оборудования IEK

Широкий ассортимент и разнообразие продукции радует потребителей. Компания выпускает:

• Оснащение модульные – выключатели-автоматы, модули вспомогательные.
• Силовые выключатели, другое коммутационное оборудование и защиту.
• Оборудование контроля, электроизмерительные приборы.
• Боксы, шкафы, дополнительное оборудование и аксессуары.

В каталоге компании представлены системы для укладки кабеля, монтажные короба и рукава, линейная арматура, кабельные муфты. Спрос велик на контакторы, пускатели, реле и коммутационное оборудование.

Марка IEK разрабатывает инновационные решения, поэтому ее продукция всегда в тренде. В РФ продукция известна более 10 лет. Профессионалы отмечают долгую эксплуатацию, отличную стоимость, наличие необходимых товаров во всех группах. Проектировщики предпочитают создавать линейки с лаконичным дизайном, практичные, с доступным оперативным обслуживанием.

Категории
Выберите обязательные опции
В корзину
Быстрый заказ
Имя Телефон E-mail Комментарий Отправить заказ

Дистрибьюция оборудования IEK

• Подбор продукции
• Оплата и доставка
• Гарантия на продукцию
• Новости

• Коммерческое предложение
• Проектные и оптовые цены
• Прайс-лист

Пн-Пт, с 08:00 до 20:00 Сб-Вс: с 10:00 до 18:00

Электронная почта [email protected] Адрес магазина г. Москва, ул. Южнопортовая д. 34, стр. 2

Дистрибьюция оборудования IEK

search start [json-ld] —> search end [json-ld] —>
Queries: 389, Total time: 249.390 ms [By time] [By id] [By file]
1 (0.262)
SET time_zone = ‘+00:00’
/var/www/electro-katalog.ru/data/www/electro-katalog.ru/system/framework.php:84
2 (0.624)

DELETE
FROM `session`
WHERE `expire` SELECT *
FROM translation
WHERE store_id = ‘0’ AND language_id = ‘0’ AND (route = ‘engb’ OR route = »)

/var/www/electro-katalog.ru/data/www/electro-katalog.ru/catalog/model/design/translation.php:6
4 (0.411)

SELECT `data`
FROM `session`
WHERE `session_id` = ‘e3b9df00b8e0b487ceebe4939f’ AND `expire` > ‘2024-10-07 05:44:14’

/var/www/electro-katalog.ru/data/www/electro-katalog.ru/system/library/session/db.php:16
5 (0.389)
SELECT *
FROM store
WHERE REPLACE(`ssl`, ‘www.’, ») = ‘https://electro-katalog.ru/’
6 (2.143)
SELECT *
FROM `setting`
WHERE store_id = ‘0’ OR store_id = ‘0’
ORDER BY store_id ASC
7 (0.229)
SET time_zone = ‘+03:00’
8 (0.405)
SELECT *
FROM currency
/var/www/electro-katalog.ru/data/www/electro-katalog.ru/system/library/cart/currency.php:10
9 (0.498)

SELECT *
FROM seo_url
WHERE `store_id` = ‘0’ AND `language_id` = ‘1’ AND `keyword` = ‘all-categories’ LIMIT 1

/var/www/electro-katalog.ru/data/www/electro-katalog.ru/catalog/controller/jetcache/jetcache.php:383
10 (0.444)

DELETE
FROM cart
WHERE (api_id > ‘0’ OR customer_id = ‘0’) AND date_added SELECT *
FROM cart
WHERE customer_id = ‘0’ AND session_id = ‘e3b9df00b8e0b487ceebe4939f’

/var/www/electro-katalog.ru/data/www/electro-katalog.ru/catalog/controller/jetcache/jetcache.php:266
12 (0.766)

SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM tax_rule tr1
LEFT JOIN tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.based = ‘shipping’ AND tr2cg.customer_group_id = ‘1’ AND z2gz.country_id = ‘176’ AND (z2gz.zone_id = ‘0’ OR z2gz.zone_id = ‘2761’)
ORDER BY tr1.priority ASC

13 (0.401)

SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM tax_rule tr1
LEFT JOIN tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.based = ‘store’ AND tr2cg.customer_group_id = ‘1’ AND z2gz.country_id = ‘176’ AND (z2gz.zone_id = ‘0’ OR z2gz.zone_id = ‘2761’)
ORDER BY tr1.priority ASC

14 (0.532)

SELECT *
FROM weight_class wc
LEFT JOIN weight_class_description wcd ON (wc.weight_class_id = wcd.weight_class_id)
WHERE wcd.language_id = ‘1’

/var/www/electro-katalog.ru/data/www/electro-katalog.ru/system/library/cart/weight.php:10
15 (0.563)

SELECT *
FROM length_class mc
LEFT JOIN length_class_description mcd ON (mc.length_class_id = mcd.length_class_id)
WHERE mcd.language_id = ‘1’

/var/www/electro-katalog.ru/data/www/electro-katalog.ru/system/library/cart/length.php:10
16 (0.455)

DELETE
FROM cart
WHERE (api_id > ‘0’ OR customer_id = ‘0’) AND date_added SELECT *
FROM `event`
WHERE `trigger` LIKE ‘catalog/%’ AND status = ‘1’
ORDER BY `sort_order` ASC

/var/www/electro-katalog.ru/data/www/electro-katalog.ru/catalog/model/setting/event.php:4
18 (0.365)
SELECT language_id
FROM language
WHERE code = ‘0’ AND status = ‘1’ LIMIT 1
19 (0.634)

SELECT *
FROM translation
WHERE store_id = ‘0’ AND language_id = ‘1’ AND (route = ‘information/information’ OR route = ‘ru-ru’)

/var/www/electro-katalog.ru/data/www/electro-katalog.ru/catalog/model/design/translation.php:6
20 (0.685)

SELECT DISTINCT *
FROM information i
LEFT JOIN information_description id ON (i.information_id = id.information_id)
LEFT JOIN information_to_store i2s ON (i.information_id = i2s.information_id)
WHERE i.information_id = ’11’ AND id.language_id = ‘1’ AND i2s.store_id = ‘0’ AND i.status = ‘1’

/var/www/electro-katalog.ru/data/www/electro-katalog.ru/catalog/model/catalog/information.php:4
21 (0.478)

SELECT *
FROM theme
WHERE store_id = ‘0’ AND theme = ‘prostore’ AND route = ‘extension/module/microdatapro/tc_og’

/var/www/electro-katalog.ru/data/www/electro-katalog.ru/catalog/model/design/theme.php:4
22 (0.453)

SELECT *
FROM theme
WHERE store_id = ‘0’ AND theme = ‘prostore’ AND route = ‘extension/module/microdatapro/information’

/var/www/electro-katalog.ru/data/www/electro-katalog.ru/catalog/model/design/theme.php:4
23 (2.236)
SELECT *
FROM information_to_layout
WHERE information_id = ’11’ AND store_id = ‘0’
/var/www/electro-katalog.ru/data/www/electro-katalog.ru/catalog/model/catalog/information.php:16
24 (0.411)

SELECT COUNT (*) as total
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ‘electro-katalog.ru’ AND TABLE_NAME = ‘ocdevwizard_setting’

25 (0.383)
SELECT *
FROM ocdevwizard_setting
WHERE store_id = ‘0’ AND `key` = ‘form_builder_form_data’
26 (0.417)
SELECT *
FROM layout_module
WHERE layout_id = ’19’ AND position = ‘column_left’
ORDER BY sort_order
/var/www/electro-katalog.ru/data/www/electro-katalog.ru/catalog/model/design/layout.php:14
27 (0.556)

SELECT DISTINCT f.sort_order, f2l.form_id
FROM ocdw_form_builder_form f
LEFT JOIN ocdw_form_builder_form_to_layout_for_module f2l ON (f.form_id = f2l.form_id)
WHERE f2l.layout_id = ’19’ AND f.position = ‘column_left’ AND f.display_type = ‘2’ AND f.status = ‘1’
ORDER BY f.sort_order ASC

28 (0.302)
SELECT *
FROM theme
WHERE store_id = ‘0’ AND theme = ‘prostore’ AND route = ‘common/column_left’
/var/www/electro-katalog.ru/data/www/electro-katalog.ru/catalog/model/design/theme.php:4
29 (0.275)
SELECT *
FROM information_to_layout
WHERE information_id = ’11’ AND store_id = ‘0’
/var/www/electro-katalog.ru/data/www/electro-katalog.ru/catalog/model/catalog/information.php:16
30 (0.297)
SELECT *
FROM layout_module
WHERE layout_id = ’19’ AND position = ‘column_right’
ORDER BY sort_order
/var/www/electro-katalog.ru/data/www/electro-katalog.ru/catalog/model/design/layout.php:14
31 (0.335)

SELECT DISTINCT f.sort_order, f2l.form_id
FROM ocdw_form_builder_form f
LEFT JOIN ocdw_form_builder_form_to_layout_for_module f2l ON (f.form_id = f2l.form_id)
WHERE f2l.layout_id = ’19’ AND f.position = ‘column_right’ AND f.display_type = ‘2’ AND f.status = ‘1’
ORDER BY f.sort_order ASC

32 (0.255)
SELECT *
FROM theme
WHERE store_id = ‘0’ AND theme = ‘prostore’ AND route = ‘common/column_right’
/var/www/electro-katalog.ru/data/www/electro-katalog.ru/catalog/model/design/theme.php:4
33 (0.287)
SELECT *
FROM information_to_layout
WHERE information_id = ’11’ AND store_id = ‘0’
/var/www/electro-katalog.ru/data/www/electro-katalog.ru/catalog/model/catalog/information.php:16
34 (0.249)
SELECT *
FROM layout_module
WHERE layout_id = ’19’ AND position = ‘content_top’
ORDER BY sort_order
/var/www/electro-katalog.ru/data/www/electro-katalog.ru/catalog/model/design/layout.php:14
35 (0.329)

SELECT DISTINCT f.sort_order, f2l.form_id
FROM ocdw_form_builder_form f
LEFT JOIN ocdw_form_builder_form_to_layout_for_module f2l ON (f.form_id = f2l.form_id)
WHERE f2l.layout_id = ’19’ AND f.position = ‘content_top’ AND f.display_type = ‘2’ AND f.status = ‘1’
ORDER BY f.sort_order ASC

36 (0.217)
SELECT *
FROM theme
WHERE store_id = ‘0’ AND theme = ‘prostore’ AND route = ‘common/content_top’
/var/www/electro-katalog.ru/data/www/electro-katalog.ru/catalog/model/design/theme.php:4
37 (0.242)
SELECT *
FROM information_to_layout
WHERE information_id = ’11’ AND store_id = ‘0’
/var/www/electro-katalog.ru/data/www/electro-katalog.ru/catalog/model/catalog/information.php:16
38 (0.293)

SELECT *
FROM layout_module
WHERE layout_id = ’19’ AND position = ‘content_bottom’
ORDER BY sort_order

/var/www/electro-katalog.ru/data/www/electro-katalog.ru/catalog/model/design/layout.php:14
39 (0.277)

SELECT DISTINCT f.sort_order, f2l.form_id
FROM ocdw_form_builder_form f
LEFT JOIN ocdw_form_builder_form_to_layout_for_module f2l ON (f.form_id = f2l.form_id)
WHERE f2l.layout_id = ’19’ AND f.position = ‘content_bottom’ AND f.display_type = ‘2’ AND f.status = ‘1’
ORDER BY f.sort_order ASC

40 (0.462)
SELECT *
FROM module
WHERE module_id = ’42’
/var/www/electro-katalog.ru/data/www/electro-katalog.ru/catalog/model/setting/module.php:4
41 (11.214)

SELECT *
FROM translation
WHERE store_id = ‘0’ AND language_id = ‘1’ AND (route = ‘extension/module/prostore_category’ OR route = ‘ru-ru’)

/var/www/electro-katalog.ru/data/www/electro-katalog.ru/catalog/model/design/translation.php:6
42 (1.801)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘0’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

43 (0.852)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘3786’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

44 (0.915)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘3814’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

45 (0.777)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘3815’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

46 (0.672)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘3835’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

47 (0.769)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘3820’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

48 (0.782)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘3787’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

49 (0.658)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘3788’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

50 (0.535)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘3811’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

51 (0.762)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘3794’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

52 (0.715)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘3842’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

53 (0.587)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘3843’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

54 (0.559)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘3866’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

55 (0.911)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘3845’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

56 (0.629)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘3871’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

57 (0.545)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘3894’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

58 (0.676)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘3895’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

59 (0.595)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘3883’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

60 (0.601)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘3884’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

61 (0.565)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘3887’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

62 (0.730)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘3891’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

63 (0.532)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘3880’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

64 (0.557)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘3881’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

65 (0.598)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘3872’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

66 (0.736)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘3876’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

67 (0.720)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘3873’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

68 (0.981)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘3878’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

69 (0.701)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘3897’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

70 (0.725)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘3919’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

71 (0.728)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘3925’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

72 (0.634)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘3920’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

73 (0.554)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘3898’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

74 (0.650)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘3899’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

75 (0.536)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘3915’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

76 (0.746)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘3916’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

77 (0.662)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘3934’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

78 (0.768)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘3966’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

79 (0.647)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4002’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

80 (0.602)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘3967’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

81 (1.348)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘3979’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

82 (0.886)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘3985’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

83 (0.779)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘3995’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

84 (0.696)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4012’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

85 (0.591)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘5147’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

86 (0.714)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4013’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

87 (0.748)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘3935’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

88 (0.616)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘3955’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

89 (0.602)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘3959’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

90 (0.627)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘3936’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

91 (0.665)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘3952’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

92 (0.554)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘5145’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

93 (0.523)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘3962’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

94 (0.987)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4051’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

95 (0.613)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4052’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

96 (0.649)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4088’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

97 (0.684)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4121’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

98 (0.634)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4108’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

99 (0.649)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4117’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

100 (0.702)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4124’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

101 (0.562)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4114’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

102 (0.626)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4098’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

103 (0.885)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4056’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

104 (0.610)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4077’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

105 (0.612)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4018’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

106 (0.566)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4032’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

107 (0.562)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4024’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

108 (0.671)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4019’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

109 (0.658)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘3776’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

110 (0.606)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘3777’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

111 (0.676)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4954’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

112 (0.636)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘3778’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

113 (0.645)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4974’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

114 (0.947)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4975’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

115 (0.526)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4949’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

116 (0.540)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4950’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

117 (0.540)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4964’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

118 (0.535)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4965’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

119 (0.629)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4631’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

120 (0.692)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4711’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

121 (0.615)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4759’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

122 (0.909)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4712’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

123 (0.609)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4745’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

124 (0.490)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘5194’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

125 (0.598)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4765’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

126 (0.562)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘5199’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

127 (0.533)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4766’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

128 (0.865)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4778’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

129 (0.652)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4632’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

130 (0.557)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4700’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

131 (0.745)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4668’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

132 (0.649)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4633’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

133 (0.602)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘5343’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

134 (0.645)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4482’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

135 (0.578)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4545’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

136 (0.553)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4546’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

137 (0.700)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4548’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

138 (0.570)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4557’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

139 (0.652)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4558’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

140 (0.648)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4566’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

141 (0.542)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4524’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

142 (0.528)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4529’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

143 (0.580)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4525’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

144 (0.578)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4531’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

145 (0.811)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4532’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

146 (0.636)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4540’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

147 (0.711)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4483’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

148 (0.703)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4509’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

149 (0.633)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4520’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

150 (0.708)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4484’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

151 (0.748)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4574’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

152 (0.639)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4575’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

153 (0.708)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4576’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

154 (1.080)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4582’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

155 (0.631)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4586’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

156 (0.656)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4598’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

157 (0.545)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4605’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

158 (0.546)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4603’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

159 (0.613)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4599’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

160 (0.610)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4588’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

161 (0.718)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4589’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

162 (0.497)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4596’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

163 (0.544)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4607’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

164 (0.521)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4628’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

165 (0.676)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4608’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

166 (0.584)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4923’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

167 (0.538)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4924’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

168 (0.584)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4925’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

169 (0.483)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4934’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

170 (0.468)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4936’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

171 (0.603)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4937’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

172 (0.490)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘3781’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

173 (0.541)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘3782’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

174 (0.493)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘3783’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

175 (0.728)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4788’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

176 (0.644)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4902’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

177 (0.616)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4910’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

178 (0.524)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4903’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

179 (0.581)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4905’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

180 (0.599)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4789’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

181 (0.669)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4790’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

182 (1.116)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4813’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

183 (1.074)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4823’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

184 (0.977)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4862’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

185 (1.085)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4863’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

186 (1.012)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4871’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

187 (1.256)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4830’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

188 (0.833)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4857’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

189 (0.851)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4844’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

190 (0.951)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4838’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

191 (0.845)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4854’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

192 (0.911)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4835’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

193 (0.719)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4859’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

194 (0.887)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4831’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

195 (0.845)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4849’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

196 (0.753)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4852’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

197 (1.061)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘5307’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

198 (0.659)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘5310’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

199 (0.797)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘5327’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

200 (0.774)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘5324’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

201 (0.603)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘5308’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

202 (0.756)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘5329’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

203 (0.837)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘5320’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

204 (0.887)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘5316’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

205 (0.925)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4875’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

206 (0.719)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4884’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

207 (0.853)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4876’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

208 (0.792)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4881’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

209 (0.655)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘5333’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

210 (0.718)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘5334’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

211 (14)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4888’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

212 (0.576)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4894’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

213 (0.793)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4889’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

214 (0.955)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4897’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

215 (0.855)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4912’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

216 (0.870)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4921’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

217 (1.234)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4913’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

218 (1.248)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4918’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

219 (0.999)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4916’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

220 (1.417)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4137’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

221 (1.253)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4138’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

222 (1.057)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4142’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

223 (0.955)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4139’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

224 (0.691)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4161’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

225 (0.739)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4147’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

226 (0.750)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4406’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

227 (1.235)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4407’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

228 (0.943)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4191’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

229 (0.778)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4245’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

230 (0.580)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4316’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

231 (0.622)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4220’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

232 (0.687)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4192’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

233 (0.557)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4232’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

234 (0.557)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4349’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

235 (0.567)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4374’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

236 (0.569)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4176’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

237 (0.599)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4177’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

238 (0.586)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4184’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

239 (0.565)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4474’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

240 (0.735)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4475’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

241 (0.631)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4449’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

242 (0.695)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4463’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

243 (0.544)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4456’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

244 (0.614)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4450’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

245 (0.771)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4412’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

246 (0.634)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4413’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

247 (0.728)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4421’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

248 (0.716)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4447’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

249 (0.657)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4430’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

250 (0.734)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4435’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

251 (0.721)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4443’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

252 (0.646)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4163’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

253 (0.720)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘5179’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

254 (0.619)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4164’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

255 (0.582)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4172’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

256 (0.616)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘5283’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

257 (0.570)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘5284’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

258 (0.659)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘5052’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

259 (0.921)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘5084’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

260 (0.694)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘5118’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

261 (0.521)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘5119’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

262 (0.509)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘5112’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

263 (0.489)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘5113’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

264 (1.407)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘5085’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

265 (0.629)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘5110’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

266 (0.676)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘5111’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

267 (0.568)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘5117’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

268 (0.449)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘5116’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

269 (0.467)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘5114’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

270 (0.473)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘5115’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

271 (0.873)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘5053’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

272 (0.504)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘5083’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

273 (0.454)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘5082’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

274 (0.453)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘5079’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

275 (0.514)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘5074’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

276 (0.465)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘5075’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

277 (1.276)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘5054’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

278 (0.487)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘5077’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

279 (0.457)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘5076’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

280 (0.614)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘5081’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

281 (0.558)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘5078’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

282 (0.454)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘5080’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

283 (0.917)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4984’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

284 (0.728)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4991’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

285 (0.550)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘5007’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

286 (0.578)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘5004’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

287 (0.619)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4992’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

288 (0.578)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4998’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

289 (0.561)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘5009’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

290 (0.545)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘5010’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

291 (0.561)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘5013’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

292 (0.594)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘5023’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

293 (0.600)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘5024’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

294 (0.599)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘5028’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

295 (0.485)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘5016’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

296 (0.469)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘5017’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

297 (0.539)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘5034’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

298 (0.452)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘5035’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

299 (0.469)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘5036’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

300 (0.521)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘5041’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

301 (0.455)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘5042’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

302 (0.510)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘5037’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

303 (0.556)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘5038’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

304 (0.506)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘5032’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

305 (0.446)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘5033’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

306 (0.520)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘5018’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

307 (0.491)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘5019’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

308 (0.523)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘5020’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

309 (0.535)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘5021’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

310 (0.498)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘5022’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

311 (0.612)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4985’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

312 (0.452)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4989’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

313 (0.493)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4990’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

314 (0.462)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4987’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

315 (0.476)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4986’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

316 (0.461)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘4988’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

317 (0.558)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘5048’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

318 (0.450)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘5049’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

319 (0.521)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘5043’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

320 (0.576)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘5044’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

321 (0.545)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘5133’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

322 (0.566)

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = ‘5134’ AND cd.language_id = ‘1’ AND c2s.store_id = ‘0’ AND c.status = ‘1’
ORDER BY c.sort_order, LCASE(cd.name)

323 (0.514)

SELECT *
FROM theme
WHERE store_id = ‘0’ AND theme = ‘prostore’ AND route = ‘extension/module/prostore_category’

/var/www/electro-katalog.ru/data/www/electro-katalog.ru/catalog/model/design/theme.php:4
324 (0.614)
SELECT *
FROM module
WHERE module_id = ’51’
/var/www/electro-katalog.ru/data/www/electro-katalog.ru/catalog/model/setting/module.php:4
325 (0.427)

SELECT *
FROM translation
WHERE store_id = ‘0’ AND language_id = ‘1’ AND (route = ‘extension/module/featured’ OR route = ‘ru-ru’)

/var/www/electro-katalog.ru/data/www/electro-katalog.ru/catalog/model/design/translation.php:6
326 (0.317)

SELECT *
FROM translation
WHERE store_id = ‘0’ AND language_id = ‘1’ AND (route = ‘extension/theme/prostore’ OR route = ‘ru-ru’)

/var/www/electro-katalog.ru/data/www/electro-katalog.ru/catalog/model/design/translation.php:6
327 (0.320)
SELECT *
FROM theme
WHERE store_id = ‘0’ AND theme = ‘prostore’ AND route = ‘common/content_bottom’
/var/www/electro-katalog.ru/data/www/electro-katalog.ru/catalog/model/design/theme.php:4
328 (0.462)

SELECT *
FROM translation
WHERE store_id = ‘0’ AND language_id = ‘1’ AND (route = ‘common/footer’ OR route = ‘ru-ru’)

/var/www/electro-katalog.ru/data/www/electro-katalog.ru/catalog/model/design/translation.php:6
329 (0.317)

SELECT *
FROM theme
WHERE store_id = ‘0’ AND theme = ‘prostore’ AND route = ‘extension/module/microdatapro/company’

/var/www/electro-katalog.ru/data/www/electro-katalog.ru/catalog/model/design/theme.php:4
330 (0.480)

SELECT *
FROM translation
WHERE store_id = ‘0’ AND language_id = ‘1’ AND (route = ‘extension/theme/prostore’ OR route = ‘ru-ru’)

/var/www/electro-katalog.ru/data/www/electro-katalog.ru/catalog/model/design/translation.php:6
331 (0.284)

SELECT *
FROM translation
WHERE store_id = ‘0’ AND language_id = ‘1’ AND (route = ‘checkout/checkout’ OR route = ‘ru-ru’)

/var/www/electro-katalog.ru/data/www/electro-katalog.ru/catalog/model/design/translation.php:6
332 (0.255)
SELECT *
FROM theme
WHERE store_id = ‘0’ AND theme = ‘prostore’ AND route = ‘product/buyclick_form’
/var/www/electro-katalog.ru/data/www/electro-katalog.ru/catalog/model/design/theme.php:4
333 (0.326)

SELECT *
FROM translation
WHERE store_id = ‘0’ AND language_id = ‘1’ AND (route = ‘extension/theme/prostore’ OR route = ‘ru-ru’)

/var/www/electro-katalog.ru/data/www/electro-katalog.ru/catalog/model/design/translation.php:6
334 (0.401)
SELECT *
FROM seo_url
WHERE `query` = ‘extension/module/prostore_news/getnewslist’
335 (0.341)
SELECT *
FROM seo_url
WHERE `query` = ‘extension/module/prostore_news/getnewslist’
336 (0.562)

SELECT DISTINCT *
FROM information i
LEFT JOIN information_description id ON (i.information_id = id.information_id)
LEFT JOIN information_to_store i2s ON (i.information_id = i2s.information_id)
WHERE i.information_id = ‘8’ AND id.language_id = ‘1’ AND i2s.store_id = ‘0’ AND i.status = ‘1’

/var/www/electro-katalog.ru/data/www/electro-katalog.ru/catalog/model/catalog/information.php:4
337 (0.558)
SELECT *
FROM setting
WHERE store_id = ‘0’ AND `code` = ‘theme_prostoresoclinks’
/var/www/electro-katalog.ru/data/www/electro-katalog.ru/catalog/model/setting/setting.php:6
338 (0.446)
SELECT *
FROM setting
WHERE store_id = ‘0’ AND `code` = ‘theme_prostoremeslinks’
/var/www/electro-katalog.ru/data/www/electro-katalog.ru/catalog/model/setting/setting.php:6
339 (0.424)
SELECT *
FROM country
WHERE country_id = ‘176’ AND status = ‘1’
/var/www/electro-katalog.ru/data/www/electro-katalog.ru/catalog/model/localisation/country.php:4
340 (0.344)
SELECT *
FROM zone
WHERE zone_id = ‘2761’ AND status = ‘1’
/var/www/electro-katalog.ru/data/www/electro-katalog.ru/catalog/model/localisation/zone.php:4
341 (0.489)

SELECT DISTINCT *
FROM information i
LEFT JOIN information_description id ON (i.information_id = id.information_id)
LEFT JOIN information_to_store i2s ON (i.information_id = i2s.information_id)
WHERE i.information_id = ‘8’ AND id.language_id = ‘1’ AND i2s.store_id = ‘0’ AND i.status = ‘1’

/var/www/electro-katalog.ru/data/www/electro-katalog.ru/catalog/model/catalog/information.php:4
342 (0.314)

SELECT *
FROM theme
WHERE store_id = ‘0’ AND theme = ‘prostore’ AND route = ‘extension/module/callback’

Поиск информации по продукции

Выбор и приобретение
Каталоги

• Online раздел «Продукция»
• Технические каталоги

Информация по продукции

• Карточка товара

1. Полное наименование и артикул продукции.
2. Краткое описание.
3. Фото.
4. Технические характеристики.
5. Сертификаты и отказные письма.
6. Руководства по эксплуатации и инструкции по монтажу.
7. Габаритно-установочные чертежи.
8. Информационные материалы.
9. Модели для проектирования.
10. Особенности конструкции и комплектация.
11. Логистические параметры.
12. Совместно применяемые изделия.

Контакты технической поддержки IEK: +7 (495) 542 22 27 [email protected] С 9-00 до 17-30 МСК, кроме выходных.

Приобретение

• Где купить?
• Контакты (Региональные представители)

Поддержка по продукции
Контакты технической поддержки
Проектная поддержка

• Подбор аналогов

Для подбора аналогичной продукции из ассортимента IEK Group, направьте заявку на электронную почту технической поддержки:[email protected]

В заявке укажите свои контактные данные (город, наименование организации, номер телефона) и приложите список продукции, которую необходимо заменить.

Для подбора продукции по проекту или техническому заданию, направьте заявку на электронную почту технической поддержки: [email protected]
В заявке укажите свои контактные данные (город, наименование организации, номер телефона) и приложите необходимые документы.

Для выполнения светотехнического расчёта в программе DiaLux, направьте заявку на электронную почту технической поддержки [email protected]
В заявке укажите свои контактные данные (город, наименование организации, номер телефона) и информацию для расчёта: параметры помещения (план помещения), высоту установки и тип светильников, требуемый уровень освещённости.

Сервисное обеспечение

• Контакты сервисных центров
• Обмен и возврат по гарантии

По вопросам обмена или возврата продукции по гарантии Вы можете обратиться в торговую организацию, у которой её приобретали. Рекомендуем обратиться в торговую организацию с письменной претензией с требованием обмена или возврата продукции по гарантии. Если продукция приобреталась физ. лицом, возможно обращение по гарантии к производителю. Для этого обратитесь в техническую поддержку на электронную почту [email protected]

При возникновении сложностей с сервисным обслуживанием обратитесь в техническую поддержку на электронную почту [email protected]

Официальный партнер — поставщик продукции IEK в Казахстане компания COMPLEX DC. IEK GROUP
— это ведущий производитель электротехнической продукции под маркой IEK®, оборудования промышленной автоматизации ONI® и оборудования для IT сегмента ITK®.

Ассортимент продукции IEK это более 9000 наименований, на базе которых можно сформировать готовые комплексные решения для энергообеспечения объекта любой сложности и направления.

С учетом потребностей рынка Казахстана ежегодно разрабатывается новинки и расширяется ассортимент.

Ассортимент IEK это:
Модульное оборудование
— Автоматические выключатели
— Устройства дифференциальной защиты

Силовое оборудование защиты и коммутации
— Силовые автоматические выключатели
— Предохранители
— Выключатели-разъединители

Приборы учета, контроля, измерения и оборудование электропитания
— Приборы учета
— Приборы электроизмерительные
— Счетчики электрической энергии
— Оборудование электропитания

Шкафы, боксы и принадлежности к ним
— Корпуса пластиковые
— Корпуса металлические модульные
— Оболочки металлические
— Принадлежности и аксессуары для шкафов

Системы для прокладки кабеля
— Кабель-каналы и аксессуары
— Трубы пластиковые
— Металлорукав и трубы металлические
— Лотки металлические и аксессуары
— Коробки монтажные
— Оборудование и линейная арматура для СИП
— Муфты кабельные

Изделия электроустановочные, удлинители и силовые разъемы
— Электроустановочные изделия
— Удлинители бытовые и сетевые фильтры
— Удлинители силовые
— Разъёмы, колодки, тройники
— Силовые разъемы

Оборудование коммутационное и устройства управления
— Контакторы
— Реле и устройства дополнительные для контакторов
— Пускатели, выключатели
— Устройства подачи команд и сигналов

Изделия электромонтажные и инструменты
— Наконечники, гильзы, соединители и ответвители
— Изделия для изоляции, крепления и маркировки
— Инструменты

Светотехника
— Источники света
— Коммунальное и бытовое освещение
— Коммерческое освещение
— Промышленное освещение
— Уличное и архитектурное освещение
— Аварийное освещение
— Переносное освещение
— Управление освещением и комплектующие

Оборудование телекоммуникационное
— LAN-кабель и инструменты
— Компоненты СКС медные

Оборудование промышленной автоматизации
— Электродвигатели
— Частотно-регулируемый привод
— Автоматика релейная

Типовые решения НКУ
— ЩО
— ВРУ
— ПР
— Учетно- распределительные панели
— Щитки осветительные
— Щитки этажные
— Устройства этажные распределительные
— Щитки квартирные
— Шкафы распределительные силовые ШР11 и ШРС1
— Ящики управления электродвигателями
— ЩАП
— Шкафы уличного освещения И710
— Ящики управления освещением
— Ящики и шкафы управления ЯУ ШУ

Типовые решения для АСИП
— Типовые решения для железобетонных опор
— Типовые решения для деревянных опор

Источники:

https://electro-katalog.ru/iek/&rut=8c509fce863f0f0b98e5836453e74332abec43805894c566fdb960befddc2657
https://electro-katalog.ru/all-categories/&rut=97479628bee5275c74bbbb4b9b8fe258218da7e4296873b37dfc32c3a27c324a
https://www.iek.ru/support/configurator/&rut=d79ca751c63014743ac3a214868fb2112af8521e956d199c9d575482f83f95fa
https://iek-shop.kz/&rut=49616d8d21b4bd54a2fd44c39ed48c31794d560a10ba502577ac961662790e84