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 BOS 0986460964','A3 BOS 0986494009','A1 P71006','A5 131294','A2 13.04703605.2','A2 0986494009','C9 GDB1344DTE','B1 BOS0986494009','A1 WBP118','A1 13.0460-3605.2','C9 0252160717','C9 13.0470-3605.2','A1 WBP123','A3 TEX 2160702','A1 P06025','B1 BREP71006','A1 0986424667','C4 05P675','A9 13.04703605.2','A2 21934.170.9','A8 215 809','C4 05P297','A2 0986424667','C9 FE16351','A1 13.0470-3605.2','C4 2193402TX','C9 VAL301753','A1 16351 FE','A1 0986424484','A8 220 339','A9 FE FDB1867','C9 21934-17,3','A9 GDB1344DTE','A3 TEX 2160781','A5 206833','A3 FER FDB1301','C4 GDB1344DTE','A9 0986494009','B1 LUCGDB1344DTE','B1 BOS0986460964','B1 BOS0986424667','C9 21607-17,3','C9 21607-17,3 EPAD','B1 ZIM21934.170.2','A2 05P675','B7 21934.170.9','C9 221516','C4 21934.170.9','A5 72865','A5 124457','C4 0986424484','C9 0986424667','A8 127 474','A2 LP1423','B1 VAL301386','A1 0986494009','A5 180828','B1 FEB16351','A1 LP1423','B1 VAI20-8107','C4 21934.170.1','A1 FDB1867','B1 ABS37267','B7 21934.170.2','A2 13.04603605.2','C9 0986460964','C9 221524','A2 FE FDB1867','A1 598386','A2 0986460964','B7 0265.30/REM','C9 VAL598386','C9 2193402','D2 EO 05P297','C9 VAL301386','B1 VAI20-8116','A8 234 803','A9 BP71006','C9 2160702','A3 BOS 0986424484','A2 GDB1344DTE','C4 LD3605','C9 13.0460-3605.2','A3 FER FDB1867','C9 2193481','A8 203 503','A2 FE FDB1301','A5 43148','C9 21934-17,3 EPAD','A2 21607 173 05','B1 VAL301753','A3 BOS 0986424667','C4 LP1423','C9 0986494009','B1 FEB16196','C9 0252193417','A1 FDB1301','A9 FE FDB1301','A1 16196 FE','C4 05P463','E1 20 91 6196','A3 TEX 2193481','A8 232 294','B7 0265.41/REM','A1 FQT1301','C9 0986424484','A2 0986424484','A3 DLP LP1423','B1 ZIM21934.170.9','A8 218 406','A9 0986460964','A3 TEX 2193404','A2 05P297','A8 229 585','A2 21934 163 05','A2 BP71006','A8 203 505','B1 BOS0986424484','A2 T 2160781','A3 TEX 2193402','C4 0986494009','A9 BP06025','B7 0265.00/REM','A9 13.04603605.2','C4 16196F','C9 0252193417/PD','C4 FDB1867','A9 0986424484','A2 05P463','A9 21934 173 05','A3 VAC V20-8116','B1 ATE13.0460-3605','A9 0986424667','C9 VAL598753','B1 BREP06025','A5 41110','B7 21934.170.1','A1 GDB1344DTE','A2 21934 173 05','A1 FSL1301','B7 SP 198','C4 FDB1301','A1 0986460964','A8 234 056','A2 BP06025','B7 0265.40/REM','A9 21934 163 05','C4 603605','C9 21934-16,3','B1 ATE13.0470-3605','A9 21607 173 05','C9 2193404','B1 ZIM21934.170.1','A3 VAC V20-8107','C9 FDB1301','A9 21934.170.9','A3 ROA 226540','A2 RH 2265.40','A2 21934.970.1','A2 Q109-1097','A2 Q109-1123','A2 QWS0192A','A3 CIF 822-261-0','A3 QUI 109-1097','A3 QUI 109-1123','A3 QUI WS0197A','A8 203 699','A9 Q109-1097','A9 Q109-1123','A9 QWS0192A','A9 RH 2265.40','B1 BLPADB114227','B1 CIF822-261-0','B1 KAMJQ1011700','B1 QB109-1097','B1 QB109-1123','B1 QBWS0192A','B1 ZIM21934.970.1','B7 B111092/DKM','C9 19-0526','C9 19-2865','C9 PP-0105AF','C9 QB109-1097','C9 QB109-1123','C9 QBWS 0197 A','C9 QP2191','C9 QP2191C')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #