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 ('A2 13.04707184.2','B1 ATE13.0470-7184','B1 FEB116210','A2 T 2358781','A2 BP85075','C9 0986424797','C4 607184','A9 GDB2025','C9 PA-0047AF','A5 206913','A2 GDB1807','A9 BP85105','A8 234 085','A9 RH 21030.01','B1 FEB16502','A9 FE FDB1641','A9 T 2469602','A1 P85075','A2 13.04707226.2','A8 230 215','A5 116725','A1 13.0470-7226.2','B1 VAL301635','C9 ADV184204','C9 PA-0610AF','C4 GDB2025','A1 13.0460-7226.2','C9 VAL598635','A3 TEX 2358701','B1 ATE13.0460-7226','A3 DLP LP1904','B1 ZIM23587.900.1','C4 16502F','C4 2358781TX','A9 13.04607226.2','C9 FDB1641','A1 0986424797','A2 0986424797','C4 FDB1641W','A1 P 85 146X','A1 P 85 146','C4 GDB1807','A9 05P866','A1 598635','C4 2469602TX','A8 215 483','B1 BREP85105','C9 13.0470-7226.2','A5 212805','C9 GDB1550DTE','A1 LP1904','C4 LD7184','A1 GDB1550DTE','C9 GDB1807','A2 23587 203 05','C9 VAL301635','C9 24696-20,3 9 5','A2 T 2469602','C9 2469602','C4 607226','B1 LUCGDB2025','A2 RH 21030.01','A1 13.0470-7184.2','B1 LUCGDB1807','A1 P85075X','C9 GDB1550','C4 2358704TX','A1 573128JC JRD','A3 TEX 2469602','A8 228 197','B1 LUCGDB1550DTE','B1 BOS0986424797','C9 23587-20,3 EPAD','A9 0986424797','B1 LUCGDB1550','A2 13.04607226.2','A1 FDB1641','A1 WBP555','B1 BREP85075X','A1 P85105','B7 1030.01/REM','C4 FDB1641','A2 13.04607184.2','A9 GDB1807','A8 220 435','C4 2358701TX','B1 ZIM23587.200.1','C9 13.0460-7226.2','C4 LP1837','A9 GDB1550DTE','A2 LP1837','A2 T 2358704','A2 GDB1550DTE','A2 05P866','B1 BLPADV184204','A3 FER FDB1641','A1 GDB1807','A1 GDB1550','B1 BREP85146X','A1 573128J JRD','A2 FE FDB1641','B1 ATE13.0460-7184','A9 13.04707184.2','A9 13.04707226.2','C9 VAL872587','A3 JAP PA-0047AF','A9 BP85075','C4 KRO1550','A1 16502 FE','C4 GDB1550','A1 116210 FE','A8 224 100','A3 TEX 2358704','B1 BREP85075','A3 ROA 2103001','A8 219 796','A9 23587 203 05','C9 23587-20,3 9 5','B1 BREP85146','C4 LD7226','B7 23587.200.1','A2 GDB1550','A5 47976','C4 0986424797','C4 23587.200.1','A3 BOS 0986424797','A1 FDB1641-PROMO','A1 2358701 TEX','A1 GDB2025','C9 2358704','A9 GDB1550','C1 RH 21030.01','C9 GDB2025','B1 ATE13.0470-7226','A5 76273','A2 BP85105','A5 194996','C4 GDB1550DTE','A2 GDB2025','C4 05P866','A3 TEX 2358781','A3 DLP LP1837','C9 2358701','A8 241 438','C9 13.0460-7184.2','D1 BP ADV184204','A8 253 178','A9 13.04607184.2','A1 LP1837','C9 23587-20,3','A5 66270','C9 13.0470-7184.2','C4 1170007','A8 241 430','A1 13.0460-7184.2','A5 194871','A1 P61076','A2 07.B314.52','A2 BD S833P','A2 BP61076','A2 Q109-1678','A2 RH 2758.00','A3 CIF 822-548-0','A3 QUI 109-1678','A3 ROA 275800','A8 220 932','A9 BD S833P','A9 BP61076','A9 Q109-1678','A9 RH 2758.00','B1 ABS37414','B1 BREP61076','B1 BREP61076X','B1 CIF822-548-0','B1 KAMJQ1013282','B1 QB109-1678','B1 ZIM24696.200.2','B7 0758.00/REM','B7 B110858/DKM','C9 0252358720/PD','C9 0252358720/W','C9 19-0638','C9 23587 00 701 10','C9 27-1452','C9 QB109-1678','C9 QP4073','C9 QP4073C')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #