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 ('A2 GDB3461','B1 LUCGDB3530','C4 KRO3530','B1 FEB116376','A3 TEX 2232901','A1 LP2050','A5 288624','A5 289143','A5 287486','A3 ROA 2130222','C9 0252450116/W','C9 PA-H23AF','A3 ROA 2130202','C4 N3600330','A1 WBP1207','C9 VAL301934','A9 T 2450101','A5 290629','A9 0986494422','B1 LUCGDB3461','C4 24501.170.1','C4 LP3535','C9 24501 00 701 00','B7 SP 650','A8 249 585','C9 QP9180C','B1 BLPADG042164','A2 RH 21302.22','C4 0986494422','B1 KAMJQ101473','D1 BP ADG04278','A2 GDB3647','A8 254 044','C9 ADG04278','C9 0986494422','A2 BP30039','A9 13.04605647.2','A2 0986494422','A3 VAC V52-0071','A1 FDB4194','C4 05P1689','B1 BLPADG04278','A9 GDB3461','B1 ATE13.0460-5600','A1 13.0460-5600.2','A9 N3600330','A9 13.04605600.2','C4 GDB3461','B1 VAI52-0071','A3 CIF 822-783-0','B1 BOS0986494905','C9 2450101','C9 0252450116/PD','C9 QP9180','A3 FER FDB4194','A2 T 2520501','A1 LP2294','A1 2520501 TEX','B7 KBP-4018/KAVO','C9 QP6702C','A5 375886','B1 VAL301324','A9 GDB3640','B7 24501.170.1','C4 FDB4194','A1 GDB3530','B7 BP-4021/KAVO','B1 BREP30056','C9 19-3023','A1 13.0460-5647.2','B1 BOS0986494422','C9 GDB3530','C9 GDB3640','A1 2450101 TEX','A9 T 2520501','B1 FEB116410','A2 RH 21302.02','A3 BOS 0986494422','C4 LP2294','A1 WBP776','B1 ABS35256','B1 CIF822-783-0','A8 238 971','A9 FE FDB4194','B1 ATE13.0470-5600','B1 ZIM24501.170.1','C4 05P1415','A1 0986494422','B1 BREP30056X','A1 50-0K-K20ASK','D1 BP ADG042170','A1 P30039','A1 P30056','B1 LUCGDB3640','A5 78690','B1 KAMJQ101474','C9 ADG042164','C4 116333F','B1 BREP30039','B7 1302.02/REM','A2 13.04605647.2','A8 249 713','B1 BLPADG042161','A2 LP2050','A9 GDB2173','A9 GDB3530','A8 243 701','C4 KRO3461','A5 271711','D1 BP ADG042163','B1 BLPADG042170','C9 25205-17,5','B1 BLPADG042163','A2 13.04605600.2','A3 TEX 2520501','A2 GDB2173','C9 GDB3647','A2 GDB3640','C4 2450101TX','A5 284599','A3 ROA 2167602','B1 VAL301934','C4 LP2050','C4 GDB3530','A3 TEX 2450101','A1 GDB3461','D1 BP ADG042179','C4 605600','A2 FE FDB4194','B1 TOM1644','A5 436266','A3 DLP LP2050','C9 13.0460-5600.2','C9 GDB3461','C9 24501-16,6','A5 126132','B1 KAMJQ101149','A9 RH 21302.02','A5 271837','A1 16816 FE','A3 DLP LP2294','C9 VAL598934','B1 FEB116265','B1 BLPADG042179','B1 LUCGDB2173','B1 LUCGDB3647','B1 FEB116333','C9 GDB2173','C9 0986494905','B1 FEB16816','A2 BD S544','C9 PA-K20AF','E1 91 91 6816','A9 RH 21302.22','C9 PP-K13AF','C9 13.0460-5647.2','C4 116265F','A2 T 2450101','C9 19-1986','C4 16816F','A8 228 526','A9 GDB3647','A9 BD S544','B7 3663600719/JP','C9 QP6702','A8 249 706','A2 N3600330','C9 ADG042170','A8 224 711','A5 469331','B1 ATE13.0460-5647','C9 2520501','A2 GDB3530','A8 230 272','A8 241 195','C9 FDB4194','C4 2520501TX','A9 BP30039','E6 BP2164','C4 GDB3647','D1 BP ADG042164','C9 13.0470-5600.2','B1 TOM1747','A5 271366','A8 233 542','C9 ADG042161','D1 BP ADG042161','B7 50K20/JAPKO','A5 408592','B1 ATE13.0470-5647','B1 ZIM25205.170.2','B7 25205.170.2','B7 B111287/DKM','C9 13.0470-5647.2')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #