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