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