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