• Free Shipping
  • Guaranteed
  • Deal

Хит продаж

Новые статьи

Как сэкономить на обслуживании робота-пылесоса?..

  Покупатели робота-пылесоса iRobot Roomba задумываются о стоимости его содержания ещё до принятия решения о .....

Как часто менять фильтры в роботах-пылесосах?..

Как часто надо менять фильтр в роботе-пылесосе iRobot Roomba? Любой владелец робота-пылесоса легко ответит на этот вопр.....

Информация

  • Как выбрать товар?

    В каждой категории товаров есть фильтр по модели робота-пылесоса
  • Как оформить заказ?

    Перейдите в корзину в правом верхнем углу страницы.
  • Как оплатить заказ?

    Вы можете оплатить товар на сайте или при получении
  • Как получить заказ?

    Заказы можно забрать на почте, в пунктах самовывоза или оформить курьерскую доставку

Бренды на сайте Все


Горячее предложение

Скидка
Скидка
Banner
Banner

ОТЗЫВЫ О НАШЕЙ РАБОТЕ

Большое спасибо за вашу работу! К сожалению, не так уж просто найти комплектующие для робота... Я уже думала, что наш отслужил свой век 😅 Но благодаря вашему магазину он мне ещё послужит))) Так же очень порадовал сервис: сразу же отправили заказ и до Сахалина дошёл в рекордные сроки (всего 4 дня). Заказывала комплект щёток и фильтров. При заказе помогли подобрать детали именно к моему малышу. Когда что-нибудь выйдет из строя, обязательно вернусь к вам в магазин! 💃🏻"

Мария Ли

г. Южно-Сахалинск

" Спасибо большое за оперативную доставку, все дошло очень быстро, в целости и прекрасно работает! "
Алина Донец

г. Димитровград

" Заказывала боковые щетки для румбы 681. Почтой России все пришло быстро. Качество щеток очень хорошее, упакованы хорошо, ничего не погнулось, не сломалось. Сопровождение продавца от начала до получки заказа. Очень понравилось.Большое спасибо))) "
Дарья Жерехова

г. Владимир


Total time: 1.4249 s | Queries: 339 | Slow queries (>0.003 s): 33

#Query time (s)ControllerQuery
10.0017 SELECT value FROM setting WHERE store_id = '0' AND `key`='config_seo_url_type'
20.0008 SELECT * FROM extension WHERE `type` = 'openbay'
30.0006 ControllerStartupStartupSELECT * FROM store WHERE REPLACE(`ssl`, 'www.', '') = 'https://robofor.ru/'
40.0143 ControllerStartupStartupSELECT * FROM `setting` WHERE store_id = '0' OR store_id = '0' ORDER BY store_id ASC
50.0015 ControllerStartupStartup SELECT f1.postalcode f1_postalcode, f1.offname f1_name, f1.level f1_level, f1.fias_id f1_fias_id, f1.shortname f1_shortname, CONCAT(f2.offname, ' ', f2.shortname) f2_name, f2.level f2_level, f2.fias_id f2_fias_id, CONCAT(f3.offname, ' ', f3.shortname) f3_name, f3.level f3_level, f3.fias_id f3_fias_id, CONCAT(f4.offname, ' ', f4.shortname) f4_name, f4.level f4_level, f4.fias_id f4_fias_id FROM fias f1 LEFT JOIN fias f2 ON f2.fias_id = f1.parent_id LEFT JOIN fias f3 ON f3.fias_id = f2.parent_id LEFT JOIN fias f4 ON f4.fias_id = f3.parent_id WHERE f1.offname = 'Феърфилд' AND (f3.offname = 'США' OR f2.offname = 'США' OR f4.offname = 'США') AND (f1.level = 4 OR (f1.level = 1 AND f1.shortname = 'г.'))
60.0004 ControllerStartupStartupSELECT * FROM country c WHERE c.iso_code_2 = 'US'
70.0005 ControllerStartupStartupSELECT * FROM currency
80.0015 ControllerStartupStartupSELECT 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 = '0' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '0') ORDER BY tr1.priority ASC
90.0007 ControllerStartupStartupSELECT 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 = 'payment' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '0' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '0') ORDER BY tr1.priority ASC
100.0014 ControllerStartupStartupSELECT 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
110.0006 ControllerStartupStartupSELECT * FROM weight_class wc LEFT JOIN weight_class_description wcd ON (wc.weight_class_id = wcd.weight_class_id) WHERE wcd.language_id = '1'
120.0008 ControllerStartupStartupSELECT * FROM length_class mc LEFT JOIN length_class_description mcd ON (mc.length_class_id = mcd.length_class_id) WHERE mcd.language_id = '1'
130.0044 ControllerStartupStartupDELETE FROM cart WHERE (api_id > '0' OR customer_id = '0') AND date_added < DATE_SUB(NOW(), INTERVAL 3 MONTH)
140.0004 ControllerStartupStartupSELECT * FROM extension WHERE `type` = 'openbay'
150.0006 ControllerStartupEventSELECT * FROM `event` WHERE `trigger` LIKE 'catalog/%' AND status = '1' ORDER BY `event_id` ASC
160.0024 ControllerStartupSeoProSHOW TABLES LIKE 'soconfig'
170.0005 ControllerStartupSeoProselect * from soconfig where store_id='0'
180.0019 ControllerStartupSeoProSHOW TABLES LIKE 'soconfig'
190.0003 ControllerStartupSeoProselect * from soconfig where store_id='0'
200.0005 ControllerCommonColumnLeftSELECT * FROM layout_route WHERE 'common/home' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
210.0005 ControllerCommonColumnLeftSELECT * FROM layout_module WHERE layout_id = '1' AND position = 'column_left' ORDER BY sort_order
220.0003 ControllerCommonColumnRightSELECT * FROM layout_route WHERE 'common/home' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
230.0003 ControllerCommonColumnRightSELECT * FROM layout_module WHERE layout_id = '1' AND position = 'column_right' ORDER BY sort_order
240.0003 ControllerCommonContentTopSELECT * FROM layout_route WHERE 'common/home' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
250.0003 ControllerCommonContentTopSELECT * FROM layout_module WHERE layout_id = '1' AND position = 'content_top' ORDER BY sort_order
260.0005 ControllerEventCompatibilitySELECT * FROM module WHERE module_id = '251'
270.0002 ControllerEventCompatibilitySELECT * FROM module WHERE module_id = '194'
280.0008 ControllerEventCompatibilitySELECT hs.*, hsd.* FROM so_homeslider hs LEFT JOIN so_homeslider_description hsd ON (hsd.homeslider_id = hs.id) WHERE hs.module_id = '194' AND hsd.language_id = '1' AND hs.status= 1 ORDER BY position ASC
290.0003 ControllerEventCompatibilitySELECT * FROM module WHERE module_id = '268'
300.0002 ControllerEventCompatibilitySELECT * FROM module WHERE module_id = '198'
310.0011 ControllerEventCompatibilitySELECT DISTINCT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '96' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
320.0018 ControllerEventCompatibilitySELECT cp.category_id AS category_id, GROUP_CONCAT(cd1.name ORDER BY cp.level SEPARATOR '  >  ') AS name, c1.parent_id, c1.sort_order FROM category_path cp LEFT JOIN category c1 ON (cp.category_id = c1.category_id) LEFT JOIN category c2 ON (cp.path_id = c2.category_id) LEFT JOIN category_description cd1 ON (cp.path_id = cd1.category_id) LEFT JOIN category_description cd2 ON (cp.category_id = cd2.category_id) LEFT JOIN category_to_store c2s ON (c1.category_id = c2s.category_id) WHERE c1.parent_id = '96' AND cd1.language_id = '1' AND cd2.language_id = '1' AND c1.status = 1 AND c2s.store_id = '0' GROUP BY cp.category_id ORDER BY sort_order ASC
330.0377 ControllerEventCompatibilitySELECT 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 < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,(SELECT SUM(op.quantity) AS total FROM order_product op LEFT JOIN `order` o ON (op.order_id = o.order_id) WHERE o.order_status_id > '0' AND op.product_id = p.product_id GROUP BY op.product_id ORDER BY total) AS sales FROM product_to_category p2c LEFT JOIN product p ON (p2c.product_id = p.product_id) 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 <= NOW() AND p2s.store_id = '0' AND p2c.category_id IN (96) GROUP BY p.product_id ORDER BY sales ASC, LCASE(pd.name) ASC LIMIT 0,8
340.0033 ControllerEventCompatibilitySELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name FROM manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') 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 < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM product_reward pr WHERE pr.product_id = p.product_id AND 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 = '179' AND pd.language_id = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
350.0028 ControllerEventCompatibilitySELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name FROM manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') 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 < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM product_reward pr WHERE pr.product_id = p.product_id AND 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 = '89' AND pd.language_id = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
360.0027 ControllerEventCompatibilitySELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name FROM manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') 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 < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM product_reward pr WHERE pr.product_id = p.product_id AND 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 = '108' AND pd.language_id = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
370.0033 ControllerEventCompatibilitySELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name FROM manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') 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 < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM product_reward pr WHERE pr.product_id = p.product_id AND 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 = '74' AND pd.language_id = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
380.0009 ControllerEventCompatibilitySELECT * FROM product_image WHERE product_id ='179' ORDER BY sort_order ASC;
390.001 ControllerEventCompatibilitySELECT pq.warehouse_id as warehouse_id, pq.quantity as quantity, w.name as name FROM product_quantity pq LEFT JOIN warehouse w ON (pq.warehouse_id = w.warehouse_id) WHERE pq.product_id = '179' AND w.status = '1'
400.0005 ControllerEventCompatibilitySELECT * FROM product_image WHERE product_id ='89' ORDER BY sort_order ASC;
410.0008 ControllerEventCompatibilitySELECT pq.warehouse_id as warehouse_id, pq.quantity as quantity, w.name as name FROM product_quantity pq LEFT JOIN warehouse w ON (pq.warehouse_id = w.warehouse_id) WHERE pq.product_id = '89' AND w.status = '1'
420.0004 ControllerEventCompatibilitySELECT * FROM product_image WHERE product_id ='108' ORDER BY sort_order ASC;
430.0008 ControllerEventCompatibilitySELECT pq.warehouse_id as warehouse_id, pq.quantity as quantity, w.name as name FROM product_quantity pq LEFT JOIN warehouse w ON (pq.warehouse_id = w.warehouse_id) WHERE pq.product_id = '108' AND w.status = '1'
440.0004 ControllerEventCompatibilitySELECT * FROM product_image WHERE product_id ='74' ORDER BY sort_order ASC;
450.0008 ControllerEventCompatibilitySELECT pq.warehouse_id as warehouse_id, pq.quantity as quantity, w.name as name FROM product_quantity pq LEFT JOIN warehouse w ON (pq.warehouse_id = w.warehouse_id) WHERE pq.product_id = '74' AND w.status = '1'
460.0006 ControllerEventCompatibilitySELECT * FROM module WHERE module_id = '184'
470.0025 ControllerEventCompatibilitySHOW TABLES LIKE 'simple_blog_article'
480.0011 ControllerEventCompatibilitySELECT * FROM simple_blog_category WHERE simple_blog_category_id ='1' ORDER BY sort_order ASC;
490.0005 ControllerEventCompatibilitySELECT * FROM simple_blog_category WHERE parent_id ='1' AND status = '1' ORDER BY sort_order ASC;
500.0014 ControllerEventCompatibilitySELECT DISTINCT(simple_blog_article_id) FROM `simple_blog_article_to_category` WHERE simple_blog_category_id IN(1)
510.0015 ControllerEventCompatibility SELECT b.*,bd.article_title,bd.description, (SELECT COUNT(*) FROM simple_blog_comment bc WHERE bc.simple_blog_article_id = b.simple_blog_article_id) AS comment,(SELECT COUNT(*) FROM simple_blog_view bv WHERE bv.simple_blog_article_id = b.simple_blog_article_id) AS view FROM simple_blog_article b LEFT JOIN simple_blog_article_description bd ON b.simple_blog_article_id=bd.simple_blog_article_id and bd.language_id=1 WHERE b.status = '1' AND bd.language_id=1 AND b.simple_blog_article_id IN(1,2,3) ORDER BY bd.article_title ASC LIMIT 0,6
520.0006 ControllerEventCompatibilitySELECT * FROM `user`
530.0006 ControllerEventCompatibilitySELECT * FROM module WHERE module_id = '182'
540.0004 ControllerEventCompatibilitySELECT * FROM module WHERE module_id = '187'
550.0004 ControllerEventCompatibilitySELECT * FROM module WHERE module_id = '129'
560.001 ControllerEventCompatibilitySELECT DISTINCT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '20' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
570.0004 ControllerEventCompatibilitySELECT DISTINCT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '18' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
580.0006 ControllerEventCompatibilitySELECT DISTINCT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '57' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
590.0006 ControllerEventCompatibilitySELECT DISTINCT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '17' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
600.0005 ControllerEventCompatibilitySELECT DISTINCT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '25' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
610.0005 ControllerEventCompatibilitySELECT * FROM category c LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id ='20' AND c.status = 1 AND c2s.store_id = '0' ORDER BY sort_order ASC;
620.0004 ControllerEventCompatibilitySELECT * FROM category c LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id ='18' AND c.status = 1 AND c2s.store_id = '0' ORDER BY sort_order ASC;
630.0004 ControllerEventCompatibilitySELECT * FROM category c LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id ='57' AND c.status = 1 AND c2s.store_id = '0' ORDER BY sort_order ASC;
640.0004 ControllerEventCompatibilitySELECT * FROM category c LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id ='17' AND c.status = 1 AND c2s.store_id = '0' ORDER BY sort_order ASC;
650.0005 ControllerEventCompatibilitySELECT * FROM category c LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id ='25' AND c.status = 1 AND c2s.store_id = '0' ORDER BY sort_order ASC;
660.0049 ControllerEventCompatibilitySELECT cp.category_id AS category_id, GROUP_CONCAT(cd1.name ORDER BY cp.level SEPARATOR '  >  ') AS name, c1.parent_id, c1.sort_order FROM category_path cp LEFT JOIN category c1 ON (cp.category_id = c1.category_id) LEFT JOIN category c2 ON (cp.path_id = c2.category_id) LEFT JOIN category_description cd1 ON (cp.path_id = cd1.category_id) LEFT JOIN category_description cd2 ON (cp.category_id = cd2.category_id) LEFT JOIN category_to_store c2s ON (c1.category_id = c2s.category_id) WHERE c1.parent_id IN (20,18,57,17,25) AND cd1.language_id = '1' AND cd2.language_id = '1' AND c1.status = 1 AND c2s.store_id = '0' GROUP BY cp.category_id ORDER BY sort_order ASC
670.0032 ControllerEventCompatibilitySELECT cp.category_id AS category_id, GROUP_CONCAT(cd1.name ORDER BY cp.level SEPARATOR '  >  ') AS name, c1.parent_id, c1.sort_order FROM category_path cp LEFT JOIN category c1 ON (cp.category_id = c1.category_id) LEFT JOIN category c2 ON (cp.path_id = c2.category_id) LEFT JOIN category_description cd1 ON (cp.path_id = cd1.category_id) LEFT JOIN category_description cd2 ON (cp.category_id = cd2.category_id) LEFT JOIN category_to_store c2s ON (c1.category_id = c2s.category_id) WHERE c1.parent_id IN (20,18,57,17,25,64,73,81,86,65,74,82,87,66,83,88,67,84,89,91,105,98,100,101,104) AND cd1.language_id = '1' AND cd2.language_id = '1' AND c1.status = 1 AND c2s.store_id = '0' GROUP BY cp.category_id ORDER BY sort_order ASC
680.003 ControllerEventCompatibilitySELECT cp.category_id AS category_id, GROUP_CONCAT(cd1.name ORDER BY cp.level SEPARATOR '  >  ') AS name, c1.parent_id, c1.sort_order FROM category_path cp LEFT JOIN category c1 ON (cp.category_id = c1.category_id) LEFT JOIN category c2 ON (cp.path_id = c2.category_id) LEFT JOIN category_description cd1 ON (cp.path_id = cd1.category_id) LEFT JOIN category_description cd2 ON (cp.category_id = cd2.category_id) LEFT JOIN category_to_store c2s ON (c1.category_id = c2s.category_id) WHERE c1.parent_id IN (20,18,57,17,25,64,73,81,86,65,74,82,87,66,83,88,67,84,89,91,105,98,100,101,104) AND cd1.language_id = '1' AND cd2.language_id = '1' AND c1.status = 1 AND c2s.store_id = '0' GROUP BY cp.category_id ORDER BY sort_order ASC
690.0066 ControllerEventCompatibilitySELECT COUNT(DISTINCT p.product_id) AS total FROM product_to_category p2c LEFT JOIN product p ON (p2c.product_id = p.product_id) INNER JOIN product_special ps ON (ps.product_id = p.product_id) 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 ps.date_start != '0000-00-00' AND ps.date_end != '0000-00-00' AND ps.price != '0.0000' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id IN (20,18,57,17,25,64,73,81,86,65,74,82,87,66,83,88,67,84,89,91,105,98,100,101,104)
700.0644 ControllerEventCompatibilitySELECT 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' AND pd2.date_start <= NOW()) AND (pd2.date_end != '0000-00-00' AND 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' AND ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' AND ps.date_end > NOW())) ORDER BY ps.price ASC LIMIT 1) AS special, (SELECT date_start 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 < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS date_start, (SELECT date_end 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 < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS date_end,(SELECT SUM(op.quantity) AS total FROM order_product op LEFT JOIN `order` o ON (op.order_id = o.order_id) WHERE o.order_status_id > '0' AND op.product_id = p.product_id GROUP BY op.product_id ORDER BY total) AS sales FROM product_to_category p2c LEFT JOIN product p ON (p2c.product_id = p.product_id) INNER JOIN product_special ps ON (ps.product_id = p.product_id) 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 ps.date_start != '0000-00-00' AND ps.date_start <= NOW() AND ps.date_end != '0000-00-00' AND ps.price != '0.0000' AND ps.date_end > NOW() AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.status = 1 AND p2c.category_id IN (20,18,57,17,25,64,73,81,86,65,74,82,87,66,83,88,67,84,89,91,105,98,100,101,104) GROUP BY p.product_id ORDER BY (CASE WHEN special IS NOT NULL THEN special WHEN discount IS NOT NULL THEN discount ELSE p.price END) ASC, LCASE(pd.name) ASC LIMIT 0,8
710.004 ControllerEventCompatibilitySELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name FROM manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') 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 < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM product_reward pr WHERE pr.product_id = p.product_id AND 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 = '74' AND pd.language_id = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
720.0031 ControllerEventCompatibilitySELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name FROM manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') 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 < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM product_reward pr WHERE pr.product_id = p.product_id AND 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 = '179' AND pd.language_id = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
730.0008 ControllerEventCompatibilitySELECT * FROM product_image WHERE product_id = '74' ORDER BY sort_order ASC
740.0011 ControllerEventCompatibilitySELECT pq.warehouse_id as warehouse_id, pq.quantity as quantity, w.name as name FROM product_quantity pq LEFT JOIN warehouse w ON (pq.warehouse_id = w.warehouse_id) WHERE pq.product_id = '74' AND w.status = '1'
750.0004 ControllerEventCompatibilitySELECT * FROM product_image WHERE product_id = '179' ORDER BY sort_order ASC
760.0006 ControllerEventCompatibilitySELECT pq.warehouse_id as warehouse_id, pq.quantity as quantity, w.name as name FROM product_quantity pq LEFT JOIN warehouse w ON (pq.warehouse_id = w.warehouse_id) WHERE pq.product_id = '179' AND w.status = '1'
770.0005 ControllerEventCompatibilitySELECT * FROM module WHERE module_id = '130'
780.0013 ControllerEventCompatibilitySELECT DISTINCT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '20' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
790.0028 ControllerEventCompatibilitySELECT cp.category_id AS category_id, GROUP_CONCAT(cd1.name ORDER BY cp.level SEPARATOR '  >  ') AS name, c1.parent_id, c1.sort_order FROM category_path cp LEFT JOIN category c1 ON (cp.category_id = c1.category_id) LEFT JOIN category c2 ON (cp.path_id = c2.category_id) LEFT JOIN category_description cd1 ON (cp.path_id = cd1.category_id) LEFT JOIN category_description cd2 ON (cp.category_id = cd2.category_id) LEFT JOIN category_to_store c2s ON (c1.category_id = c2s.category_id) WHERE c1.parent_id = '20' AND cd1.language_id = '1' AND cd2.language_id = '1' AND c1.status = 1 AND c2s.store_id = '0' GROUP BY cp.category_id ORDER BY sort_order ASC
800.0048 ControllerEventCompatibilitySELECT COUNT(DISTINCT p.product_id) AS total FROM product_to_category p2c LEFT JOIN product p ON (p2c.product_id = p.product_id) 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 <= NOW() AND p2s.store_id = '0' AND p2c.category_id IN (20,73,74)
810.0048 ControllerEventCompatibilitySELECT p.product_id, p.type, (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 < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special FROM product_to_category p2c LEFT JOIN product p ON (p2c.product_id = p.product_id) 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 <= NOW() AND p2s.store_id = '0' AND p2c.category_id IN (20,73,74) GROUP BY p.product_id ORDER BY LCASE(pd.name) ASC, LCASE(pd.name) ASC LIMIT 0,8
820.0031 ControllerEventCompatibilitySELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name FROM manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') 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 < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM product_reward pr WHERE pr.product_id = p.product_id AND 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 = '179' AND pd.language_id = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
830.0034 ControllerEventCompatibilitySELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name FROM manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') 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 < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM product_reward pr WHERE pr.product_id = p.product_id AND 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 = '74' AND pd.language_id = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
840.0027 ControllerEventCompatibilitySELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name FROM manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') 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 < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM product_reward pr WHERE pr.product_id = p.product_id AND 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 = '88' AND pd.language_id = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
850.0024 ControllerEventCompatibilitySELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name FROM manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') 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 < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM product_reward pr WHERE pr.product_id = p.product_id AND 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 = '89' AND pd.language_id = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
860.0005 ControllerEventCompatibilitySELECT * FROM product_image WHERE product_id = '179' ORDER BY sort_order ASC
870.0009 ControllerEventCompatibilitySELECT pq.warehouse_id as warehouse_id, pq.quantity as quantity, w.name as name FROM product_quantity pq LEFT JOIN warehouse w ON (pq.warehouse_id = w.warehouse_id) WHERE pq.product_id = '179' AND w.status = '1'
880.0004 ControllerEventCompatibilitySELECT * FROM product_image WHERE product_id = '74' ORDER BY sort_order ASC
890.0007 ControllerEventCompatibilitySELECT pq.warehouse_id as warehouse_id, pq.quantity as quantity, w.name as name FROM product_quantity pq LEFT JOIN warehouse w ON (pq.warehouse_id = w.warehouse_id) WHERE pq.product_id = '74' AND w.status = '1'
900.0004 ControllerEventCompatibilitySELECT * FROM product_image WHERE product_id = '88' ORDER BY sort_order ASC
910.0008 ControllerEventCompatibilitySELECT pq.warehouse_id as warehouse_id, pq.quantity as quantity, w.name as name FROM product_quantity pq LEFT JOIN warehouse w ON (pq.warehouse_id = w.warehouse_id) WHERE pq.product_id = '88' AND w.status = '1'
920.0004 ControllerEventCompatibilitySELECT * FROM product_image WHERE product_id = '89' ORDER BY sort_order ASC
930.0008 ControllerEventCompatibilitySELECT pq.warehouse_id as warehouse_id, pq.quantity as quantity, w.name as name FROM product_quantity pq LEFT JOIN warehouse w ON (pq.warehouse_id = w.warehouse_id) WHERE pq.product_id = '89' AND w.status = '1'
940.0011 ControllerEventCompatibilitySELECT DISTINCT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '20' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
950.0025 ControllerEventCompatibilitySELECT cp.category_id AS category_id, c1.parent_id, c1.sort_order FROM category_path cp LEFT JOIN category c1 ON (cp.category_id = c1.category_id) LEFT JOIN category c2 ON (cp.path_id = c2.category_id) LEFT JOIN category_description cd1 ON (cp.path_id = cd1.category_id) LEFT JOIN category_description cd2 ON (cp.category_id = cd2.category_id) LEFT JOIN category_to_store c2s ON (c1.category_id = c2s.category_id) WHERE cp.path_id = '20' AND cp.path_id != cp.category_id AND cd1.language_id = '1' AND cd2.language_id = '1' AND c1.status = 1 AND c2s.store_id = '0' GROUP BY cp.category_id ORDER BY cp.level ASC LIMIT 0,5
960.0006 ControllerEventCompatibilitySELECT DISTINCT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '73' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
970.0046 ControllerEventCompatibilitySELECT COUNT(DISTINCT p.product_id) AS total FROM product_to_category p2c LEFT JOIN product p ON (p2c.product_id = p.product_id) 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 <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '73'
980.0011 ControllerEventCompatibilitySELECT DISTINCT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '74' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
990.0039 ControllerEventCompatibilitySELECT COUNT(DISTINCT p.product_id) AS total FROM product_to_category p2c LEFT JOIN product p ON (p2c.product_id = p.product_id) 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 <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '74'
1000.001 ControllerEventCompatibilitySELECT DISTINCT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '73' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
1010.0017 ControllerEventCompatibilitySELECT cp.category_id AS category_id, c1.parent_id, c1.sort_order FROM category_path cp LEFT JOIN category c1 ON (cp.category_id = c1.category_id) LEFT JOIN category c2 ON (cp.path_id = c2.category_id) LEFT JOIN category_description cd1 ON (cp.path_id = cd1.category_id) LEFT JOIN category_description cd2 ON (cp.category_id = cd2.category_id) LEFT JOIN category_to_store c2s ON (c1.category_id = c2s.category_id) WHERE cp.path_id = '73' AND cp.path_id != cp.category_id AND cd1.language_id = '1' AND cd2.language_id = '1' AND c1.status = 1 AND c2s.store_id = '0' GROUP BY cp.category_id ORDER BY cp.level ASC LIMIT 0,5
1020.0006 ControllerEventCompatibilitySELECT DISTINCT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '74' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
1030.0015 ControllerEventCompatibilitySELECT cp.category_id AS category_id, c1.parent_id, c1.sort_order FROM category_path cp LEFT JOIN category c1 ON (cp.category_id = c1.category_id) LEFT JOIN category c2 ON (cp.path_id = c2.category_id) LEFT JOIN category_description cd1 ON (cp.path_id = cd1.category_id) LEFT JOIN category_description cd2 ON (cp.category_id = cd2.category_id) LEFT JOIN category_to_store c2s ON (c1.category_id = c2s.category_id) WHERE cp.path_id = '74' AND cp.path_id != cp.category_id AND cd1.language_id = '1' AND cd2.language_id = '1' AND c1.status = 1 AND c2s.store_id = '0' GROUP BY cp.category_id ORDER BY cp.level ASC LIMIT 0,5
1040.0006 ControllerEventCompatibilitySELECT DISTINCT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '20' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
1050.0025 ControllerEventCompatibilitySELECT cp.category_id AS category_id, c1.parent_id, c1.sort_order FROM category_path cp LEFT JOIN category c1 ON (cp.category_id = c1.category_id) LEFT JOIN category c2 ON (cp.path_id = c2.category_id) LEFT JOIN category_description cd1 ON (cp.path_id = cd1.category_id) LEFT JOIN category_description cd2 ON (cp.category_id = cd2.category_id) LEFT JOIN category_to_store c2s ON (c1.category_id = c2s.category_id) WHERE cp.path_id = '20' AND cp.path_id != cp.category_id AND cd1.language_id = '1' AND cd2.language_id = '1' AND c1.status = 1 AND c2s.store_id = '0' GROUP BY cp.category_id ORDER BY cp.level ASC LIMIT 0,5
1060.001 ControllerEventCompatibilitySELECT DISTINCT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '73' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
1070.0046 ControllerEventCompatibilitySELECT COUNT(DISTINCT p.product_id) AS total FROM product_to_category p2c LEFT JOIN product p ON (p2c.product_id = p.product_id) 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 <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '73'
1080.0009 ControllerEventCompatibilitySELECT DISTINCT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '74' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
1090.0043 ControllerEventCompatibilitySELECT COUNT(DISTINCT p.product_id) AS total FROM product_to_category p2c LEFT JOIN product p ON (p2c.product_id = p.product_id) 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 <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '74'
1100.0006 ControllerEventCompatibilitySELECT * FROM module WHERE module_id = '133'
1110.0011 ControllerEventCompatibilitySELECT DISTINCT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '25' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
1120.0031 ControllerEventCompatibilitySELECT cp.category_id AS category_id, GROUP_CONCAT(cd1.name ORDER BY cp.level SEPARATOR '  >  ') AS name, c1.parent_id, c1.sort_order FROM category_path cp LEFT JOIN category c1 ON (cp.category_id = c1.category_id) LEFT JOIN category c2 ON (cp.path_id = c2.category_id) LEFT JOIN category_description cd1 ON (cp.path_id = cd1.category_id) LEFT JOIN category_description cd2 ON (cp.category_id = cd2.category_id) LEFT JOIN category_to_store c2s ON (c1.category_id = c2s.category_id) WHERE c1.parent_id = '25' AND cd1.language_id = '1' AND cd2.language_id = '1' AND c1.status = 1 AND c2s.store_id = '0' GROUP BY cp.category_id ORDER BY sort_order ASC
1130.0047 ControllerEventCompatibilitySELECT COUNT(DISTINCT p.product_id) AS total FROM product_to_category p2c LEFT JOIN product p ON (p2c.product_id = p.product_id) 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 <= NOW() AND p2s.store_id = '0' AND p2c.category_id IN (25,64,65,66,67,105,98,104)
1140.006 ControllerEventCompatibilitySELECT p.product_id, p.type, (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 < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special FROM product_to_category p2c LEFT JOIN product p ON (p2c.product_id = p.product_id) 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 <= NOW() AND p2s.store_id = '0' AND p2c.category_id IN (25,64,65,66,67,105,98,104) GROUP BY p.product_id ORDER BY (CASE WHEN special IS NOT NULL THEN special WHEN discount IS NOT NULL THEN discount ELSE p.price END) ASC, LCASE(pd.name) ASC LIMIT 0,20
1150.0031 ControllerEventCompatibilitySELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name FROM manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') 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 < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM product_reward pr WHERE pr.product_id = p.product_id AND 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 = '106' AND pd.language_id = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
1160.0024 ControllerEventCompatibilitySELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name FROM manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') 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 < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM product_reward pr WHERE pr.product_id = p.product_id AND 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 = '178' AND pd.language_id = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
1170.0028 ControllerEventCompatibilitySELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name FROM manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') 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 < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM product_reward pr WHERE pr.product_id = p.product_id AND 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 = '103' AND pd.language_id = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
1180.0026 ControllerEventCompatibilitySELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name FROM manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') 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 < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM product_reward pr WHERE pr.product_id = p.product_id AND 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 = '104' AND pd.language_id = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
1190.0026 ControllerEventCompatibilitySELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name FROM manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') 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 < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM product_reward pr WHERE pr.product_id = p.product_id AND 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 = '112' AND pd.language_id = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
1200.0027 ControllerEventCompatibilitySELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name FROM manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') 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 < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM product_reward pr WHERE pr.product_id = p.product_id AND 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 = '108' AND pd.language_id = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
1210.0024 ControllerEventCompatibilitySELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name FROM manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') 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 < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM product_reward pr WHERE pr.product_id = p.product_id AND 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 = '142' AND pd.language_id = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
1220.0029 ControllerEventCompatibilitySELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name FROM manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') 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 < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM product_reward pr WHERE pr.product_id = p.product_id AND 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 = '143' AND pd.language_id = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
1230.0027 ControllerEventCompatibilitySELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name FROM manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') 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 < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM product_reward pr WHERE pr.product_id = p.product_id AND 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 = '109' AND pd.language_id = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
1240.0026 ControllerEventCompatibilitySELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name FROM manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') 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 < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM product_reward pr WHERE pr.product_id = p.product_id AND 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 = '166' AND pd.language_id = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
1250.0027 ControllerEventCompatibilitySELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name FROM manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') 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 < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM product_reward pr WHERE pr.product_id = p.product_id AND 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 = '147' AND pd.language_id = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
1260.0026 ControllerEventCompatibilitySELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name FROM manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') 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 < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM product_reward pr WHERE pr.product_id = p.product_id AND 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 = '173' AND pd.language_id = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
1270.0024 ControllerEventCompatibilitySELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name FROM manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') 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 < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM product_reward pr WHERE pr.product_id = p.product_id AND 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 = '113' AND pd.language_id = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
1280.0024 ControllerEventCompatibilitySELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name FROM manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') 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 < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM product_reward pr WHERE pr.product_id = p.product_id AND 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 = '110' AND pd.language_id = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
1290.0026 ControllerEventCompatibilitySELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name FROM manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') 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 < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM product_reward pr WHERE pr.product_id = p.product_id AND 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 = '117' AND pd.language_id = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
1300.0027 ControllerEventCompatibilitySELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name FROM manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') 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 < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM product_reward pr WHERE pr.product_id = p.product_id AND 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 = '93' AND pd.language_id = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
1310.0026 ControllerEventCompatibilitySELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name FROM manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') 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 < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM product_reward pr WHERE pr.product_id = p.product_id AND 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 = '111' AND pd.language_id = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
1320.0025 ControllerEventCompatibilitySELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name FROM manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') 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 < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM product_reward pr WHERE pr.product_id = p.product_id AND 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 = '116' AND pd.language_id = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
1330.0025 ControllerEventCompatibilitySELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name FROM manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') 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 < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM product_reward pr WHERE pr.product_id = p.product_id AND 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 = '115' AND pd.language_id = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
1340.0025 ControllerEventCompatibilitySELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name FROM manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') 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 < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM product_reward pr WHERE pr.product_id = p.product_id AND 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 = '105' AND pd.language_id = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
1350.0008 ControllerEventCompatibilitySELECT * FROM product_image WHERE product_id = '106' ORDER BY sort_order ASC
1360.001 ControllerEventCompatibilitySELECT pq.warehouse_id as warehouse_id, pq.quantity as quantity, w.name as name FROM product_quantity pq LEFT JOIN warehouse w ON (pq.warehouse_id = w.warehouse_id) WHERE pq.product_id = '106' AND w.status = '1'
1370.0005 ControllerEventCompatibilitySELECT * FROM product_image WHERE product_id = '178' ORDER BY sort_order ASC
1380.0008 ControllerEventCompatibilitySELECT pq.warehouse_id as warehouse_id, pq.quantity as quantity, w.name as name FROM product_quantity pq LEFT JOIN warehouse w ON (pq.warehouse_id = w.warehouse_id) WHERE pq.product_id = '178' AND w.status = '1'
1390.0005 ControllerEventCompatibilitySELECT * FROM product_image WHERE product_id = '103' ORDER BY sort_order ASC
1400.0008 ControllerEventCompatibilitySELECT pq.warehouse_id as warehouse_id, pq.quantity as quantity, w.name as name FROM product_quantity pq LEFT JOIN warehouse w ON (pq.warehouse_id = w.warehouse_id) WHERE pq.product_id = '103' AND w.status = '1'
1410.0005 ControllerEventCompatibilitySELECT * FROM product_image WHERE product_id = '104' ORDER BY sort_order ASC
1420.0008 ControllerEventCompatibilitySELECT pq.warehouse_id as warehouse_id, pq.quantity as quantity, w.name as name FROM product_quantity pq LEFT JOIN warehouse w ON (pq.warehouse_id = w.warehouse_id) WHERE pq.product_id = '104' AND w.status = '1'
1430.0005 ControllerEventCompatibilitySELECT * FROM product_image WHERE product_id = '112' ORDER BY sort_order ASC
1440.0008 ControllerEventCompatibilitySELECT pq.warehouse_id as warehouse_id, pq.quantity as quantity, w.name as name FROM product_quantity pq LEFT JOIN warehouse w ON (pq.warehouse_id = w.warehouse_id) WHERE pq.product_id = '112' AND w.status = '1'
1450.0005 ControllerEventCompatibilitySELECT * FROM product_image WHERE product_id = '108' ORDER BY sort_order ASC
1460.0008 ControllerEventCompatibilitySELECT pq.warehouse_id as warehouse_id, pq.quantity as quantity, w.name as name FROM product_quantity pq LEFT JOIN warehouse w ON (pq.warehouse_id = w.warehouse_id) WHERE pq.product_id = '108' AND w.status = '1'
1470.0005 ControllerEventCompatibilitySELECT * FROM product_image WHERE product_id = '142' ORDER BY sort_order ASC
1480.0008 ControllerEventCompatibilitySELECT pq.warehouse_id as warehouse_id, pq.quantity as quantity, w.name as name FROM product_quantity pq LEFT JOIN warehouse w ON (pq.warehouse_id = w.warehouse_id) WHERE pq.product_id = '142' AND w.status = '1'
1490.0005 ControllerEventCompatibilitySELECT * FROM product_image WHERE product_id = '143' ORDER BY sort_order ASC
1500.0006 ControllerEventCompatibilitySELECT pq.warehouse_id as warehouse_id, pq.quantity as quantity, w.name as name FROM product_quantity pq LEFT JOIN warehouse w ON (pq.warehouse_id = w.warehouse_id) WHERE pq.product_id = '143' AND w.status = '1'
1510.0005 ControllerEventCompatibilitySELECT * FROM product_image WHERE product_id = '109' ORDER BY sort_order ASC
1520.0008 ControllerEventCompatibilitySELECT pq.warehouse_id as warehouse_id, pq.quantity as quantity, w.name as name FROM product_quantity pq LEFT JOIN warehouse w ON (pq.warehouse_id = w.warehouse_id) WHERE pq.product_id = '109' AND w.status = '1'
1530.0005 ControllerEventCompatibilitySELECT * FROM product_image WHERE product_id = '166' ORDER BY sort_order ASC
1540.0008 ControllerEventCompatibilitySELECT pq.warehouse_id as warehouse_id, pq.quantity as quantity, w.name as name FROM product_quantity pq LEFT JOIN warehouse w ON (pq.warehouse_id = w.warehouse_id) WHERE pq.product_id = '166' AND w.status = '1'
1550.0005 ControllerEventCompatibilitySELECT * FROM product_image WHERE product_id = '147' ORDER BY sort_order ASC
1560.0008 ControllerEventCompatibilitySELECT pq.warehouse_id as warehouse_id, pq.quantity as quantity, w.name as name FROM product_quantity pq LEFT JOIN warehouse w ON (pq.warehouse_id = w.warehouse_id) WHERE pq.product_id = '147' AND w.status = '1'
1570.0005 ControllerEventCompatibilitySELECT * FROM product_image WHERE product_id = '173' ORDER BY sort_order ASC
1580.0008 ControllerEventCompatibilitySELECT pq.warehouse_id as warehouse_id, pq.quantity as quantity, w.name as name FROM product_quantity pq LEFT JOIN warehouse w ON (pq.warehouse_id = w.warehouse_id) WHERE pq.product_id = '173' AND w.status = '1'
1590.0005 ControllerEventCompatibilitySELECT * FROM product_image WHERE product_id = '113' ORDER BY sort_order ASC
1600.0008 ControllerEventCompatibilitySELECT pq.warehouse_id as warehouse_id, pq.quantity as quantity, w.name as name FROM product_quantity pq LEFT JOIN warehouse w ON (pq.warehouse_id = w.warehouse_id) WHERE pq.product_id = '113' AND w.status = '1'
1610.0005 ControllerEventCompatibilitySELECT * FROM product_image WHERE product_id = '110' ORDER BY sort_order ASC
1620.0008 ControllerEventCompatibilitySELECT pq.warehouse_id as warehouse_id, pq.quantity as quantity, w.name as name FROM product_quantity pq LEFT JOIN warehouse w ON (pq.warehouse_id = w.warehouse_id) WHERE pq.product_id = '110' AND w.status = '1'
1630.0005 ControllerEventCompatibilitySELECT * FROM product_image WHERE product_id = '117' ORDER BY sort_order ASC
1640.0007 ControllerEventCompatibilitySELECT pq.warehouse_id as warehouse_id, pq.quantity as quantity, w.name as name FROM product_quantity pq LEFT JOIN warehouse w ON (pq.warehouse_id = w.warehouse_id) WHERE pq.product_id = '117' AND w.status = '1'
1650.0005 ControllerEventCompatibilitySELECT * FROM product_image WHERE product_id = '93' ORDER BY sort_order ASC
1660.0006 ControllerEventCompatibilitySELECT pq.warehouse_id as warehouse_id, pq.quantity as quantity, w.name as name FROM product_quantity pq LEFT JOIN warehouse w ON (pq.warehouse_id = w.warehouse_id) WHERE pq.product_id = '93' AND w.status = '1'
1670.0005 ControllerEventCompatibilitySELECT * FROM product_image WHERE product_id = '111' ORDER BY sort_order ASC
1680.0007 ControllerEventCompatibilitySELECT pq.warehouse_id as warehouse_id, pq.quantity as quantity, w.name as name FROM product_quantity pq LEFT JOIN warehouse w ON (pq.warehouse_id = w.warehouse_id) WHERE pq.product_id = '111' AND w.status = '1'
1690.0005 ControllerEventCompatibilitySELECT * FROM product_image WHERE product_id = '116' ORDER BY sort_order ASC
1700.0006 ControllerEventCompatibilitySELECT pq.warehouse_id as warehouse_id, pq.quantity as quantity, w.name as name FROM product_quantity pq LEFT JOIN warehouse w ON (pq.warehouse_id = w.warehouse_id) WHERE pq.product_id = '116' AND w.status = '1'
1710.0006 ControllerEventCompatibilitySELECT * FROM product_image WHERE product_id = '115' ORDER BY sort_order ASC
1720.0007 ControllerEventCompatibilitySELECT pq.warehouse_id as warehouse_id, pq.quantity as quantity, w.name as name FROM product_quantity pq LEFT JOIN warehouse w ON (pq.warehouse_id = w.warehouse_id) WHERE pq.product_id = '115' AND w.status = '1'
1730.0005 ControllerEventCompatibilitySELECT * FROM product_image WHERE product_id = '105' ORDER BY sort_order ASC
1740.0006 ControllerEventCompatibilitySELECT pq.warehouse_id as warehouse_id, pq.quantity as quantity, w.name as name FROM product_quantity pq LEFT JOIN warehouse w ON (pq.warehouse_id = w.warehouse_id) WHERE pq.product_id = '105' AND w.status = '1'
1750.001 ControllerEventCompatibilitySELECT DISTINCT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '25' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
1760.0026 ControllerEventCompatibilitySELECT cp.category_id AS category_id, c1.parent_id, c1.sort_order FROM category_path cp LEFT JOIN category c1 ON (cp.category_id = c1.category_id) LEFT JOIN category c2 ON (cp.path_id = c2.category_id) LEFT JOIN category_description cd1 ON (cp.path_id = cd1.category_id) LEFT JOIN category_description cd2 ON (cp.category_id = cd2.category_id) LEFT JOIN category_to_store c2s ON (c1.category_id = c2s.category_id) WHERE cp.path_id = '25' AND cp.path_id != cp.category_id AND cd1.language_id = '1' AND cd2.language_id = '1' AND c1.status = 1 AND c2s.store_id = '0' GROUP BY cp.category_id ORDER BY cp.level ASC LIMIT 0,5
1770.0006 ControllerEventCompatibilitySELECT DISTINCT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '98' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
1780.0042 ControllerEventCompatibilitySELECT COUNT(DISTINCT p.product_id) AS total FROM product_to_category p2c LEFT JOIN product p ON (p2c.product_id = p.product_id) 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 <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '98'
1790.001 ControllerEventCompatibilitySELECT DISTINCT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '104' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
1800.0027 ControllerEventCompatibilitySELECT COUNT(DISTINCT p.product_id) AS total FROM product_to_category p2c LEFT JOIN product p ON (p2c.product_id = p.product_id) 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 <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '104'
1810.001 ControllerEventCompatibilitySELECT DISTINCT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '105' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
1820.0025 ControllerEventCompatibilitySELECT COUNT(DISTINCT p.product_id) AS total FROM product_to_category p2c LEFT JOIN product p ON (p2c.product_id = p.product_id) 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 <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '105'
1830.001 ControllerEventCompatibilitySELECT DISTINCT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '64' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
1840.0027 ControllerEventCompatibilitySELECT COUNT(DISTINCT p.product_id) AS total FROM product_to_category p2c LEFT JOIN product p ON (p2c.product_id = p.product_id) 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 <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '64'
1850.0011 ControllerEventCompatibilitySELECT DISTINCT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '65' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
1860.0028 ControllerEventCompatibilitySELECT COUNT(DISTINCT p.product_id) AS total FROM product_to_category p2c LEFT JOIN product p ON (p2c.product_id = p.product_id) 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 <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '65'
1870.0011 ControllerEventCompatibilitySELECT DISTINCT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '64' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
1880.0017 ControllerEventCompatibilitySELECT cp.category_id AS category_id, c1.parent_id, c1.sort_order FROM category_path cp LEFT JOIN category c1 ON (cp.category_id = c1.category_id) LEFT JOIN category c2 ON (cp.path_id = c2.category_id) LEFT JOIN category_description cd1 ON (cp.path_id = cd1.category_id) LEFT JOIN category_description cd2 ON (cp.category_id = cd2.category_id) LEFT JOIN category_to_store c2s ON (c1.category_id = c2s.category_id) WHERE cp.path_id = '64' AND cp.path_id != cp.category_id AND cd1.language_id = '1' AND cd2.language_id = '1' AND c1.status = 1 AND c2s.store_id = '0' GROUP BY cp.category_id ORDER BY cp.level ASC LIMIT 0,5
1890.0008 ControllerEventCompatibilitySELECT DISTINCT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '65' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
1900.0018 ControllerEventCompatibilitySELECT cp.category_id AS category_id, c1.parent_id, c1.sort_order FROM category_path cp LEFT JOIN category c1 ON (cp.category_id = c1.category_id) LEFT JOIN category c2 ON (cp.path_id = c2.category_id) LEFT JOIN category_description cd1 ON (cp.path_id = cd1.category_id) LEFT JOIN category_description cd2 ON (cp.category_id = cd2.category_id) LEFT JOIN category_to_store c2s ON (c1.category_id = c2s.category_id) WHERE cp.path_id = '65' AND cp.path_id != cp.category_id AND cd1.language_id = '1' AND cd2.language_id = '1' AND c1.status = 1 AND c2s.store_id = '0' GROUP BY cp.category_id ORDER BY cp.level ASC LIMIT 0,5
1910.0006 ControllerEventCompatibilitySELECT DISTINCT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '66' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
1920.0021 ControllerEventCompatibilitySELECT cp.category_id AS category_id, c1.parent_id, c1.sort_order FROM category_path cp LEFT JOIN category c1 ON (cp.category_id = c1.category_id) LEFT JOIN category c2 ON (cp.path_id = c2.category_id) LEFT JOIN category_description cd1 ON (cp.path_id = cd1.category_id) LEFT JOIN category_description cd2 ON (cp.category_id = cd2.category_id) LEFT JOIN category_to_store c2s ON (c1.category_id = c2s.category_id) WHERE cp.path_id = '66' AND cp.path_id != cp.category_id AND cd1.language_id = '1' AND cd2.language_id = '1' AND c1.status = 1 AND c2s.store_id = '0' GROUP BY cp.category_id ORDER BY cp.level ASC LIMIT 0,5
1930.0008 ControllerEventCompatibilitySELECT DISTINCT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '67' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
1940.0016 ControllerEventCompatibilitySELECT cp.category_id AS category_id, c1.parent_id, c1.sort_order FROM category_path cp LEFT JOIN category c1 ON (cp.category_id = c1.category_id) LEFT JOIN category c2 ON (cp.path_id = c2.category_id) LEFT JOIN category_description cd1 ON (cp.path_id = cd1.category_id) LEFT JOIN category_description cd2 ON (cp.category_id = cd2.category_id) LEFT JOIN category_to_store c2s ON (c1.category_id = c2s.category_id) WHERE cp.path_id = '67' AND cp.path_id != cp.category_id AND cd1.language_id = '1' AND cd2.language_id = '1' AND c1.status = 1 AND c2s.store_id = '0' GROUP BY cp.category_id ORDER BY cp.level ASC LIMIT 0,5
1950.0009 ControllerEventCompatibilitySELECT DISTINCT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '105' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
1960.0019 ControllerEventCompatibilitySELECT cp.category_id AS category_id, c1.parent_id, c1.sort_order FROM category_path cp LEFT JOIN category c1 ON (cp.category_id = c1.category_id) LEFT JOIN category c2 ON (cp.path_id = c2.category_id) LEFT JOIN category_description cd1 ON (cp.path_id = cd1.category_id) LEFT JOIN category_description cd2 ON (cp.category_id = cd2.category_id) LEFT JOIN category_to_store c2s ON (c1.category_id = c2s.category_id) WHERE cp.path_id = '105' AND cp.path_id != cp.category_id AND cd1.language_id = '1' AND cd2.language_id = '1' AND c1.status = 1 AND c2s.store_id = '0' GROUP BY cp.category_id ORDER BY cp.level ASC LIMIT 0,5
1970.0008 ControllerEventCompatibilitySELECT DISTINCT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '98' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
1980.0018 ControllerEventCompatibilitySELECT cp.category_id AS category_id, c1.parent_id, c1.sort_order FROM category_path cp LEFT JOIN category c1 ON (cp.category_id = c1.category_id) LEFT JOIN category c2 ON (cp.path_id = c2.category_id) LEFT JOIN category_description cd1 ON (cp.path_id = cd1.category_id) LEFT JOIN category_description cd2 ON (cp.category_id = cd2.category_id) LEFT JOIN category_to_store c2s ON (c1.category_id = c2s.category_id) WHERE cp.path_id = '98' AND cp.path_id != cp.category_id AND cd1.language_id = '1' AND cd2.language_id = '1' AND c1.status = 1 AND c2s.store_id = '0' GROUP BY cp.category_id ORDER BY cp.level ASC LIMIT 0,5
1990.0009 ControllerEventCompatibilitySELECT DISTINCT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '104' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
2000.0015 ControllerEventCompatibilitySELECT cp.category_id AS category_id, c1.parent_id, c1.sort_order FROM category_path cp LEFT JOIN category c1 ON (cp.category_id = c1.category_id) LEFT JOIN category c2 ON (cp.path_id = c2.category_id) LEFT JOIN category_description cd1 ON (cp.path_id = cd1.category_id) LEFT JOIN category_description cd2 ON (cp.category_id = cd2.category_id) LEFT JOIN category_to_store c2s ON (c1.category_id = c2s.category_id) WHERE cp.path_id = '104' AND cp.path_id != cp.category_id AND cd1.language_id = '1' AND cd2.language_id = '1' AND c1.status = 1 AND c2s.store_id = '0' GROUP BY cp.category_id ORDER BY cp.level ASC LIMIT 0,5
2010.0009 ControllerEventCompatibilitySELECT DISTINCT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '25' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
2020.0026 ControllerEventCompatibilitySELECT cp.category_id AS category_id, c1.parent_id, c1.sort_order FROM category_path cp LEFT JOIN category c1 ON (cp.category_id = c1.category_id) LEFT JOIN category c2 ON (cp.path_id = c2.category_id) LEFT JOIN category_description cd1 ON (cp.path_id = cd1.category_id) LEFT JOIN category_description cd2 ON (cp.category_id = cd2.category_id) LEFT JOIN category_to_store c2s ON (c1.category_id = c2s.category_id) WHERE cp.path_id = '25' AND cp.path_id != cp.category_id AND cd1.language_id = '1' AND cd2.language_id = '1' AND c1.status = 1 AND c2s.store_id = '0' GROUP BY cp.category_id ORDER BY cp.level ASC LIMIT 0,5
2030.0009 ControllerEventCompatibilitySELECT DISTINCT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '98' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
2040.0044 ControllerEventCompatibilitySELECT COUNT(DISTINCT p.product_id) AS total FROM product_to_category p2c LEFT JOIN product p ON (p2c.product_id = p.product_id) 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 <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '98'
2050.0011 ControllerEventCompatibilitySELECT DISTINCT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '104' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
2060.0044 ControllerEventCompatibilitySELECT COUNT(DISTINCT p.product_id) AS total FROM product_to_category p2c LEFT JOIN product p ON (p2c.product_id = p.product_id) 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 <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '104'
2070.0011 ControllerEventCompatibilitySELECT DISTINCT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '105' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
2080.0045 ControllerEventCompatibilitySELECT COUNT(DISTINCT p.product_id) AS total FROM product_to_category p2c LEFT JOIN product p ON (p2c.product_id = p.product_id) 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 <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '105'
2090.0011 ControllerEventCompatibilitySELECT DISTINCT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '64' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
2100.0084 ControllerEventCompatibilitySELECT COUNT(DISTINCT p.product_id) AS total FROM product_to_category p2c LEFT JOIN product p ON (p2c.product_id = p.product_id) 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 <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '64'
2110.0011 ControllerEventCompatibilitySELECT DISTINCT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '65' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
2120.0044 ControllerEventCompatibilitySELECT COUNT(DISTINCT p.product_id) AS total FROM product_to_category p2c LEFT JOIN product p ON (p2c.product_id = p.product_id) 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 <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '65'
2130.0006 ControllerEventCompatibilitySELECT * FROM module WHERE module_id = '193'
2140.0008 ControllerCommonContentBottomSELECT * FROM layout_route WHERE 'common/home' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
2150.0007 ControllerCommonContentBottomSELECT * FROM layout_module WHERE layout_id = '1' AND position = 'content_bottom' ORDER BY sort_order
2160.0004 ControllerEventCompatibilitySELECT * FROM module WHERE module_id = '247'
2170.0005 ControllerExtensionSoconfigContentFootertopSELECT * FROM layout_route WHERE 'common/home' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
2180.0007 ControllerExtensionSoconfigContentFootertopSELECT * FROM layout_module WHERE layout_id = '1' AND position = 'footertop' ORDER BY sort_order
2190.0004 ControllerEventCompatibilitySELECT * FROM module WHERE module_id = '178'
2200.0004 ControllerEventCompatibilitySELECT * FROM module WHERE module_id = '181'
2210.0004 ControllerExtensionSoconfigFooterblock1SELECT * FROM layout_route WHERE 'common/home' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
2220.0005 ControllerExtensionSoconfigFooterblock1SELECT * FROM layout_module WHERE layout_id = '1' AND position = 'footer_block1' ORDER BY sort_order
2230.0004 ControllerEventCompatibilitySELECT * FROM module WHERE module_id = '242'
2240.0005 ControllerExtensionSoconfigFooterblock2SELECT * FROM layout_route WHERE 'common/home' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
2250.0005 ControllerExtensionSoconfigFooterblock2SELECT * FROM layout_module WHERE layout_id = '1' AND position = 'footer_block2' ORDER BY sort_order
2260.0005 ControllerExtensionSoconfigFooterblock3SELECT * FROM layout_route WHERE 'common/home' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
2270.0005 ControllerExtensionSoconfigFooterblock3SELECT * FROM layout_module WHERE layout_id = '1' AND position = 'footer_block3' ORDER BY sort_order
2280.0004 ControllerExtensionSoconfigFooterblock4SELECT * FROM layout_route WHERE 'common/home' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
2290.0005 ControllerExtensionSoconfigFooterblock4SELECT * FROM layout_module WHERE layout_id = '1' AND position = 'footer_block4' ORDER BY sort_order
2300.0005 ControllerExtensionSoconfigFooterblock5SELECT * FROM layout_route WHERE 'common/home' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
2310.0005 ControllerExtensionSoconfigFooterblock5SELECT * FROM layout_module WHERE layout_id = '1' AND position = 'footer_block5' ORDER BY sort_order
2320.0005 ControllerExtensionSoconfigFooterblock6SELECT * FROM layout_route WHERE 'common/home' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
2330.0005 ControllerExtensionSoconfigFooterblock6SELECT * FROM layout_module WHERE layout_id = '1' AND position = 'footer_block6' ORDER BY sort_order
2340.0005 ControllerExtensionSoconfigContentFooterbottomSELECT * FROM layout_route WHERE 'common/home' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
2350.0005 ControllerExtensionSoconfigContentFooterbottomSELECT * FROM layout_module WHERE layout_id = '1' AND position = 'footerbottom' ORDER BY sort_order
2360.0034 ControllerEventThemeSELECT * 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 id.language_id = '1' AND i2s.store_id = '0' AND i.status = '1' ORDER BY i.sort_order, LCASE(id.title) ASC
2370.0007 ControllerEventThemeDELETE FROM `customer_online` WHERE date_added < '2021-03-02 07:31:42'
2380.0002 ControllerEventThemeREPLACE INTO `customer_online` SET `ip` = '3.239.192.241', `customer_id` = '0', `url` = 'http://robofor.ru/', `referer` = '', `date_added` = '2021-03-02 08:31:42'
2390.0024 ControllerEventThemeSHOW TABLES LIKE 'soconfig'
2400.0005 ControllerEventThemeselect * from soconfig where store_id='0'
2410.0006 ControllerCommonHeaderSELECT * FROM extension WHERE `type` = 'analytics'
2420.0006 ControllerExtensionSoconfigContentSearchSELECT * FROM layout_route WHERE 'common/home' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
2430.0007 ControllerExtensionSoconfigContentSearchSELECT * FROM layout_module WHERE layout_id = '1' AND position = 'content_search' ORDER BY sort_order
2440.0005 ControllerEventCompatibilitySELECT * FROM module WHERE module_id = '94'
2450.0024 ControllerEventCompatibilitySELECT * FROM category c LEFT JOIN category_description cd 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)
2460.0019 ControllerEventCompatibilitySELECT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '25' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
2470.0011 ControllerEventCompatibilitySELECT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '64' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
2480.0009 ControllerEventCompatibilitySELECT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '65' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
2490.0012 ControllerEventCompatibilitySELECT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '66' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
2500.0011 ControllerEventCompatibilitySELECT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '67' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
2510.0011 ControllerEventCompatibilitySELECT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '105' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
2520.0011 ControllerEventCompatibilitySELECT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '98' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
2530.0012 ControllerEventCompatibilitySELECT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '104' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
2540.0014 ControllerEventCompatibilitySELECT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '20' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
2550.0009 ControllerEventCompatibilitySELECT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '73' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
2560.0012 ControllerEventCompatibilitySELECT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '74' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
2570.0016 ControllerEventCompatibilitySELECT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '18' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
2580.0012 ControllerEventCompatibilitySELECT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '86' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
2590.0009 ControllerEventCompatibilitySELECT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '87' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
2600.0012 ControllerEventCompatibilitySELECT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '88' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
2610.0012 ControllerEventCompatibilitySELECT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '89' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
2620.0012 ControllerEventCompatibilitySELECT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '91' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
2630.0013 ControllerEventCompatibilitySELECT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '101' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
2640.0013 ControllerEventCompatibilitySELECT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '57' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
2650.0013 ControllerEventCompatibilitySELECT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '81' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
2660.0013 ControllerEventCompatibilitySELECT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '82' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
2670.0013 ControllerEventCompatibilitySELECT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '83' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
2680.0012 ControllerEventCompatibilitySELECT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '84' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
2690.001 ControllerEventCompatibilitySELECT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '100' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
2700.0012 ControllerEventCompatibilitySELECT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '17' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
2710.0012 ControllerEventCompatibilitySELECT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '93' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
2720.001 ControllerEventCompatibilitySELECT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '92' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
2730.0012 ControllerEventCompatibilitySELECT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '95' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
2740.001 ControllerEventCompatibilitySELECT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '99' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
2750.0012 ControllerEventCompatibilitySELECT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '96' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
2760.3043 ControllerEventCompatibilitySELECT 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 < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,(SELECT SUM(op.quantity) AS total FROM order_product op LEFT JOIN `order` o ON (op.order_id = o.order_id) WHERE o.order_status_id > '0' AND op.product_id = p.product_id GROUP BY op.product_id ORDER BY total) AS sales 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 <= NOW() AND p2s.store_id = '0' AND p.status = 1 GROUP BY p.product_id ORDER BY p.viewed DESC, LCASE(pd.name) DESC LIMIT 0,5
2770.0034 ControllerEventCompatibilitySELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name FROM manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') 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 < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM product_reward pr WHERE pr.product_id = p.product_id AND 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 = '74' AND pd.language_id = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
2780.0026 ControllerEventCompatibilitySELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name FROM manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') 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 < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM product_reward pr WHERE pr.product_id = p.product_id AND 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 = '89' AND pd.language_id = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
2790.0026 ControllerEventCompatibilitySELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name FROM manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') 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 < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM product_reward pr WHERE pr.product_id = p.product_id AND 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 = '88' AND pd.language_id = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
2800.0024 ControllerEventCompatibilitySELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name FROM manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') 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 < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM product_reward pr WHERE pr.product_id = p.product_id AND 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 = '147' AND pd.language_id = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
2810.0026 ControllerEventCompatibilitySELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name FROM manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') 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 < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM product_reward pr WHERE pr.product_id = p.product_id AND 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 = '103' AND pd.language_id = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
2820.0007 ControllerExtensionSoconfigContentMenuSELECT * FROM layout_route WHERE 'common/home' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
2830.0006 ControllerExtensionSoconfigContentMenuSELECT * FROM layout_module WHERE layout_id = '1' AND position = 'content_menu' ORDER BY sort_order
2840.0005 ControllerExtensionSoconfigContentMenu1SELECT * FROM layout_route WHERE 'common/home' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
2850.0007 ControllerExtensionSoconfigContentMenu1SELECT * FROM layout_module WHERE layout_id = '1' AND position = 'content_menu1' ORDER BY sort_order
2860.0008 ControllerEventCompatibilitySELECT * FROM module WHERE module_id = '124'
2870.0012 ControllerEventCompatibilitySELECT * FROM mega_menu WHERE parent_id='0' AND status='0' AND module_id = '124' ORDER BY rang
2880.0005 ControllerEventCompatibilitySELECT * FROM mega_menu WHERE parent_id='278' AND status='0' ORDER BY rang
2890.0011 ControllerEventCompatibilitySELECT DISTINCT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '64' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
2900.0004 ControllerEventCompatibilitySELECT DISTINCT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '25' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
2910.0006 ControllerEventCompatibilitySELECT DISTINCT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '65' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
2920.0006 ControllerEventCompatibilitySELECT DISTINCT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '25' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
2930.0004 ControllerEventCompatibilitySELECT DISTINCT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '66' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
2940.0004 ControllerEventCompatibilitySELECT DISTINCT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '25' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
2950.0006 ControllerEventCompatibilitySELECT DISTINCT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '67' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
2960.0006 ControllerEventCompatibilitySELECT DISTINCT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '25' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
2970.0006 ControllerEventCompatibilitySELECT DISTINCT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '105' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
2980.0006 ControllerEventCompatibilitySELECT DISTINCT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '25' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
2990.0006 ControllerEventCompatibilitySELECT DISTINCT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '98' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
3000.0004 ControllerEventCompatibilitySELECT DISTINCT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '25' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
3010.0008 ControllerEventCompatibilitySELECT DISTINCT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '104' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
3020.0008 ControllerEventCompatibilitySELECT DISTINCT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '25' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
3030.0025 ControllerEventCompatibilitySELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name FROM manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') 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 < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM product_reward pr WHERE pr.product_id = p.product_id AND 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 = '0' AND pd.language_id = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
3040.0009 ControllerEventCompatibilitySELECT * FROM mega_menu WHERE parent_id='287' AND status='0' ORDER BY rang
3050.0009 ControllerEventCompatibilitySELECT * FROM mega_menu WHERE parent_id='277' AND status='0' ORDER BY rang
3060.0011 ControllerEventCompatibilitySELECT DISTINCT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '73' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
3070.0008 ControllerEventCompatibilitySELECT DISTINCT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '20' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
3080.0007 ControllerEventCompatibilitySELECT DISTINCT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '74' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
3090.0008 ControllerEventCompatibilitySELECT DISTINCT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '20' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
3100.0004 ControllerEventCompatibilitySELECT DISTINCT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '97' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
3110.0006 ControllerEventCompatibilitySELECT DISTINCT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '103' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
3120.0025 ControllerEventCompatibilitySELECT DISTINCT *, pd.name AS name, p.image, (SELECT md.name FROM manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') 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 < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM product_reward pr WHERE pr.product_id = p.product_id AND 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 = '0' AND pd.language_id = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
3130.0007 ControllerEventCompatibilitySELECT * FROM mega_menu WHERE parent_id='289' AND status='0' ORDER BY rang
3140.0004 ControllerEventCompatibilitySELECT * FROM mega_menu WHERE parent_id='291' AND status='0' ORDER BY rang
3150.0004 ControllerEventCompatibilitySELECT * FROM mega_menu WHERE parent_id='279' AND status='0' ORDER BY rang
3160.0004 ControllerEventCompatibilitySELECT * FROM mega_menu WHERE parent_id='299' AND status='0' ORDER BY rang
3170.0004 ControllerEventCompatibilitySELECT * FROM mega_menu WHERE parent_id='280' AND status='0' ORDER BY rang
3180.0004 ControllerEventCompatibilitySELECT * FROM mega_menu WHERE parent_id='281' AND status='0' ORDER BY rang
3190.0004 ControllerEventCompatibilitySELECT * FROM mega_menu WHERE parent_id='283' AND status='0' ORDER BY rang
3200.0004 ControllerEventCompatibilitySELECT * FROM mega_menu WHERE parent_id='282' AND status='0' ORDER BY rang
3210.0005 ControllerExtensionSoconfigContentTopbarSELECT * FROM layout_route WHERE 'common/home' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
3220.0005 ControllerExtensionSoconfigContentTopbarSELECT * FROM layout_module WHERE layout_id = '1' AND position = 'content_topbar' ORDER BY sort_order
3230.0022 ControllerEventThemeSELECT * FROM category c LEFT JOIN category_description cd 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)
3240.0052 ControllerEventThemeSELECT COUNT(DISTINCT(sbc.simple_blog_category_id)) AS total FROM `simple_blog_category` sbc LEFT JOIN `simple_blog_category_description` sbcd ON(sbc.simple_blog_category_id=sbcd.simple_blog_category_id) LEFT JOIN `simple_blog_category_to_store` sbcs ON(sbc.simple_blog_category_id=sbcs.simple_blog_category_id) WHERE sbc.parent_id='0' AND sbcd.language_id='1' AND sbcs.store_id='0' AND sbc.status=1 ORDER BY sbc.sort_order, LCASE(sbcd.name)
3250.0016 ControllerEventThemeSELECT * FROM `simple_blog_category` sbc LEFT JOIN `simple_blog_category_description` sbcd ON(sbc.simple_blog_category_id=sbcd.simple_blog_category_id) LEFT JOIN `simple_blog_category_to_store` sbcs ON(sbc.simple_blog_category_id=sbcs.simple_blog_category_id) WHERE sbc.parent_id='0' AND sbcd.language_id='1' AND sbcs.store_id='0' AND sbc.status=1 ORDER BY sbc.sort_order, LCASE(sbcd.name)
3260.0018 ControllerEventThemeSELECT * FROM category c LEFT JOIN category_description cd 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)
3270.0014 ControllerEventThemeSELECT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '25' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
3280.0013 ControllerEventThemeSELECT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '20' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
3290.0013 ControllerEventThemeSELECT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '18' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
3300.0012 ControllerEventThemeSELECT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '57' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
3310.001 ControllerEventThemeSELECT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '17' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
3320.0009 ControllerCommonCartSELECT * FROM cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '5c8fc37ef8f72aebacfcd8db18354822'
3330.0005 ControllerCommonCartSELECT * FROM extension WHERE `type` = 'total'
3340.0004 ControllerEventCompatibilitySELECT * FROM cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '5c8fc37ef8f72aebacfcd8db18354822'
3350.0004 ControllerEventCompatibilitySELECT SUM(amount) AS total FROM customer_transaction WHERE customer_id = '0'
3360.0003 ControllerEventCompatibilitySELECT SUM(quantity) as total FROM cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '5c8fc37ef8f72aebacfcd8db18354822'
3370.0003 ControllerEventCompatibilitySELECT * FROM cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '5c8fc37ef8f72aebacfcd8db18354822'
3380.0023 ControllerEventThemeSHOW TABLES LIKE 'soconfig'
3390.0005 ControllerEventThemeselect * from soconfig where store_id='0'