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 ('A9 T 2450101','C4 KRO3530','B7 50K20/JAPKO','C9 0986494559','A2 T 2520501','A2 RH 21302.02','C9 24501 00 701 00','A1 16816 FE','A2 GDB3461','A8 238 971','A5 284599','C4 FDB4194','A5 78690','A1 0986494422','A8 230 272','A3 CIF 822-783-0','A3 BOS 0986494422','B1 BLPADG04278','C9 PP-K13AF','B1 BREP30039','A2 BP30039','C9 ADG042161','A5 288624','B1 ATE13.0470-5600','B1 BOS0986494422','A5 287486','A1 2450101 TEX','A8 249 713','A9 BP30039','C4 GDB3530','A3 FER FDB4194','C9 25205-17,5','A2 GDB3640','A2 GDB3642','C9 0252450116/W','A1 WBP776','A8 241 195','B1 ATE13.0470-5647','B1 FEB116265','C4 KRO3461','C9 FDB4194','A1 GDB3530','A3 TEX 2520504','C9 13.0470-5647.2','B1 CIF822-783-1','B1 FEB116410','A8 249 706','C4 16816F','A5 271711','C4 2450101TX','A2 RH 21302.22','A1 13.0460-5647.2','C9 PA-K20AF','A5 408592','A3 TEX 2232901','A9 RH 21302.02','A1 P30056','A8 233 542','C9 13.0460-5526.2','A9 13.04605647.2','A9 0986494422','B1 FEB116333','E6 BP2164','C9 25205-17,5 2 5','A8 249 708','C9 GDB3461','A1 WBP1164','A2 13.04605647.2','B1 CIF822-783-0','B1 BREP30093','D1 BP ADG04278','C9 0986494422','B1 VAL302476','A2 T 2450101','B1 ZIM24501.170.1','C9 VAL301934','B1 BREP30093E','B1 VAL301934','C9 GDB3642','B1 ZIM25205.170.2','D1 BP ADG042161','C9 0986494905','B1 LUCGDB3642','C9 2520504','B1 BLPADG042163','B1 LUCGDB3530','A8 257 861','A2 13.04605600.2','A5 126132','A9 GDB3647','C4 LP2294','A3 DLP LP2294','B1 LUCGDB3640','C4 0986494559','B1 FEB116376','B1 BOS0986460077','C4 116333F','A8 228 526','B1 BLPADG042164','D1 BP ADG042163','C4 605600','A3 TEX 2450101','A2 LP2050','C4 GDB3461','A3 DLP LP2050','C9 VAL598934','A2 GDB3530','A9 GDB3530','D1 BP ADG042170','B1 ATE13.0460-5600','A9 GDB3640','B1 BLPADG042170','A8 249 585','C4 LP2050','A5 375886','B1 BOS0986494905','A5 469331','C4 24501.170.1','C9 GDB3640','A9 GDB3642','A9 GDB3461','D1 BP ADG042179','D1 BP ADG042164','A3 TEX 2520501','A5 290629','B1 ATE13.0460-5647','C9 ADG042170','A1 13.0460-5600.2','A9 RH 21302.22','C9 13.0470-5600.2','A1 GDB3461','C9 19-3023','A3 ROA 2130202','A9 FE FDB4194','A1 LP2050','A2 0986494422','A5 271704','A5 380949','C4 05P1415','A1 WBP1207','A2 GDB3647','C9 2520501','B1 BLPADG042161','A1 0986494559','C4 116265F','C9 ADG04278','A1 P30039','C9 PA-H23AF','C9 GDB3530','C9 24501-16,6','B7 KBP-4018/KAVO','B1 LUCGDB3461','B1 BREP30056E','C9 13.0460-5600.2','C4 05P1689','C4 2520501TX','A3 BOS 0986494559','B1 BREP30056X','B1 LUCGDB3647','C4 GDB3642','A1 LP2294','B7 24501.170.1','A1 2520501 TEX','B1 KAMJQ101473','B7 BP-4021/KAVO','B1 BOS0986494559','C9 0986460077','B1 BLPADG042179','C9 2450101','A3 ROA 2130222','C9 GDB3647','B1 KAMJQ101474','A5 271837','A1 FDB4194','C4 2520504TX','C4 GDB3647','B7 25205.170.2','C9 19-1986','C4 LP3535','B1 BREP30056','A8 252 871','C9 0252450116/PD','A5 289143','A2 FE FDB4194','B1 KAMJQ101149','A8 224 711','B1 FEB16816','B7 B111287/DKM','C9 ADG042164','C9 13.0460-5647.2','B1 ATE13.0460-5526','C4 0986494422','B1 VAL301324','A5 271366','A9 T 2520501','A9 13.04605600.2','E1 91 91 6816','B1 BREP30093X','A1 GDB3642','A5 436266','A8 243 701','A1 J3600564HB','A2 Q109-1664','A2 Q109-1708','A3 QUI 109-0057','A3 QUI 109-1708','A8 254 231','A9 Q109-1664','A9 Q109-1708','B1 FEB177321','B1 QB109-0057','B1 QB109-1664','B1 QB109-1708','C9 ADBP420078','C9 QB109-0057','C9 QB109-1664','C9 QB109-1708','C9 QP6702','C9 QP6702C')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #