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 BP85075','A2 13.04607226.2','C4 23587.200.1','A3 FER FDB1641','A1 573128JC JRD','B1 TRU07.35.137','C9 VAL301635','A2 T 2358781','A1 GDB1550DTE','C4 LD7226','C9 24696-20,3 9 5','A2 13.04607184.2','C9 13.0460-7226.2','C9 ADV184204','C4 LP1837','A3 TEX 2469602','C4 0986424797','C4 16502F','B1 ATE13.0470-7184','A2 23587 203 05','A9 0986424797','B7 23587.200.1','A1 573128J JRD','A9 GDB1550DTE','B1 ZIM23587.200.1','B1 BLPADV184204','B1 BREP85075','A8 234 085','A3 TEX 2358782','A8 219 796','C4 2358781TX','A1 LP1904','B1 VAI10-8172','A1 LP1837','A1 13.0460-7226.2','A8 224 100','A5 116725','C9 23587-20,3 9 5 EPAD','A9 05P866','C9 GDB1550DTE','C4 05P866','C4 FDB1641','C1 RH 21030.01','A1 FSL1641','A9 23587 203 05','A2 T 2358704','B1 VAL301635','A5 76273','B1 BREP85075X','C9 23587-20,3','C9 23587-20,3 EPAD','A2 LP1837','C9 0986424797','A5 194871','A1 2358701 TEX','C4 607184','C4 GDB1550DTE','B1 BOS0986424797','C9 224770','A9 RH 21030.01','A3 TEX 2358701','A2 T 2469602','A2 BP85075','A3 TEX 2358704','C9 2358704','A8 215 483','C4 607226','A2 GDB1550DTE','B1 ATE13.0460-7184','B7 1030.01/REM','B1 ATE13.0470-7226','C9 13.0470-7184.2','C9 2469602','A3 VAC V10-8172-1','A2 BP85105','A1 P85075','A2 FE FDB1641','C9 13.0470-7226.2','A9 13.04607184.2','A3 TRU 07.35.137','A2 0986424797','A2 RH 21030.01','C9 2358782','C9 VAL598635','A9 FE FDB1641','C4 2469602TX','A9 13.04707184.2','A1 16502 FE','C9 0252358720/W','A1 13.0470-7226.2','A1 FDB1641-PROMO','A3 DLP LP1904','A8 220 435','A5 206913','A8 253 178','A3 DLP LP1837','C9 0986494525','A3 BOS 0986494525','C9 23587-20,3 9 5','C9 VAL872587','C9 FDB1641','A1 0986424797','A1 P85105','B1 BOS0986494525','C4 LD7184','C9 2358701','C4 FDB1641W','A2 13.04707184.2','A1 13.0470-7184.2','A9 13.04707226.2','E1 30 91 6502','B1 ABS37414','A1 FDB1641','B1 ATE13.0460-7226','A2 FE FSL1641','C4 0986494525','A1 0986494525','A8 228 197','B1 VAI10-8172-1','A5 66270','C4 2358704TX','A2 13.04707226.2','A9 13.04607226.2','A3 VAC V10-8172','A3 TEX 2358781','C9 0252358720/PD','D1 BP ADV184204','A1 P85075X','B1 FEB16502','C9 13.0460-7184.2','A9 BP85105','B1 LUCGDB1550DTE','A1 13.0460-7184.2','A9 T 2469602','A3 BOS 0986424797','A8 233 945','A1 598635','B1 BREP85105','C4 2358701TX','A5 47976','A2 05P866','A3 ROA 2103001','A1 P 85 146','A1 P 85 146X','A2 07.B314.52','A2 BD S833P','A2 Q109-1678','A2 Q113-1306','A2 Q113-1306X','A3 CIF 822-548-0','A3 JAP PA-0047AF','A3 QUI 109-1678','A3 QUI 113-1306','A3 QUI 113-1306X','A8 203 802','A8 204 498','A8 220 932','A9 BD S833P','A9 Q109-1678','A9 Q113-1306','A9 Q113-1306X','B1 BREP85146','B1 BREP85146X','B1 CIF822-548-0','B1 KAMJQ1013282','B1 QB109-1678','B1 QB113-1306','B1 QB113-1306X','B1 ZIM23587.900.1','B7 B110858/DKM','C4 1170007','C9 19-0638','C9 19-3405','C9 23587 00 701 10','C9 24696 00 701 10','C9 27-1452','C9 PA-0047AF','C9 QB109-1678','C9 QB113-1306X','C9 QP4073','C9 QP4073C','C9 QP9849','C9 QP9849C')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #