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 ('C4 LP1837','C9 ADV184204','B1 VKA66980939201','B1 BREP85075','A3 TEX 2358781','A8 215 483','B1 FEB16502','C4 GDB1807','A8 233 945','C4 FDB1641W','C9 2358782','A1 P 85 146X','C4 FDB1641','A1 598635','D1 BP ADV184204','A1 FDB1641-PROMO','A3 CIF 822-548-0','A3 TEX 2469602','A9 FE FDB1641','C9 23587-20,3 9 5','B1 CIF822-548-0','A2 05P866','A2 23587 203 05','C9 2358701','A1 GDB1550','C9 13.0460-7184.2','C4 2358701TX','A1 P 85 146','A2 RH 21030.01','A2 BP85105','B1 BREP85105','B1 LUCGDB1807','B1 BREP85146','A8 228 197','A3 ROA 2103001','A3 VAC V10-8172-1','C6 103138','A9 GDB1807','C9 13.0460-7226.2','A3 FER FDB1641','B1 TOM1311','A5 194871','A2 GDB1550','A9 RH 21030.01','A5 206913','A8 253 178','C9 FDB1641','A3 TRU 07.35.137','C4 2358704TX','C4 2358781TX','E1 30 91 6502','A8 230 215','C4 GDB1550DTE','A1 573128JC JRD','C4 607184','C9 0252358720/W','B1 VAI10-8172-1','A1 GDB1807','A1 P85105','A1 WBP555','B7 1163601110/JP','B1 BREP85146X','C9 24696 00 701 10','A2 13.04707184.2','C4 LD7184','B1 VAL301635','A3 TEX 2358701','C4 986424797','B1 BREP85075X','C9 PF0178','C9 0986424797','A3 DLP LP1904','C9 VAL301635','A9 GDB1550DTE','A2 T 2358781','A1 P85075','C9 QP9849C','A1 13.0460-7226.2','B1 ATE13.0470-7184','C9 BPQ1171','B1 ZIM23587.200.1','A2 13.04607226.2','A9 13.04707184.2','C4 GDB1550','B1 LUCGDB1550DTE','C9 PF0657','C9 24696-20,3 9 5','C9 23587-20,3','A3 DLP LP1837','B1 LUCGDB1550','B1 KAMJQ1013282','B1 VAI10-8172','C9 PF0135','A2 T 2469602','A2 GDB1807','A3 TEX 2358782','A3 VAC V10-8172','C9 VAL872587','A1 P85075X','C9 23587-20,3 9 5 EPAD','C9 QP4073C','A9 BD S833P','A2 13.04607184.2','A1 FDB1641','A8 224 100','A9 0986424797','A9 BP85105','A1 16502 FE','C9 EBCDP41517R','C1 RH 21030.01','A1 LP1904','C9 19-3405','A5 47976','A3 BOS 0986424797','C4 23587.200.1','C9 GDB1550DTE','A1 13.0470-7184.2','C4 KRO1550','C9 PA-0047AF','C4 0986424797','A5 66270','B1 BLPADV184204','C4 2469602TX','C9 2358704','B1 ATE13.0460-7184','A9 13.04607226.2','A8 241 430','A8 234 085','A2 FE FDB1641','C9 13.0470-7184.2','B1 ABS37414','B7 1030.01/REM','A9 23587 203 05','C4 1170007','A2 BD S833P','C9 GDB1550','C9 QP4073','A1 0986424797','A5 76273','B1 BOS0986424797','A2 T 2358704','A1 GDB1550DTE','A5 116725','A3 JAP PA-0047AF','C9 VAL598635','C9 0252358720/PD','A8 219 796','A1 LP1837','A2 0986424797','C9 23587 00 701 10','A9 13.04607184.2','C9 19-0638','B1 ATE13.0460-7226','C4 16502F','C4 607226','C9 GDB1807','B1 TRU07.35.137','B7 B110858/DKM','A1 2358701 TEX','C9 2469602','A5 194996','A1 13.0460-7184.2','B1 ZIM23587.900.1','A9 T 2469602','A8 220 435','A9 05P866','C4 05P866','C9 QP9849','A2 GDB1550DTE','B7 23587.200.1','A1 573128J JRD','A9 GDB1550','B1 VKA66980009201','A2 LP1837','C9 23587-20,3 EPAD','A3 TEX 2358704','A9 BP85075','A2 BP85075','C6 007336','B1 ZIM24696.200.2')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #