Advand | Autóalkatrész webáruház és autóápolás

#SELECT cikk_raktar.cikkszam, cikk_tecdoc.gyarto, cikk_tecdoc.keresoAZ, cikk_tecdoc.DLNr FROM cikk_tecdoc LEFT JOIN cikk_raktar on (cikk_raktar.eredeti=cikk_tecdoc.cikkszam) WHERE ((cikk_tecdoc.cikkszam IN ('C9 2360001','A9 GDB1624','A2 GDB1464','B1 BOS0986494074','A3 TEX 2370803','A3 BOS 0986494074','A2 23708 182 14','A9 GDB1464','C9 0986494074','C4 FSL1476','C4 GDB1669','A1 P61068','A1 0986494038','A1 0986424659','C4 0986494038','C4 0986495225','A9 23708 182 14','A1 WBP401','A2 BP61068','A3 ROA 284100','B1 BLPADP154218','A2 RH 2841.00','A9 BP23119','B1 BOS0986494038','A1 GDB1624','A2 0986494074','E7 331.1','A5 170162','A8 236 865','A9 23600 190 14','A2 FE FDB1476','C4 GDB1464','A2 GDB1669','A1 0986495225','B1 BOS0986494602','B1 LUCGDB1669','B1 VAI22-0063','B1 BREP61068','A9 BP61068','A3 TEX 2360001','C9 2370803','A2 05P807','A3 ROA 284180','A1 GDB1669','E1 62 91 6422','A3 TEX 2509401','C4 2360001TX','C9 VAL598465','A3 BOS 0986494038','A1 598698','A8 227 313','C9 VAL598698','C9 GDB1464','A3 CIF 822-322-1','A9 0986494038','C9 0986494602','C4 05P807','A2 05P1192','A1 2370803 TEX','C4 05P1192','A1 WBP532','C9 25094-19,0','C4 GDB1624','C4 GDB1591','A1 P23119','B1 ABS37418','C4 2370803TX','A2 BD S248','B1 BLPADL144217','D1 BP ADL144217','B1 FEB16422','A2 RH 2859.10','A8 207 196','D1 BP ADP154218','C9 23600-19,0','C9 0986494038','A3 ROA 285910','A5 116694','B1 BREP23119','C4 KRO1464','C9 FDB1476','A1 FSL1476','C9 23708-18,2 1 4','A2 T 2509401','B1 CIF822-322-1','C4 FDB1476','A9 RH 2841.00','A3 FER FDB1476','A8 207 195','A1 598465','C9 2509401','A2 BP23119','A2 23600 190 14','B1 ZIM23600.990.1','A9 0986494074','A1 GDB1464','A9 FE FDB1476','A8 230 173','A3 BOS 0986495225','A1 16422 FE','A9 GDB1669','C9 GDB1669','A1 FDB1476','A1 0986494074','B1 ABS37273','B1 LUCGDB1624','C9 0252370819','C4 16422F','A2 0986494038','A3 TRW GDB1464','A9 05P807','B1 LUCGDB1464','A3 VAC V22-0063','A9 BD S248','A2 07.B314.11','A5 43122','A2 GDB1624','C9 GDB1624','A1 GDB1676','A8 221 263','A1 GDB1591','A1 13.0460-3811.2','A1 13.0460-3966.2','A1 13.0470-3966.2','A1 FDB5028','A1 GDB1605','A1 GDB1750','A1 WBP515','A2 GDB1605','A2 Q109-1218','A2 RH 21030.10','A3 FER FDB5028','A3 QUI 109-1218','A3 ROA 2103010','A5 76369','A5 96352','A8 206 986','A8 230 373','A8 241 377','A9 13.04603811.2','A9 13.04603966.2','A9 13.04703966.2','A9 GDB1464DTE','A9 GDB1605','A9 GDB1750','A9 Q109-1218','A9 RH 21030.10','B1 ATE13.0460-3811','B1 ATE13.0460-3966','B1 ATE13.0470-3966','B1 BREP61068X','B1 BREP61137','B1 FEB16554','B1 KAMJQ1012952','B1 LUCGDB1464DTE','B1 LUCGDB1605','B1 LUCGDB1750','B1 QB109-1218','B1 VAL301465','B1 VAL301698','B7 0841.00/REM','B7 0859.10/REM','B7 1030.10/REM','B7 B110599/DKM','B7 B111074/DKM','C4 16554F','C4 16964F','C4 603811','C4 603966','C4 FDB5028','C4 GDB1464DTE','C4 GDB1605','C4 GDB1750','C9 0252360019','C9 0252360019/PD','C9 0252509419','C9 13.0460-3811.2','C9 13.0460-3966.2','C9 13.0470-3966.2','C9 19-0576','C9 23600 00 701 00','C9 GDB1464DTE','C9 GDB1605','C9 GDB1750','C9 PA-0080AF','C9 QB109-1218','C9 QP3797','C9 QP3797C','E1 70 91 6554','E7 AC0581268D','E7 AC600281D')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #