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 ('B7 21312.130.2','B1 BOS0986461131','A2 RH 2233.52','A9 J3614004','A1 0986495256','C9 13.0460-5998.2','A2 FE FDB778','C9 PF0457','C9 GDB3113','A9 FE FDB778','A9 21312 130 05','A1 WBP542','B7 21719.150.1','A3 CIF 822-176-1','A1 J3614004HB','B1 ABS36173','C9 21312-13,0','B7 BP-2031/KAVO','A1 GDB3160','B1 ZIM21719.150.1','C4 LP625','A3 DLP LP625','B7 BP-2029/KAVO','B7 0233.42/REM','A2 21312 130 05','A1 P28017','B1 ATE13.0460-5998','A2 LP625','A2 BP28025','A2 05P506','A9 13.04605998.2','B1 KAMJQ101944','A2 05P1425','B1 LUCGDB3113','A9 FE FDB621','C4 J3614007','B1 LUCGDB3174','A1 598437','A3 BOS 0986495256','C4 GDB3174','C9 19-0431','C9 2131201','C9 QP1584C','A1 P28025','E7 176.0','A8 228 676','A1 LP772','C9 GDB3174','C4 GDB499','A5 291029','C9 13.0460-5731.2','B1 CIF822-170-0','A2 J3614007','B1 TOM1099','A3 TRW GDB3174','A2 RH 2233.20','A9 BP28025','A2 13.04605998.2','B7 B110662/DKM','A8 209 838','C4 LP1456','A5 206711','A1 51-04-402ASK','A1 0986494392','A3 ROA 223320','A9 0986461131','B7 21312.130.1','A3 BOS 0986461131','A1 LP625','A3 ROA 223352','A2 0986494392','B7 KBP-2007/KAVO','C4 0986495256','A2 21738 130 05','A2 LP772','B7 0233.52/REM','A9 RH 2325.32','C4 605998','B1 CIF822-170-1','A8 217 765','A3 FER FDB472','A3 CIF 822-173-0','C9 FDB778','B1 BREP28025','A9 21738 130 05','A1 GDB499','A9 GDB499','A8 229 179','B1 CIF822-176-1','A2 FE FDB621','A8 230 490','C1 RH 2233.52','A1 FDB778','B1 CIF822-176-0','B1 LUCGDB499','A2 RH 2183.02','C9 0252131313/W','B1 BREP28017','B1 ATE13.0460-5731','A1 LP1456','A2 0986461131','B1 ABS36870','A3 ROA 223342','B1 VAI26-0024','C9 21738-13,0','B1 VAL301053','A9 RH 2233.52','C4 J3614004','A9 J3614007','A5 32817','B1 TOM1532','A1 0986494128','A1 13.0460-5731.2','A3 DLP LP1456','C9 2173801','D1 BP ADH24254','B1 TOM1722','A2 0986495256','C4 05P506','B7 51404/JAPKO','A3 VAC V26-0024','C4 FDB778','A3 FER FDB621','C9 0986494392','A2 FE FDB472','C4 605731','A3 ROA 218302','A9 0986494392','A1 598053','C9 0986494128','A8 209 828','A1 GDB3113','B7 0233.20/REM','C9 QP1584','A3 JAP PP-404AF','A8 205 639','A3 TEX 2173801','A2 LP1456','C9 VAL598053','E6 BP1746','C9 PP-404AF','C9 VAL598437','A8 241 676','B7 0233.00/REM','C9 VAL301053','C9 PF0460','A9 BP28017','C9 GDB499','A2 05P072','B1 FRE901092','C4 2173801TX','C9 PP-402AF','A2 05P505','A9 GDB3174','A2 RH 2325.32','A3 TEX 2131201','A3 BOS 0986494128','A2 GDB3174','A1 51-04-404ASK','C9 19-1984','B1 CIF822-173-0','A1 FDB621','B7 51402/JAPKO','A2 0986494128','A3 FER FDB778','E1 85 91 6301','A5 40130','A3 ROA 223300','A8 233 653','A1 GDB3174','B1 BOS0986494392','B1 ZIM21738.130.1','C9 ADH24254','A8 215 848','C9 0986461131','B1 ABS36619','A8 203 422','B1 ZIM21312.130.1','B1 BOS0986494128','B1 KAMJQ101191','A3 DLP LP772','C9 QP0406','B1 ABS36636','A3 ROA 232532','A1 FDB472','B7 21738.130.1','B1 ZIM21312.130.2','A8 230 244','B1 BLPADH24254','C9 0252173813/W','A1 0986461131','A2 J3614004','C9 QP0406C','A1 13.0460-5998.2','A2 GDB499','A3 BOS 0986494392','A2 BP28017')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #