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 ('A3 VAC V10-8172','B1 VAI10-8172-1','A9 T 2469602','A2 0986424797','A9 GDB1550DTE','A2 FE FSL1641','A3 DLP LP1837','C9 13.0470-7184.2','A8 219 796','B1 LUCGDB1550DTE','C9 VAL598635','C4 GDB1550DTE','A3 TEX 2358704','A8 224 100','C4 2469602TX','C4 FDB1641','A1 FDB1641-PROMO','A2 T 2358781','A1 2358701 TEX','A2 05P866','C4 2358781TX','C4 23587.200.1','C9 13.0460-7226.2','C9 0986494525','A5 76273','E1 30 91 6502','B1 BREP85105','A2 LP1837','C4 607226','B1 VAL301635','A1 13.0460-7226.2','A2 BP85105','C9 23587-20,3 EPAD','A3 TEX 2469602','C9 GDB1550DTE','A9 13.04707226.2','A2 T 2469602','C4 05P866','A1 573128JC JRD','B1 BOS0986424797','A1 FSL1641','A3 BOS 0986424797','A2 13.04607184.2','A2 13.04707184.2','A8 228 197','A2 13.04607226.2','B1 TRU07.35.137','A1 P85075','C9 FDB1641','C4 607184','A9 05P866','A3 TEX 2358781','C9 0252358720/W','A9 BP85075','C9 ADV184204','A9 BP85105','B7 1030.01/REM','C9 23587-20,3','B1 BREP85075','B1 ATE13.0460-7226','A8 220 435','C1 RH 21030.01','C9 24696-20,3 9 5','A1 P85075X','B1 ATE13.0470-7184','A2 FE FDB1641','C9 224770','A8 215 483','C9 2358701','A5 206913','A2 BP85075','A2 23587 203 05','B1 BOS0986494525','A1 0986494525','C9 23587-20,3 9 5','C4 LP1837','A3 DLP LP1904','B1 ABS37414','A3 BOS 0986494525','B1 BREP85075X','A3 TRU 07.35.137','A1 0986424797','B1 ATE13.0470-7226','A3 ROA 2103001','A1 573128J JRD','A5 194871','A1 13.0470-7226.2','A2 T 2358704','C9 13.0460-7184.2','C9 2469602','B1 ZIM23587.200.1','C4 FDB1641W','B1 FEB16502','A3 TEX 2358782','C9 VAL872587','C9 2358704','A5 116725','B1 ATE13.0460-7184','C4 0986494525','D1 BP ADV184204','A9 0986424797','C4 0986424797','A5 47976','C4 LD7184','A3 TEX 2358701','B1 VAI10-8172','A1 598635','C9 0252358720/PD','C4 16502F','C4 LD7226','A9 23587 203 05','A5 66270','A1 FDB1641','A1 LP1904','C4 2358701TX','C4 2358704TX','A8 253 178','A8 234 085','A1 LP1837','C9 13.0470-7226.2','A2 13.04707226.2','A9 13.04607226.2','A1 GDB1550DTE','A3 FER FDB1641','A9 RH 21030.01','A3 VAC V10-8172-1','C9 0986424797','A8 233 945','C9 VAL301635','A1 13.0470-7184.2','A1 13.0460-7184.2','A9 13.04707184.2','B1 BLPADV184204','C9 23587-20,3 9 5 EPAD','A1 P85105','A2 GDB1550DTE','A1 16502 FE','A2 RH 21030.01','A9 13.04607184.2','B7 23587.200.1','A9 FE FDB1641','C9 2358782','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','A1 GDB1550','C4 GDB1550')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #