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