WarCam

WarCam

Защитное стекло для магнитолы 10 дюймов
Защитное стекло для магнитолы 10 дюймов
900 р.
Актуальная модель Код товара: 159308
Защитное стекло имеет твердость 9Н. Это позволяет ему полноценно оберегать устройство от царапин, тр..
Защитное стекло для магнитолы 7 дюймов
Защитное стекло для магнитолы 7 дюймов
900 р.
Актуальная модель Код товара: 159309
Защитное стекло имеет твердость 9Н. Это позволяет ему полноценно оберегать устройство от царапин, тр..
Защитное стекло для магнитолы 9 дюймов
Защитное стекло для магнитолы 9 дюймов
900 р.
Актуальная модель Код товара: 159307
Защитное стекло имеет твердость 9Н. Это позволяет ему полноценно оберегать устройство от царапин, тр..
Зеркало + камера для Kia Sportage 10+, Rio X-Line 17+, Sorento 2,3, Mohave, Ceed, Carence, Opirus / Hyundai Elantra, Genesis, Sonata, Tucson, ix55
Зеркало + камера для Kia Sportage 10+, Rio X-Line 17+, Sorento 2,3, Mohave, Ceed, Carence, Opirus / Hyundai Elantra, Genesis, Sonata, Tucson, ix55
3 700 р.
Актуальная модель Код товара: 99288
Характеристики зеркала Экран Диагональ LCD монитора 4.3", TFT LCD Раз..
Зеркало + камера для Nissan Qashqai, X-trail, Pathfinder, Note, Juke, Navara, Sunny, Patrol - Peugeot 207 / 307 (хетч) / 308 / 3008 / 407 / 408 / 508 / RCZ - Volkswagen Crafter - Citroen C4 / C5 - Lifan X60
Зеркало + камера для Nissan Qashqai, X-trail, Pathfinder, Note, Juke, Navara, Sunny, Patrol - Peugeot 207 / 307 (хетч) / 308 / 3008 / 407 / 408 / 508 / RCZ - Volkswagen Crafter - Citroen C4 / C5 - Lifan X60
3 700 р.
Актуальная модель Код товара: 99292
Характеристики зеркала Экран Диагональ LCD монитора 4.3", TFT LCD Раз..
Зеркало + камера для Nissan X-Trail 2014+
Зеркало + камера для Nissan X-Trail 2014+
3 700 р.
Актуальная модель Код товара: 99371
Характеристики зеркала Экран Диагональ LCD монитора 4.3", TFT LCD Раз..
Зеркало + камера для Renault Fluence (09+), Kaptur (16+) / Nissan Terrano III 2014+
Зеркало + камера для Renault Fluence (09+), Kaptur (16+) / Nissan Terrano III 2014+
3 700 р.
Актуальная модель Код товара: 99355
Характеристики зеркала Экран Диагональ LCD монитора 4.3", TFT LCD Раз..
Зеркало монитор для камеры заднего вида CX-430
Зеркало монитор для камеры заднего вида CX-430
2 100 р.
Актуальная модель Код товара: 99270
Для клиентов из г. Москвы возможна установка от наших установочных центров. ​ ..
Зеркало монитор для камеры заднего вида CX-500
Зеркало монитор для камеры заднего вида CX-500
2 700 р.
Актуальная модель Код товара: 67003
Для клиентов из г. Москвы возможна установка от наших установочных центров. ​ ..
Кабель AUX (1 метр)
Кабель AUX (1 метр)
400 р.
Актуальная модель Код товара: 60180
Характеристики товара Производитель: КНР Экранирование: Фольга Тип: Витая пара Тип р..
Кабель AUX для автомагнитол RCA в 3.5 Jack
Кабель AUX для автомагнитол RCA в 3.5 Jack
500 р.
Актуальная модель Код товара: 66694
Характеристики товара Производитель: КНР Экранирование: Фольга Тип: Витая пара Тип р..
Кабель аудио/видео входа AVC38 для автомобилей Toyota 2011+, Lexus 2012+ (16 pin)
Кабель аудио/видео входа AVC38 для автомобилей Toyota 2011+, Lexus 2012+ (16 pin)
1 200 р.
Актуальная модель Код товара: 63461
Описание Кабель для организации видео и аудио входов на штаных аудиосистемах Кабель активации ..
Кабель для камеры заднего (переднего) вида 10 метров
Кабель для камеры заднего (переднего) вида 10 метров
800 р.
Актуальная модель Код товара: 59381
..
Кабель для камеры заднего (переднего) вида 6 метров
Кабель для камеры заднего (переднего) вида 6 метров
500 р.
Актуальная модель Код товара: 69511
..
Камера cam-132 Mercedes Sprinter / Volkswagen Crafter
Камера cam-132 Mercedes Sprinter / Volkswagen Crafter
7 300 р.
Актуальная модель Код товара: 54207
ПОДРОБНЫЕ ХАРАКТЕРИСТИКИ: Вид: Камера заднего вида ..
Камера Incar VDC-412 для Mercedes Sprinter, Volkswagen Crafter
Камера Incar VDC-412 для Mercedes Sprinter, Volkswagen Crafter
7 990 р.
Актуальная модель Код товара: 126299
Технические характеристики*   Сенсор (1030) color CMOS Разреш..
Кнопки на обод руля (10 кнопок)
Кнопки на обод руля (10 кнопок)
2 500 р.
Актуальная модель Код товара: 153659
Закрепляется на ободе рулевого колеса. Имеет 10 физических кнопок, которые можно запрограммировать н..
Кнопки на обод руля (6 кнопок)
Кнопки на обод руля (6 кнопок)
1 700 р.
Актуальная модель Код товара: 153658
Закрепляется на ободе рулевого колеса. Имеет 6 физических кнопок, которые можно запрограммировать на..
Металлические крепления для переноса корпуса магнитолы в горизонтальное положение
Металлические крепления для переноса корпуса магнитолы в горизонтальное положение (в комплекте шлейфы для удлинения)
Микрофон выносной громкой связи для автомагнитол
Микрофон выносной громкой связи для автомагнитол
450 р.
Актуальная модель Код товара: 96967
Технические характеристики: Длина кабеля: 1 метр Чувствительность:-46, +-2dB Направленност..
Монитор 4.3 дюйма + камера заднего вида для Kia Sportage 10+, Rio X-Line 17+, Sorento 2,3, Mohave, Ceed, Carence, Opirus / Hyundai Elantra, Genesis, Sonata, Tucson, ix55
Монитор 4.3 дюйма + камера заднего вида для Kia Sportage 10+, Rio X-Line 17+, Sorento 2,3, Mohave, Ceed, Carence, Opirus / Hyundai Elantra, Genesis, Sonata, Tucson, ix55
3 700 р.
Актуальная модель Код товара: 99622
Технические характеристики: Размер экрана: 4.3 дюймов Разрешение экрана: 480*272 Соотнош..
Монитор 4.3 дюйма + камера заднего вида для Renault Fluence (09+), Kaptur (16+) / Nissan Terrano III 2014+
Монитор 4.3 дюйма + камера заднего вида для Renault Fluence (09+), Kaptur (16+) / Nissan Terrano III 2014+
3 700 р.
Актуальная модель Код товара: 99567
Технические характеристики: Размер экрана: 4.3 дюймов Разрешение экрана: 480*272 Соотнош..
Монитор CX-431 4.3 дюйма для камеры заднего вида
Монитор CX-431 4.3 дюйма для камеры заднего вида
2 100 р.
Актуальная модель Код товара: 95807
Для клиентов из г. Москвы возможна установка от наших установочных центров. ​ Технические ..
Монитор CX-433 4.3 дюйма для камеры заднего вида складной
Монитор CX-433 4.3 дюйма для камеры заднего вида складной
2 300 р.
Актуальная модель Код товара: 99275
Автомобильный 2-х канальный LCD монитор для камеры заднего вида или автомобильного DVD плеера 4,3 дю..
Монитор CX-501 5 дюймов для камеры заднего вида
Монитор CX-501 5 дюймов для камеры заднего вида
2 500 р.
Актуальная модель Код товара: 99274
Для клиентов из г. Москвы возможна установка от наших установочных центров. ..
Набор инструментов для снятия пластика (4 съемника)
Набор инструментов для снятия пластика (4 съемника)
250 р.
Актуальная модель Код товара: 93897
Профессиональный набор инструментов для инсталляции мультимедийных систем. Набор состоит из 4 предме..
Переходная рамка для переноса бортового компьютера Chevrolet Aveo I, Captiva I, Epica I 2006-2012
Переходная рамка для переноса бортового компьютера Chevrolet Aveo I, Captiva I, Epica I 2006-2012
1 500 р.
Актуальная модель Код товара: 103528
..
Переходная рамка для переноса бортового компьютера Toyota Land Cruiser Prado 150 2009-2013
Переходная рамка для переноса бортового компьютера Toyota Land Cruiser Prado 150 2009-2013
4 800 р.
Актуальная модель Код товара: 38044
..
Подрулевой джойстик для автомагнитол (проводной)
Подрулевой джойстик для автомагнитол (проводной)
1 900 р.
Актуальная модель Код товара: 40772
Надежно крепится на кожух рулевой колонки (можно закрепить как слева, так и справа). Двухс..
Провод питания для камеры заднего вида
Провод питания для камеры заднего вида
200 р.
Актуальная модель Код товара: 63121
..
Проставочные кольца для динамиков 13 см
Проставочные кольца для динамиков 13 см
500 р.
Актуальная модель Код товара: 34974
..
Показано с 7457 по 7488 из 7933 (всего 248 страниц)

Total time: 0.3454 s | Queries: 265 | Slow queries (>0.003 s): 2

#Query time (s)ControllerQuery
10.001 SELECT value FROM oc_setting WHERE store_id = '0' AND `key`='config_seo_url_type'
20.0001 SET SQL_BIG_SELECTS = 1
30.0004 SHOW TABLES LIKE 'oc_ocfilter_setting'
40.0002 SELECT * FROM oc_ocfilter_setting
50.0001 ControllerStartupStartupSELECT * FROM oc_store WHERE REPLACE(`ssl`, 'www.', '') = 'https://warcam.ru/'
60.0021 ControllerStartupStartupSELECT * FROM `oc_setting` WHERE store_id = '0' OR store_id = '0' ORDER BY store_id ASC
70.0003 ControllerEventCompatibilitySELECT f1.offname f1_name, f1.shortname f1_shortname, f1.fias_id f1_fias_id, f1.level f1_level, f1.postalcode f1_postalcode, f2.offname f2_name, f2.shortname f2_shortname, f2.fias_id f2_fias_id, f2.level f2_level, f3.offname f3_name, f3.shortname f3_shortname, f3.fias_id f3_fias_id, f3.level f3_level, f4.offname f4_name, f4.shortname f4_shortname, f4.fias_id f4_fias_id, f4.level f4_level, f4.parent_id f4_parent_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.fias_id = 41
80.0008 ControllerEventCompatibilitySELECT fias_id, offname, shortname, altnames FROM fias WHERE `level` = 1
90.0027 ControllerEventCompatibilitySELECT zone_id, name FROM oc_zone WHERE name IN ('ufa','уфа','башкортостан','башкортостан респ.','республика башкортостан','башкортостан республика','kursk','курск','курская','курская обл.','курская область','stavropol','ставрополь','ставропольский','ставропольский край','salekhard','салехард','ямало-ненецкий','ямало-ненецкий ао','belgorod','белгород','белгородская','белгородская обл.','белгородская область','khanty-mansiysk','ханты-мансийский ао - югра','ханты-мансийск','ханты-мансийский','ханты-мансийский ао','vladivostok','владивосток','приморский','приморский край','petrozavodsk','петрозаводск','карелия','карелия респ.','республика карелия','карелия республика','anadyr','анадырь','чукотский','чукотский ао','moskow region','московская','московская обл.','московская область','ivanovo','иваново','ивановская','ивановская обл.','ивановская область','petropavlovsk-kamchatskiy','петропавловск-камчатский','камчатский','камчатский край','krasnodar','краснодар','краснодарский','краснодарский край','карачаево-черкеcсия','cherkessk','карачаево-черкесия','черкесск','карачаево-черкесская','карачаево-черкесская респ.','республика карачаево-черкесская','карачаево-черкесская республика','orel','орел','орловская','орловская обл.','орловская область','чувашская республика','cheboksary','чебоксары','чувашия','чувашия респ.','республика чувашия','чувашия республика','magadan','магадан','магаданская','магаданская обл.','магаданская область','kemerovo','кемерово','кемеровская','кемеровская обл.','кемеровская область','еврейская ао','birobidzhan','биробиджан','еврейская','еврейская аобл.','irkutsk','иркутск','иркутская','иркутская обл.','иркутская область','gorno-altaysk','горно-алтайск','алтай','алтай респ.','республика алтай','алтай республика','vologda','вологда','вологодская','вологодская обл.','вологодская область','penza','пенза','пензенская','пензенская обл.','пензенская область','yekaterinburg','екатеринбург','свердловская','свердловская обл.','свердловская область','ul\'yanovsk','ульяновск','ульяновская','ульяновская обл.','ульяновская область','syktyvkar','сыктывкар','коми','коми респ.','республика коми','коми республика','elista','элиста','калмыкия','калмыкия респ.','республика калмыкия','калмыкия республика','республика северная осетия','vladikavkaz','владикавказ','северная осетия - алания','северная осетия - алания респ.','республика северная осетия - алания','северная осетия - алания республика','kazan','казань','татарстан','татарстан респ.','республика татарстан','татарстан республика','smolensk','смоленск','смоленская','смоленская обл.','смоленская область','blagoveshchensk','благовещенск','амурская','амурская обл.','амурская область','kaluga','калуга','калужская','калужская обл.','калужская область','tomsk','томск','томская','томская обл.','томская область','orenburg','оренбург','оренбургская','оренбургская обл.','оренбургская область','bryansk','брянск','брянская','брянская обл.','брянская область','kalinigrad','калининград','калининградская','калининградская обл.','калининградская область','kurgan','курган','курганская','курганская обл.','курганская область','tula','тула','тульская','тульская обл.','тульская область','moscow','москва','москва г.','perm','пермь','пермский','пермский край','bayqongyr city','bayqongyr','байконур - город республ-го значения','байконур','байконур г.','vyatka','kirov','киров','кировская','кировская обл.','кировская область','arkahangelsk','архангельск','архангельская','архангельская обл.','архангельская область','murmansk','мурманск','мурманская','мурманская обл.','мурманская область','tambov','тамбов','тамбовская','тамбовская обл.','тамбовская область','makhachkala','махачкала','дагестан','дагестан респ.','республика дагестан','дагестан республика','kostroma','кострома','костромская','костромская обл.','костромская область','izhevsk','ижевск','удмуртская','удмуртская респ.','республика удмуртская','удмуртская республика','novosibirsk','новосибирск','новосибирская','новосибирская обл.','новосибирская область','республика саха','yakutsk','саха / якутия','саха/якутия','республика саха / якутия','республика саха/якутия','якутск','саха (якутия)','саха (якутия) респ.','республика саха (якутия)','саха (якутия) республика','ulan-ude','улан-удэ','бурятия','бурятия респ.','республика бурятия','бурятия республика','nazran','magas','назрань','магас','ингушетия','ингушетия респ.','республика ингушетия','ингушетия республика','novgorod','новгород','новгородская','новгородская обл.','новгородская область','groznyy','грозный','чеченская','чеченская респ.','республика чеченская','чеченская республика','saratov','саратов','саратовская','саратовская обл.','саратовская область','maykop','майкоп','адыгея','адыгея респ.','республика адыгея','адыгея республика','krasnoyarsk','красноярск','красноярский','красноярский край','ленинградская','ленинградская обл.','ленинградская область','yoshkar-ola','йошкар-ола','марий эл','марий эл респ.','республика марий эл','марий эл республика','chita','чита','забайкальский','забайкальский край','khabarovsk','хабаровск','хабаровский','хабаровский край','astrakhan','астрахань','астраханская','астраханская обл.','астраханская область','abakan','абакан','хакасия','хакасия респ.','республика хакасия','хакасия республика','lipetsk','липецк','липецкая','липецкая обл.','липецкая область','yaroslavl','ярославль','ярославская','ярославская обл.','ярославская область','nizhniy novgorod','нижний новгород','нижегородская','нижегородская обл.','нижегородская область','pskov','псков','псковская','псковская обл.','псковская область','ryazan','рязань','рязанская','рязанская обл.','рязанская область','omsk','омск','омская','омская обл.','омская область','vladimir','владимир','владимирская','владимирская обл.','владимирская область','saransk','саранск','мордовия','мордовия респ.','республика мордовия','мордовия республика','tver','тверь','тверская','тверская обл.','тверская область','volgograd','волгоград','волгоградская','волгоградская обл.','волгоградская область','naryan mar','нарьян-мар','ненецкий','ненецкий ао','kyzyl','кызыл','тыва','тыва респ.','республика тыва','тыва республика','южно-сахалинск','сахалинская','сахалинская обл.','сахалинская область','республика кабардино-балкария','nalchik','нальчик','кабардино-балкарская','кабардино-балкарская респ.','республика кабардино-балкарская','кабардино-балкарская республика','chelyabinsk','челябинск','челябинская','челябинская обл.','челябинская область','barnaul','барнаул','алтайский','алтайский край','st. petersburg','санкт-петербург','санкт-петербург','санкт-петербург г.','voronezh','воронеж','воронежская','воронежская обл.','воронежская область','rostov-na-donu','ростов-на-дону','ростовская','ростовская обл.','ростовская область','samara','самара','самарская','самарская обл.','самарская область','tyumen','тюмень','тюменская','тюменская обл.','тюменская область','sevastopol\'','севастополь','севастополь г.','крым','crimea','крым','крым респ.','республика крым','крым республика','брест','brestskaya (brest)','brest','брестская','брестская обл.','брестская область','витебск','vitsyebskaya (vitsyebsk)','vitsyebsk','витебская','витебская обл.','витебская область','гомель','homyel\'skaya (homyel\')','homyel\'','гомельская','гомельская обл.','гомельская область','гродно','hrodzyenskaya (hrodna)','hrodna','гродненская','гродненская обл.','гродненская область','minskaya','минская','минская обл.','минская область','минск','horad minsk','minsk','минск','минск г.','могилев','mahilyowskaya (mahilyow)','mahilyow','могилевская','могилевская обл.','могилевская область','донецк','donets\'ka oblast\'','донецька область','донецкая','донецкая обл.','донецкая область','запорожье','zaporiz\'ka oblast\'','запорізька область','запорожская','запорожская обл.','запорожская область','кировоград','kirovohrads\'ka oblast\'','кропивницкий','кіровоградська область','кировоградская','кировоградская обл.','кировоградская область','луганск','luhans\'ka oblast\'','луганська область','луганская','луганская обл.','луганская область','одесса','odes\'ka oblast\'','одеська область','одесская','одесская обл.','одесская область','житомир','zhytomyrs\'ka oblast\'','житомирська область','житомирская','житомирская обл.','житомирская область','днепропетровск','dnipropetrovs\'ka oblast\'','днепр','дніпропетровська область','днепропетровская','днепропетровская обл.','днепропетровская область','николаев','mykolayivs\'ka oblast\'','миколаївська область','николаевская','николаевская обл.','николаевская область','сумы','sums\'ka oblast\'','сумська область','сумская','сумская обл.','сумская область','харьков','kharkivs\'ka oblast\'','харківська область','харьковская','харьковская обл.','харьковская область','винница','vinnyts\'ka oblast\'','вінницька область','винницкая','винницкая обл.','винницкая область','kyivs\'ka oblast\'','київська область','киевская','киевская обл.','киевская область','чернигов','chernihivs\'ka oblast\'','чернігівська область','черниговская','черниговская обл.','черниговская область','хмельницкий','khmel\'nyts\'ka oblast\'','хмельницька область','хмельницкая','хмельницкая обл.','хмельницкая область','херсон','khersons\'ka oblast\'','херсонська область','херсонская','херсонская обл.','херсонская область','ужгород','zakarpats\'ka oblast\'','закарпатська область','закарпатская','закарпатская обл.','закарпатская область','тернополь','ternopil\'s\'ka oblast\'','тернопільська область','тернопольская','тернопольская обл.','тернопольская область','ровно','rivnens\'ka oblast\'','рівненська область','ровненская','ровненская обл.','ровненская область','ивано-франковск','ivano-frankivs\'ka oblast\'','івано-франківська область','ивано-франковская','ивано-франковская обл.','ивано-франковская область','львов','l\'vivs\'ka oblast\'','львівська область','львовская','львовская обл.','львовская область','черкассы','cherkas\'ka oblast\'','черкаська область','черкасская','черкасская обл.','черкасская область','полтава','poltavs\'ka oblast\'','полтавська область','полтавская','полтавская обл.','полтавская область','черновцы','chernivets\'ka oblast\'','чернівецька область','черновицкая','черновицкая обл.','черновицкая область','луцк','volyns\'ka oblast\'','волинська область','волынская','волынская обл.','волынская область','kyiv','київ','киев','киев г.','aqmola','акмолинская','акмолинская обл.','акмолинская область','aqtobe','актюбинская','актюбинская обл.','актюбинская область','almaty','алматинская','алматинская обл.','алматинская область','atyrau','атырауская','атырауская обл.','атырауская область','batys qazaqstan','западно-казахстанская','западно-казахстанская обл.','западно-казахстанская область','zhambyl','жамбылская','жамбылская обл.','жамбылская область','qaraghandy','карагандинская','карагандинская обл.','карагандинская область','qostanay','костанайская','костанайская обл.','костанайская область','qyzylorda','кызылординская','кызылординская обл.','кызылординская область','mangghystau','мангистауская','мангистауская обл.','мангистауская область','ongtustik qazaqstan','turkestan','южно-казахстанская область','туркестанская','туркестанская обл.','туркестанская область','pavlodar','павлодарская','павлодарская обл.','павлодарская область','soltustik qazaqstan','северо-казахстанская','северо-казахстанская обл.','северо-казахстанская область','shyghys qazaqstan','восточно-казахстанская','восточно-казахстанская обл.','восточно-казахстанская область','астана - город республ-го значения','астана','нур-султан - город республ-го значения','astana city','nur-sultan','нур-султан','нур-султан г.','алматы - город республ-го значения','almaty city','алматы','алматы г.','шымкент - город республ-го значения','shymkent','шымкент','шымкент г.')
100.0002 ControllerEventCompatibilitySELECT fias_id, offname, altnames FROM fias WHERE `level` = 0
110.0001 ControllerEventCompatibilitySELECT country_id, name FROM oc_country WHERE name IN ('российская федерация','russian federation','russia','россия','белоруссия (беларусь)','беларусь','belarus','белоруссия','беларусь','ukraine','україна','украина','kazakhstan','казахстан')
120.0002 ControllerEventCompatibilitySELECT * FROM oc_currency
130.0004 ControllerEventCompatibilitySELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority FROM oc_tax_rule tr1 LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id) INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id) LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id) LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id) WHERE tr1.based = 'shipping' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '176' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '2761') ORDER BY tr1.priority ASC
140.0003 ControllerEventCompatibilitySELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority FROM oc_tax_rule tr1 LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id) INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id) LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id) LEFT JOIN oc_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 = '176' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '2761') ORDER BY tr1.priority ASC
150.0002 ControllerEventCompatibilitySELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority FROM oc_tax_rule tr1 LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id) INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id) LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id) LEFT JOIN oc_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
160.0002 ControllerEventCompatibilitySELECT * FROM oc_weight_class wc LEFT JOIN oc_weight_class_description wcd ON (wc.weight_class_id = wcd.weight_class_id) WHERE wcd.language_id = '1'
170.0002 ControllerEventCompatibilitySELECT * FROM oc_length_class mc LEFT JOIN oc_length_class_description mcd ON (mc.length_class_id = mcd.length_class_id) WHERE mcd.language_id = '1'
180.0001 ControllerEventCompatibilityDELETE FROM oc_cart WHERE date_added < DATE_SUB(NOW(), INTERVAL '30' DAY)
190.0003 ControllerEventCompatibilitySHOW TABLES LIKE 'oc_cartkeeper'
200.0003 ControllerEventCompatibilitySHOW TABLES LIKE 'oc_cartkeeper_share'
210.0002 ControllerEventCompatibilityDELETE FROM oc_cartkeeper WHERE date_added < DATE_SUB(NOW(), INTERVAL '30' DAY)
220.0001 ControllerEventCompatibilityDELETE FROM oc_cartkeeper_share WHERE customer_id = '0' AND date_added < DATE_SUB(NOW(), INTERVAL '3' DAY)
230.0001 ControllerEventCompatibilityDELETE FROM oc_cartkeeper_share WHERE customer_id != '0' AND date_added < DATE_SUB(NOW(), INTERVAL '14' DAY)
240.0001 ControllerEventCompatibilitySELECT `session_id` FROM `oc_cart` WHERE `session_id` = 'ac45e4748ec19b3e029511e20a57fc92' LIMIT 1
250.0001 ControllerStartupEventSELECT * FROM `oc_event` WHERE `trigger` LIKE 'catalog/%' AND status = '1' ORDER BY `event_id` ASC
260.0012 ControllerStartupSeoProSELECT category_id, parent_id FROM oc_category ORDER BY parent_id
270.0002 ControllerStartupSeoProSELECT query FROM oc_url_alias WHERE keyword = 'warcam' LIMIT 1
280.0001 ControllerStartupSeoProSELECT query FROM oc_url_alias WHERE keyword = 'warcam' LIMIT 1
290.0001 ControllerStartupSeoProSELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'manufacturer_id=70' LIMIT 1
300.0001 ControllerProductManufacturerSELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'common/home' LIMIT 1
310.0001 ControllerProductManufacturerSELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'product/manufacturer' LIMIT 1
320.0002 ControllerProductManufacturerSELECT DISTINCT *, md.name AS name FROM oc_manufacturer m LEFT JOIN oc_manufacturer_description md ON (m.manufacturer_id = md.manufacturer_id) LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id) WHERE md.language_id = '1' && m.manufacturer_id = '70' AND m2s.store_id = '0'
330.0001 ControllerProductManufacturerSELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'manufacturer_id=70' LIMIT 1
340.0002 ControllerProductManufacturerSELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'product/compare' LIMIT 1
350.0002 ControllerEventCompatibilitySELECT * FROM oc_layout_route WHERE 'product/manufacturer/info' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
360.0001 ControllerEventCompatibilitySELECT * FROM oc_layout_module WHERE layout_id = '15' AND `code` = 'ocfilter'
370.0001 ControllerEventCompatibilitySELECT * FROM oc_ocfilter_setting WHERE `key` = 'placement_layout'
380.0465 ControllerEventCompatibilitySELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.catalog_output = '1' AND p.manufacturer_id = '70'
390.1414 ControllerEventCompatibilitySELECT p.product_id, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.catalog_output = '1' AND p.manufacturer_id = '70' GROUP BY p.product_id ORDER BY p.sort_order ASC, LCASE(pd.name) ASC LIMIT 7456,32
400.0007 ControllerEventCompatibilitySELECT DISTINCT *, pd.name AS name, p.image, m.image AS manufacturer_image, (SELECT md.name FROM oc_manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_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 oc_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 oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '133646' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
410.0005 ControllerEventCompatibilitySELECT DISTINCT *, pd.name AS name, p.image, m.image AS manufacturer_image, (SELECT md.name FROM oc_manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_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 oc_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 oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '133647' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
420.0005 ControllerEventCompatibilitySELECT DISTINCT *, pd.name AS name, p.image, m.image AS manufacturer_image, (SELECT md.name FROM oc_manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_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 oc_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 oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '133645' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
430.0006 ControllerEventCompatibilitySELECT DISTINCT *, pd.name AS name, p.image, m.image AS manufacturer_image, (SELECT md.name FROM oc_manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_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 oc_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 oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '10829' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
440.0006 ControllerEventCompatibilitySELECT DISTINCT *, pd.name AS name, p.image, m.image AS manufacturer_image, (SELECT md.name FROM oc_manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_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 oc_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 oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '10833' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
450.0006 ControllerEventCompatibilitySELECT DISTINCT *, pd.name AS name, p.image, m.image AS manufacturer_image, (SELECT md.name FROM oc_manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_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 oc_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 oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '10912' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
460.0006 ControllerEventCompatibilitySELECT DISTINCT *, pd.name AS name, p.image, m.image AS manufacturer_image, (SELECT md.name FROM oc_manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_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 oc_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 oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '10896' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
470.0005 ControllerEventCompatibilitySELECT DISTINCT *, pd.name AS name, p.image, m.image AS manufacturer_image, (SELECT md.name FROM oc_manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_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 oc_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 oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '10810' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
480.0006 ControllerEventCompatibilitySELECT DISTINCT *, pd.name AS name, p.image, m.image AS manufacturer_image, (SELECT md.name FROM oc_manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_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 oc_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 oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '15257' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
490.0005 ControllerEventCompatibilitySELECT DISTINCT *, pd.name AS name, p.image, m.image AS manufacturer_image, (SELECT md.name FROM oc_manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_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 oc_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 oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '22191' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
500.0007 ControllerEventCompatibilitySELECT DISTINCT *, pd.name AS name, p.image, m.image AS manufacturer_image, (SELECT md.name FROM oc_manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_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 oc_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 oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '15567' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
510.0007 ControllerEventCompatibilitySELECT DISTINCT *, pd.name AS name, p.image, m.image AS manufacturer_image, (SELECT md.name FROM oc_manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_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 oc_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 oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '18815' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
520.0005 ControllerEventCompatibilitySELECT DISTINCT *, pd.name AS name, p.image, m.image AS manufacturer_image, (SELECT md.name FROM oc_manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_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 oc_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 oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '22993' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
530.0005 ControllerEventCompatibilitySELECT DISTINCT *, pd.name AS name, p.image, m.image AS manufacturer_image, (SELECT md.name FROM oc_manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_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 oc_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 oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '12720' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
540.0005 ControllerEventCompatibilitySELECT DISTINCT *, pd.name AS name, p.image, m.image AS manufacturer_image, (SELECT md.name FROM oc_manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_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 oc_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 oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '28179' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
550.0006 ControllerEventCompatibilitySELECT DISTINCT *, pd.name AS name, p.image, m.image AS manufacturer_image, (SELECT md.name FROM oc_manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_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 oc_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 oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '99630' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
560.0007 ControllerEventCompatibilitySELECT DISTINCT *, pd.name AS name, p.image, m.image AS manufacturer_image, (SELECT md.name FROM oc_manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_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 oc_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 oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '127909' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
570.0007 ControllerEventCompatibilitySELECT DISTINCT *, pd.name AS name, p.image, m.image AS manufacturer_image, (SELECT md.name FROM oc_manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_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 oc_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 oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '127908' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
580.0006 ControllerEventCompatibilitySELECT DISTINCT *, pd.name AS name, p.image, m.image AS manufacturer_image, (SELECT md.name FROM oc_manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_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 oc_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 oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '57720' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
590.001 ControllerEventCompatibilitySELECT DISTINCT *, pd.name AS name, p.image, m.image AS manufacturer_image, (SELECT md.name FROM oc_manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_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 oc_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 oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '105692' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
600.0009 ControllerEventCompatibilitySELECT DISTINCT *, pd.name AS name, p.image, m.image AS manufacturer_image, (SELECT md.name FROM oc_manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_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 oc_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 oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '8444' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
610.001 ControllerEventCompatibilitySELECT DISTINCT *, pd.name AS name, p.image, m.image AS manufacturer_image, (SELECT md.name FROM oc_manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_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 oc_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 oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '11179' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
620.0009 ControllerEventCompatibilitySELECT DISTINCT *, pd.name AS name, p.image, m.image AS manufacturer_image, (SELECT md.name FROM oc_manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_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 oc_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 oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '11124' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
630.0009 ControllerEventCompatibilitySELECT DISTINCT *, pd.name AS name, p.image, m.image AS manufacturer_image, (SELECT md.name FROM oc_manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_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 oc_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 oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '7275' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
640.0008 ControllerEventCompatibilitySELECT DISTINCT *, pd.name AS name, p.image, m.image AS manufacturer_image, (SELECT md.name FROM oc_manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_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 oc_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 oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '10816' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
650.0008 ControllerEventCompatibilitySELECT DISTINCT *, pd.name AS name, p.image, m.image AS manufacturer_image, (SELECT md.name FROM oc_manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_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 oc_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 oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '10815' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
660.0008 ControllerEventCompatibilitySELECT DISTINCT *, pd.name AS name, p.image, m.image AS manufacturer_image, (SELECT md.name FROM oc_manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_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 oc_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 oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '5146' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
670.0007 ControllerEventCompatibilitySELECT DISTINCT *, pd.name AS name, p.image, m.image AS manufacturer_image, (SELECT md.name FROM oc_manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_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 oc_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 oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '76760' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
680.0007 ControllerEventCompatibilitySELECT DISTINCT *, pd.name AS name, p.image, m.image AS manufacturer_image, (SELECT md.name FROM oc_manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_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 oc_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 oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '43717' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
690.0005 ControllerEventCompatibilitySELECT DISTINCT *, pd.name AS name, p.image, m.image AS manufacturer_image, (SELECT md.name FROM oc_manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_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 oc_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 oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '42275' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
700.0005 ControllerEventCompatibilitySELECT DISTINCT *, pd.name AS name, p.image, m.image AS manufacturer_image, (SELECT md.name FROM oc_manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_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 oc_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 oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '19156' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
710.0005 ControllerEventCompatibilitySELECT DISTINCT *, pd.name AS name, p.image, m.image AS manufacturer_image, (SELECT md.name FROM oc_manufacturer_description md WHERE md.manufacturer_id = p.manufacturer_id AND md.language_id = '1') AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_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 oc_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 oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '48035' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
720.0001 ControllerEventCompatibilitySELECT category_id FROM oc_product_to_category WHERE product_id = '133646' ORDER BY main_category DESC LIMIT 1
730.0001 ControllerEventCompatibilitySELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=64' LIMIT 1
740.0001 ControllerEventCompatibilitySELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=158' LIMIT 1
750.0001 ControllerEventCompatibilitySELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'product_id=133646' LIMIT 1
760.0001 ControllerEventCompatibilitySELECT category_id FROM oc_product_to_category WHERE product_id = '133647' ORDER BY main_category DESC LIMIT 1
770.0001 ControllerEventCompatibilitySELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=64' LIMIT 1
780.0001 ControllerEventCompatibilitySELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=158' LIMIT 1
790.0001 ControllerEventCompatibilitySELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'product_id=133647' LIMIT 1
800.0001 ControllerEventCompatibilitySELECT category_id FROM oc_product_to_category WHERE product_id = '133645' ORDER BY main_category DESC LIMIT 1
810.0001 ControllerEventCompatibilitySELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=64' LIMIT 1
820.0001 ControllerEventCompatibilitySELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=158' LIMIT 1
830.0001 ControllerEventCompatibilitySELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'product_id=133645' LIMIT 1
840.0001 ControllerEventCompatibilitySELECT category_id FROM oc_product_to_category WHERE product_id = '10829' ORDER BY main_category DESC LIMIT 1
850.0001 ControllerEventCompatibilitySELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=96' LIMIT 1
860.0001 ControllerEventCompatibilitySELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=146' LIMIT 1
870.0001 ControllerEventCompatibilitySELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'product_id=10829' LIMIT 1
880.0002 ControllerEventCompatibilitySELECT category_id FROM oc_product_to_category WHERE product_id = '10833' ORDER BY main_category DESC LIMIT 1
890.0001 ControllerEventCompatibilitySELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=96' LIMIT 1
900.0001 ControllerEventCompatibilitySELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=146' LIMIT 1
910.0001 ControllerEventCompatibilitySELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'product_id=10833' LIMIT 1
920.0001 ControllerEventCompatibilitySELECT category_id FROM oc_product_to_category WHERE product_id = '10912' ORDER BY main_category DESC LIMIT 1
930.0001 ControllerEventCompatibilitySELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=96' LIMIT 1
940.0001 ControllerEventCompatibilitySELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=146' LIMIT 1
950.0001 ControllerEventCompatibilitySELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'product_id=10912' LIMIT 1
960.0004 ControllerEventCompatibilitySELECT category_id FROM oc_product_to_category WHERE product_id = '10896' ORDER BY main_category DESC LIMIT 1
970.0003 ControllerEventCompatibilitySELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=96' LIMIT 1
980.0002 ControllerEventCompatibilitySELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=146' LIMIT 1
990.0001 ControllerEventCompatibilitySELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'product_id=10896' LIMIT 1
1000.0001 ControllerEventCompatibilitySELECT category_id FROM oc_product_to_category WHERE product_id = '10810' ORDER BY main_category DESC LIMIT 1
1010.0001 ControllerEventCompatibilitySELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=96' LIMIT 1
1020.0001 ControllerEventCompatibilitySELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=146' LIMIT 1
1030.0001 ControllerEventCompatibilitySELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'product_id=10810' LIMIT 1
1040.0001 ControllerEventCompatibilitySELECT category_id FROM oc_product_to_category WHERE product_id = '15257' ORDER BY main_category DESC LIMIT 1
1050.0001 ControllerEventCompatibilitySELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=96' LIMIT 1
1060.0001 ControllerEventCompatibilitySELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=146' LIMIT 1
1070.0001 ControllerEventCompatibilitySELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'product_id=15257' LIMIT 1
1080.0001 ControllerEventCompatibilitySELECT category_id FROM oc_product_to_category WHERE product_id = '22191' ORDER BY main_category DESC LIMIT 1
1090.0001 ControllerEventCompatibilitySELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=71' LIMIT 1
1100.0001 ControllerEventCompatibilitySELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=73' LIMIT 1
1110.0001 ControllerEventCompatibilitySELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'product_id=22191' LIMIT 1
1120.0001 ControllerEventCompatibilitySELECT category_id FROM oc_product_to_category WHERE product_id = '15567' ORDER BY main_category DESC LIMIT 1
1130.0001 ControllerEventCompatibilitySELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=71' LIMIT 1
1140.0001 ControllerEventCompatibilitySELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=73' LIMIT 1
1150.0001 ControllerEventCompatibilitySELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'product_id=15567' LIMIT 1
1160.0001 ControllerEventCompatibilitySELECT category_id FROM oc_product_to_category WHERE product_id = '18815' ORDER BY main_category DESC LIMIT 1
1170.0001 ControllerEventCompatibilitySELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=71' LIMIT 1
1180.0001 ControllerEventCompatibilitySELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=73' LIMIT 1
1190.0001 ControllerEventCompatibilitySELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'product_id=18815' LIMIT 1
1200.0001 ControllerEventCompatibilitySELECT category_id FROM oc_product_to_category WHERE product_id = '22993' ORDER BY main_category DESC LIMIT 1
1210.0001 ControllerEventCompatibilitySELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=64' LIMIT 1
1220.0001 ControllerEventCompatibilitySELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'product_id=22993' LIMIT 1
1230.0002 ControllerEventCompatibilitySELECT category_id FROM oc_product_to_category WHERE product_id = '12720' ORDER BY main_category DESC LIMIT 1
1240.0001 ControllerEventCompatibilitySELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=64' LIMIT 1
1250.0001 ControllerEventCompatibilitySELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=70' LIMIT 1
1260.0001 ControllerEventCompatibilitySELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'product_id=12720' LIMIT 1
1270.0001 ControllerEventCompatibilitySELECT category_id FROM oc_product_to_category WHERE product_id = '28179' ORDER BY main_category DESC LIMIT 1
1280.0001 ControllerEventCompatibilitySELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=64' LIMIT 1
1290.0001 ControllerEventCompatibilitySELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=70' LIMIT 1
1300.0001 ControllerEventCompatibilitySELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'product_id=28179' LIMIT 1
1310.0002 ControllerEventCompatibilitySELECT category_id FROM oc_product_to_category WHERE product_id = '99630' ORDER BY main_category DESC LIMIT 1
1320.0001 ControllerEventCompatibilitySELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=1499' LIMIT 1
1330.0001 ControllerEventCompatibilitySELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'product_id=99630' LIMIT 1
1340.0002 ControllerEventCompatibilitySELECT category_id FROM oc_product_to_category WHERE product_id = '127909' ORDER BY main_category DESC LIMIT 1
1350.0001 ControllerEventCompatibilitySELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=64' LIMIT 1
1360.0001 ControllerEventCompatibilitySELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=211' LIMIT 1
1370.0001 ControllerEventCompatibilitySELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'product_id=127909' LIMIT 1
1380.0001 ControllerEventCompatibilitySELECT category_id FROM oc_product_to_category WHERE product_id = '127908' ORDER BY main_category DESC LIMIT 1
1390.0001 ControllerEventCompatibilitySELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=64' LIMIT 1
1400.0001 ControllerEventCompatibilitySELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=211' LIMIT 1
1410.0001 ControllerEventCompatibilitySELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'product_id=127908' LIMIT 1
1420.0001 ControllerEventCompatibilitySELECT category_id FROM oc_product_to_category WHERE product_id = '57720' ORDER BY main_category DESC LIMIT 1
1430.0001 ControllerEventCompatibilitySELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=64' LIMIT 1
1440.0001 ControllerEventCompatibilitySELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=158' LIMIT 1
1450.0001 ControllerEventCompatibilitySELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'product_id=57720' LIMIT 1
1460.0001 ControllerEventCompatibilitySELECT category_id FROM oc_product_to_category WHERE product_id = '105692' ORDER BY main_category DESC LIMIT 1
1470.0001 ControllerEventCompatibilitySELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=64' LIMIT 1
1480.0001 ControllerEventCompatibilitySELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=158' LIMIT 1
1490.0001 ControllerEventCompatibilitySELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'product_id=105692' LIMIT 1
1500.0001 ControllerEventCompatibilitySELECT category_id FROM oc_product_to_category WHERE product_id = '8444' ORDER BY main_category DESC LIMIT 1
1510.0001 ControllerEventCompatibilitySELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=64' LIMIT 1
1520.0001 ControllerEventCompatibilitySELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=158' LIMIT 1
1530.0001 ControllerEventCompatibilitySELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'product_id=8444' LIMIT 1
1540.0001 ControllerEventCompatibilitySELECT category_id FROM oc_product_to_category WHERE product_id = '11179' ORDER BY main_category DESC LIMIT 1
1550.0001 ControllerEventCompatibilitySELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=96' LIMIT 1
1560.0001 ControllerEventCompatibilitySELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=113' LIMIT 1
1570.0001 ControllerEventCompatibilitySELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'product_id=11179' LIMIT 1
1580.0001 ControllerEventCompatibilitySELECT category_id FROM oc_product_to_category WHERE product_id = '11124' ORDER BY main_category DESC LIMIT 1
1590.0001 ControllerEventCompatibilitySELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=96' LIMIT 1
1600.0001 ControllerEventCompatibilitySELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=113' LIMIT 1
1610.0001 ControllerEventCompatibilitySELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'product_id=11124' LIMIT 1
1620.0001 ControllerEventCompatibilitySELECT category_id FROM oc_product_to_category WHERE product_id = '7275' ORDER BY main_category DESC LIMIT 1
1630.0001 ControllerEventCompatibilitySELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=96' LIMIT 1
1640.0001 ControllerEventCompatibilitySELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=113' LIMIT 1
1650.0001 ControllerEventCompatibilitySELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'product_id=7275' LIMIT 1
1660.0002 ControllerEventCompatibilitySELECT category_id FROM oc_product_to_category WHERE product_id = '10816' ORDER BY main_category DESC LIMIT 1
1670.0001 ControllerEventCompatibilitySELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=96' LIMIT 1
1680.0001 ControllerEventCompatibilitySELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=113' LIMIT 1
1690.0001 ControllerEventCompatibilitySELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'product_id=10816' LIMIT 1
1700.0001 ControllerEventCompatibilitySELECT category_id FROM oc_product_to_category WHERE product_id = '10815' ORDER BY main_category DESC LIMIT 1
1710.0001 ControllerEventCompatibilitySELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=96' LIMIT 1
1720.0001 ControllerEventCompatibilitySELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=113' LIMIT 1
1730.0001 ControllerEventCompatibilitySELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'product_id=10815' LIMIT 1
1740.0001 ControllerEventCompatibilitySELECT category_id FROM oc_product_to_category WHERE product_id = '5146' ORDER BY main_category DESC LIMIT 1
1750.0001 ControllerEventCompatibilitySELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=64' LIMIT 1
1760.0001 ControllerEventCompatibilitySELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=158' LIMIT 1
1770.0001 ControllerEventCompatibilitySELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'product_id=5146' LIMIT 1
1780.0001 ControllerEventCompatibilitySELECT category_id FROM oc_product_to_category WHERE product_id = '76760' ORDER BY main_category DESC LIMIT 1
1790.0001 ControllerEventCompatibilitySELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=64' LIMIT 1
1800.0001 ControllerEventCompatibilitySELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=94' LIMIT 1
1810.0001 ControllerEventCompatibilitySELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'product_id=76760' LIMIT 1
1820.0002 ControllerEventCompatibilitySELECT category_id FROM oc_product_to_category WHERE product_id = '43717' ORDER BY main_category DESC LIMIT 1
1830.0001 ControllerEventCompatibilitySELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=64' LIMIT 1
1840.0001 ControllerEventCompatibilitySELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=94' LIMIT 1
1850.0001 ControllerEventCompatibilitySELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'product_id=43717' LIMIT 1
1860.0001 ControllerEventCompatibilitySELECT category_id FROM oc_product_to_category WHERE product_id = '42275' ORDER BY main_category DESC LIMIT 1
1870.0001 ControllerEventCompatibilitySELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=64' LIMIT 1
1880.0001 ControllerEventCompatibilitySELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'product_id=42275' LIMIT 1
1890.0001 ControllerEventCompatibilitySELECT category_id FROM oc_product_to_category WHERE product_id = '19156' ORDER BY main_category DESC LIMIT 1
1900.0002 ControllerEventCompatibilitySELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=64' LIMIT 1
1910.0001 ControllerEventCompatibilitySELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'product_id=19156' LIMIT 1
1920.0001 ControllerEventCompatibilitySELECT category_id FROM oc_product_to_category WHERE product_id = '48035' ORDER BY main_category DESC LIMIT 1
1930.0001 ControllerEventCompatibilitySELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'category_id=71' LIMIT 1
1940.0001 ControllerEventCompatibilitySELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'product_id=48035' LIMIT 1
1950.0001 ControllerEventCompatibilitySELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'manufacturer_id=70' LIMIT 1
1960.0001 ControllerEventCompatibilitySELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'manufacturer_id=70' LIMIT 1
1970.0001 ControllerEventCompatibilitySELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'manufacturer_id=70' LIMIT 1
1980.0001 ControllerEventCompatibilitySELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'manufacturer_id=70' LIMIT 1
1990.0001 ControllerEventCompatibilitySELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'manufacturer_id=70' LIMIT 1
2000.0001 ControllerEventCompatibilitySELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'manufacturer_id=70' LIMIT 1
2010.0001 ControllerEventCompatibilitySELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'manufacturer_id=70' LIMIT 1
2020.0001 ControllerEventCompatibilitySELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'manufacturer_id=70' LIMIT 1
2030.0001 ControllerEventCompatibilitySELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'manufacturer_id=70' LIMIT 1
2040.0001 ControllerEventCompatibilitySELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'manufacturer_id=70' LIMIT 1
2050.0001 ControllerEventCompatibilitySELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'manufacturer_id=70' LIMIT 1
2060.0001 ControllerEventCompatibilitySELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'manufacturer_id=70' LIMIT 1
2070.0001 ControllerEventCompatibilitySELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'manufacturer_id=70' LIMIT 1
2080.0001 ControllerEventCompatibilitySELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'manufacturer_id=70' LIMIT 1
2090.0001 ControllerExtensionModuleMicrodataProSELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'manufacturer_id=70' LIMIT 1
2100.0001 ControllerExtensionModuleMicrodataProSELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'manufacturer_id=70' LIMIT 1
2110.0001 ControllerExtensionModuleMicrodataProSELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'manufacturer_id=70' LIMIT 1
2120.0001 ControllerExtensionModuleMicrodataProSELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'common/home' LIMIT 1
2130.0001 ControllerCommonColumnLeftSELECT * FROM oc_layout_route WHERE 'product/manufacturer/info' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
2140.0001 ControllerCommonColumnLeftSELECT * FROM oc_layout_module WHERE layout_id = '15' AND position = 'column_left' ORDER BY sort_order
2150.0001 ControllerCommonColumnRightSELECT * FROM oc_layout_route WHERE 'product/manufacturer/info' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
2160.0001 ControllerCommonColumnRightSELECT * FROM oc_layout_module WHERE layout_id = '15' AND position = 'column_right' ORDER BY sort_order
2170.0001 ControllerCommonContentTopSELECT * FROM oc_layout_route WHERE 'product/manufacturer/info' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
2180.0001 ControllerCommonContentTopSELECT * FROM oc_layout_module WHERE layout_id = '15' AND position = 'content_top' ORDER BY sort_order
2190.0001 ControllerCommonContentBottomSELECT * FROM oc_layout_route WHERE 'product/manufacturer/info' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
2200.0001 ControllerCommonContentBottomSELECT * FROM oc_layout_module WHERE layout_id = '15' AND position = 'content_bottom' ORDER BY sort_order
2210.0001 ControllerCommonFooterSELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'information/contact' LIMIT 1
2220.0001 ControllerCommonFooterSELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'account/return/add' LIMIT 1
2230.0001 ControllerCommonFooterSELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'information/sitemap' LIMIT 1
2240.0001 ControllerCommonFooterSELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'product/manufacturer' LIMIT 1
2250.0001 ControllerCommonFooterSELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'account/voucher' LIMIT 1
2260.0001 ControllerCommonFooterSELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'affiliate/account' LIMIT 1
2270.0001 ControllerCommonFooterSELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'product/special' LIMIT 1
2280.0001 ControllerCommonFooterSELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'account/account' LIMIT 1
2290.0001 ControllerCommonFooterSELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'account/order' LIMIT 1
2300.0001 ControllerCommonFooterSELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'account/wishlist' LIMIT 1
2310.0001 ControllerCommonFooterSELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'account/newsletter' LIMIT 1
2320.0001 ControllerEventCompatibilitySELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'product/compare' LIMIT 1
2330.0001 ControllerEventCompatibilitySELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'account/wishlist' LIMIT 1
2340.0001 ControllerEventCompatibilitySELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'checkout/cart' LIMIT 1
2350.0001 ControllerExtensionModuleMicrodataProSELECT * FROM oc_store ORDER BY url
2360.0001 ControllerCommonHeaderSELECT * FROM oc_extension WHERE `type` = 'analytics'
2370.0001 ControllerCommonHeaderSELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'account/account' LIMIT 1
2380.0001 ControllerCommonHeaderSELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'account/logout' LIMIT 1
2390.0001 ControllerCommonHeaderSELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'common/home' LIMIT 1
2400.0001 ControllerCommonHeaderSELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'account/wishlist' LIMIT 1
2410.0001 ControllerCommonHeaderSELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'account/account' LIMIT 1
2420.0001 ControllerCommonHeaderSELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'account/register' LIMIT 1
2430.0001 ControllerCommonHeaderSELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'account/login' LIMIT 1
2440.0001 ControllerCommonHeaderSELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'account/order' LIMIT 1
2450.0001 ControllerCommonHeaderSELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'account/transaction' LIMIT 1
2460.0001 ControllerCommonHeaderSELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'account/download' LIMIT 1
2470.0001 ControllerCommonHeaderSELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'account/logout' LIMIT 1
2480.0001 ControllerCommonHeaderSELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'checkout/cart' LIMIT 1
2490.0001 ControllerCommonHeaderSELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'checkout/checkout' LIMIT 1
2500.0001 ControllerCommonHeaderSELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'information/contact' LIMIT 1
2510.0001 ControllerCommonHeaderSELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'product/compare' LIMIT 1
2520.0001 ControllerEventCompatibilitySELECT SUM(quantity) as total FROM oc_cart WHERE api_id = '0' AND session_id = 'ac45e4748ec19b3e029511e20a57fc92'
2530.0001 ControllerCommonLanguageSELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'common/language/language' LIMIT 1
2540.0001 ControllerCommonLanguageSELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'manufacturer_id=70' LIMIT 1
2550.0001 ControllerCommonCurrencySELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'common/currency/currency' LIMIT 1
2560.0001 ControllerCommonCurrencySELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'manufacturer_id=70' LIMIT 1
2570.0001 ControllerCommonCartSELECT * FROM oc_cart WHERE api_id = '0' AND session_id = 'ac45e4748ec19b3e029511e20a57fc92'
2580.0001 ControllerCommonCartSELECT * FROM oc_extension WHERE `type` = 'total'
2590.0001 ControllerEventCompatibilitySELECT * FROM oc_cart WHERE api_id = '0' AND session_id = 'ac45e4748ec19b3e029511e20a57fc92'
2600.0001 ControllerEventCompatibilitySELECT SUM(amount) AS total FROM oc_customer_transaction WHERE customer_id = '0'
2610.0001 ControllerEventCompatibilitySELECT SUM(quantity) as total FROM oc_cart WHERE api_id = '0' AND session_id = 'ac45e4748ec19b3e029511e20a57fc92'
2620.0001 ControllerEventCompatibilitySELECT SUM(quantity) as total FROM oc_cart WHERE api_id = '0' AND session_id = 'ac45e4748ec19b3e029511e20a57fc92'
2630.0001 ControllerEventCompatibilitySELECT * FROM oc_cart WHERE api_id = '0' AND session_id = 'ac45e4748ec19b3e029511e20a57fc92'
2640.0001 ControllerEventCompatibilitySELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'checkout/cart' LIMIT 1
2650.0001 ControllerEventCompatibilitySELECT LCASE(keyword) as keyword FROM oc_url_alias WHERE query = 'checkout/checkout' LIMIT 1