testo222 Array
(
    [WSGERAETEFILTER] => 79304
)
 
Intimpex Elektrokomponenten | gastrotiger
Nach Gerät suchen Dropdown-Icon
Elektrokomponenten - Intimpex

Elektrokomponenten - Intimpex

testo222Y 
testoR SELECT DISTINCT shop_view_active_item.*
                                              FROM shop_item_has_category
                                              INNER JOIN shop_view_active_item ON shop_item_has_category.item_no = shop_view_active_item.item_no
                                              INNER JOIN shop_category sc ON sc.line_no = shop_item_has_category.category_line_no
                                              WHERE (shop_item_has_category.category_line_no = 100000000 OR shop_item_has_category.category_line_no = '118180000' OR shop_item_has_category.category_line_no = '118170000' OR shop_item_has_category.category_line_no = '118160000' OR shop_item_has_category.category_line_no = '118150000' OR shop_item_has_category.category_line_no = '118140000' OR shop_item_has_category.category_line_no = '118130000' OR shop_item_has_category.category_line_no = '118120000' OR shop_item_has_category.category_line_no = '118110000' OR shop_item_has_category.category_line_no = '118100000' OR shop_item_has_category.category_line_no = '118090000' OR shop_item_has_category.category_line_no = '118080000' OR shop_item_has_category.category_line_no = '118070000' OR shop_item_has_category.category_line_no = '118060000' OR shop_item_has_category.category_line_no = '118050000' OR shop_item_has_category.category_line_no = '118040000' OR shop_item_has_category.category_line_no = '118030000' OR shop_item_has_category.category_line_no = '118020000' OR shop_item_has_category.category_line_no = '118010000' OR shop_item_has_category.category_line_no = '118000000' OR shop_item_has_category.category_line_no = '117080000' OR shop_item_has_category.category_line_no = '117070000' OR shop_item_has_category.category_line_no = '117060000' OR shop_item_has_category.category_line_no = '117050000' OR shop_item_has_category.category_line_no = '117040000' OR shop_item_has_category.category_line_no = '117030000' OR shop_item_has_category.category_line_no = '117020000' OR shop_item_has_category.category_line_no = '117010000' OR shop_item_has_category.category_line_no = '117000000' OR shop_item_has_category.category_line_no = '116110000' OR shop_item_has_category.category_line_no = '116100000' OR shop_item_has_category.category_line_no = '116090000' OR shop_item_has_category.category_line_no = '116080000' OR shop_item_has_category.category_line_no = '116070000' OR shop_item_has_category.category_line_no = '116060000' OR shop_item_has_category.category_line_no = '116050000' OR shop_item_has_category.category_line_no = '116040000' OR shop_item_has_category.category_line_no = '116030000' OR shop_item_has_category.category_line_no = '116020000' OR shop_item_has_category.category_line_no = '116010000' OR shop_item_has_category.category_line_no = '116000000' OR shop_item_has_category.category_line_no = '115070000' OR shop_item_has_category.category_line_no = '115060000' OR shop_item_has_category.category_line_no = '115050000' OR shop_item_has_category.category_line_no = '115040000' OR shop_item_has_category.category_line_no = '115030000' OR shop_item_has_category.category_line_no = '115020000' OR shop_item_has_category.category_line_no = '115010000' OR shop_item_has_category.category_line_no = '115000000' OR shop_item_has_category.category_line_no = '114040000' OR shop_item_has_category.category_line_no = '114030000' OR shop_item_has_category.category_line_no = '114020000' OR shop_item_has_category.category_line_no = '114010000' OR shop_item_has_category.category_line_no = '114000000' OR shop_item_has_category.category_line_no = '113080000' OR shop_item_has_category.category_line_no = '113070000' OR shop_item_has_category.category_line_no = '113060000' OR shop_item_has_category.category_line_no = '113050000' OR shop_item_has_category.category_line_no = '113040000' OR shop_item_has_category.category_line_no = '113030000' OR shop_item_has_category.category_line_no = '113020000' OR shop_item_has_category.category_line_no = '113010000' OR shop_item_has_category.category_line_no = '113000000' OR shop_item_has_category.category_line_no = '112050000' OR shop_item_has_category.category_line_no = '112040000' OR shop_item_has_category.category_line_no = '112030000' OR shop_item_has_category.category_line_no = '112020000' OR shop_item_has_category.category_line_no = '112010000' OR shop_item_has_category.category_line_no = '112000000' OR shop_item_has_category.category_line_no = '110070000' OR shop_item_has_category.category_line_no = '110060000' OR shop_item_has_category.category_line_no = '110050000' OR shop_item_has_category.category_line_no = '110040000' OR shop_item_has_category.category_line_no = '110030000' OR shop_item_has_category.category_line_no = '110020000' OR shop_item_has_category.category_line_no = '110010000' OR shop_item_has_category.category_line_no = '110000000' OR shop_item_has_category.category_line_no = '109100000' OR shop_item_has_category.category_line_no = '109090000' OR shop_item_has_category.category_line_no = '109080000' OR shop_item_has_category.category_line_no = '109070000' OR shop_item_has_category.category_line_no = '109060000' OR shop_item_has_category.category_line_no = '109050000' OR shop_item_has_category.category_line_no = '109040000' OR shop_item_has_category.category_line_no = '109030000' OR shop_item_has_category.category_line_no = '109020000' OR shop_item_has_category.category_line_no = '109010000' OR shop_item_has_category.category_line_no = '109000000' OR shop_item_has_category.category_line_no = '108110000' OR shop_item_has_category.category_line_no = '108100000' OR shop_item_has_category.category_line_no = '108090000' OR shop_item_has_category.category_line_no = '108080000' OR shop_item_has_category.category_line_no = '108070000' OR shop_item_has_category.category_line_no = '108060000' OR shop_item_has_category.category_line_no = '108050000' OR shop_item_has_category.category_line_no = '108040000' OR shop_item_has_category.category_line_no = '108030000' OR shop_item_has_category.category_line_no = '108020000' OR shop_item_has_category.category_line_no = '108010000' OR shop_item_has_category.category_line_no = '108000000' OR shop_item_has_category.category_line_no = '107130000' OR shop_item_has_category.category_line_no = '107120000' OR shop_item_has_category.category_line_no = '107110000' OR shop_item_has_category.category_line_no = '107100000' OR shop_item_has_category.category_line_no = '107090000' OR shop_item_has_category.category_line_no = '107080000' OR shop_item_has_category.category_line_no = '107070000' OR shop_item_has_category.category_line_no = '107060000' OR shop_item_has_category.category_line_no = '107050000' OR shop_item_has_category.category_line_no = '107040000' OR shop_item_has_category.category_line_no = '107030000' OR shop_item_has_category.category_line_no = '107020000' OR shop_item_has_category.category_line_no = '107010000' OR shop_item_has_category.category_line_no = '107000000' OR shop_item_has_category.category_line_no = '106140000' OR shop_item_has_category.category_line_no = '106130000' OR shop_item_has_category.category_line_no = '106120000' OR shop_item_has_category.category_line_no = '106110000' OR shop_item_has_category.category_line_no = '106100000' OR shop_item_has_category.category_line_no = '106090000' OR shop_item_has_category.category_line_no = '106080000' OR shop_item_has_category.category_line_no = '106070000' OR shop_item_has_category.category_line_no = '106060000' OR shop_item_has_category.category_line_no = '106050000' OR shop_item_has_category.category_line_no = '106040000' OR shop_item_has_category.category_line_no = '106030000' OR shop_item_has_category.category_line_no = '106020000' OR shop_item_has_category.category_line_no = '106010000' OR shop_item_has_category.category_line_no = '106000000' OR shop_item_has_category.category_line_no = '105080000' OR shop_item_has_category.category_line_no = '105070000' OR shop_item_has_category.category_line_no = '105060000' OR shop_item_has_category.category_line_no = '105050000' OR shop_item_has_category.category_line_no = '105040000' OR shop_item_has_category.category_line_no = '105030000' OR shop_item_has_category.category_line_no = '105020000' OR shop_item_has_category.category_line_no = '105010000' OR shop_item_has_category.category_line_no = '105000000' OR shop_item_has_category.category_line_no = '104110000' OR shop_item_has_category.category_line_no = '104100000' OR shop_item_has_category.category_line_no = '104090000' OR shop_item_has_category.category_line_no = '104080000' OR shop_item_has_category.category_line_no = '104070000' OR shop_item_has_category.category_line_no = '104060000' OR shop_item_has_category.category_line_no = '104050000' OR shop_item_has_category.category_line_no = '104040000' OR shop_item_has_category.category_line_no = '104030000' OR shop_item_has_category.category_line_no = '104020000' OR shop_item_has_category.category_line_no = '104010000' OR shop_item_has_category.category_line_no = '104000000' OR shop_item_has_category.category_line_no = '103110000' OR shop_item_has_category.category_line_no = '103100000' OR shop_item_has_category.category_line_no = '103090000' OR shop_item_has_category.category_line_no = '103080000' OR shop_item_has_category.category_line_no = '103070000' OR shop_item_has_category.category_line_no = '103060000' OR shop_item_has_category.category_line_no = '103050000' OR shop_item_has_category.category_line_no = '103040000' OR shop_item_has_category.category_line_no = '103030000' OR shop_item_has_category.category_line_no = '103020000' OR shop_item_has_category.category_line_no = '103010000' OR shop_item_has_category.category_line_no = '102220000' OR shop_item_has_category.category_line_no = '102200000' OR shop_item_has_category.category_line_no = '102190000' OR shop_item_has_category.category_line_no = '102170000' OR shop_item_has_category.category_line_no = '102150000' OR shop_item_has_category.category_line_no = '102140000' OR shop_item_has_category.category_line_no = '102120000' OR shop_item_has_category.category_line_no = '102100000' OR shop_item_has_category.category_line_no = '102090000' OR shop_item_has_category.category_line_no = '102080000' OR shop_item_has_category.category_line_no = '102070000' OR shop_item_has_category.category_line_no = '102060000' OR shop_item_has_category.category_line_no = '102050000' OR shop_item_has_category.category_line_no = '102040000' OR shop_item_has_category.category_line_no = '102030000' OR shop_item_has_category.category_line_no = '102010000' OR shop_item_has_category.category_line_no = '102000000' OR shop_item_has_category.category_line_no = '101320000' OR shop_item_has_category.category_line_no = '101310000' OR shop_item_has_category.category_line_no = '101300000' OR shop_item_has_category.category_line_no = '101290000' OR shop_item_has_category.category_line_no = '101280000' OR shop_item_has_category.category_line_no = '101270000' OR shop_item_has_category.category_line_no = '101260000' OR shop_item_has_category.category_line_no = '101250000' OR shop_item_has_category.category_line_no = '101240000' OR shop_item_has_category.category_line_no = '101230000' OR shop_item_has_category.category_line_no = '101220000' OR shop_item_has_category.category_line_no = '101210000' OR shop_item_has_category.category_line_no = '101200000' OR shop_item_has_category.category_line_no = '101190000' OR shop_item_has_category.category_line_no = '101180000' OR shop_item_has_category.category_line_no = '101170000' OR shop_item_has_category.category_line_no = '101160000' OR shop_item_has_category.category_line_no = '101150000' OR shop_item_has_category.category_line_no = '101140000' OR shop_item_has_category.category_line_no = '101130000' OR shop_item_has_category.category_line_no = '101120000' OR shop_item_has_category.category_line_no = '101110000' OR shop_item_has_category.category_line_no = '101100000' OR shop_item_has_category.category_line_no = '101090000' OR shop_item_has_category.category_line_no = '101080000' OR shop_item_has_category.category_line_no = '101070000' OR shop_item_has_category.category_line_no = '101060000' OR shop_item_has_category.category_line_no = '101050000' OR shop_item_has_category.category_line_no = '101040000' OR shop_item_has_category.category_line_no = '101030000' OR shop_item_has_category.category_line_no = '101020000' OR shop_item_has_category.category_line_no = '101010000' OR shop_item_has_category.category_line_no = '101000000')
                                                AND shop_view_active_item.language_code = 'DEU'
                                                AND shop_view_active_item.company = 'gastrotiger'
                                                AND shop_view_active_item.shop_code = 'B2C'
                                                AND shop_item_has_category.company = 'gastrotiger'
                                                AND shop_item_has_category.shop_code = 'B2C'
                                                AND shop_item_has_category.language_code = 'DEU'
                                                AND sc.company = 'gastrotiger'
                                                AND sc.shop_code = 'B2C'
                                                AND sc.language_code = 'DEU'
                                                AND sc.promotion_active = 1
                                                AND (isnull(sc.promotion_validity_from) AND isnull(sc.promotion_validity_to)
                                                    OR (isnull(sc.promotion_validity_from) AND (sc.promotion_validity_to >= curdate())
                                                    OR (sc.promotion_validity_from <= curdate()) AND isnull(sc.promotion_validity_to))
                                                    OR (sc.promotion_validity_from <= curdate()) AND (sc.promotion_validity_to >= curdate()))
                                              ORDER BY RAND()
                                              LIMIT 8 

Top-Hersteller der Kategorie