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 ('A1 GDB1258','B7 0265.41/REM','A1 FDB1301','A1 FQT850','A3 ROA 226540','C9 2193402','A3 TRW GDB1258','B1 BOS0986424484','A9 GDB1258','A3 FER FDB850','A9 GDB1343','A1 FSL1301','B1 BREP06011','A1 GDB1344','B1 BOS0986460964','C4 FDB1867','A2 21934 173 05','C9 21607-17,3','C9 13.0470-3605.2','A9 21934 163 05','A5 195038','A5 131294','A9 RH 2265.50','B1 LUCGDB1343','C9 FE16351','A3 TEX 2193404','C9 0986460964','C9 VAL301753','A2 FE FDB1867','C4 LD3605','A8 203 503','A1 0986424667','A3 BOS 0986424667','C9 GDB1258','C4 FSL850','A9 13.04703605.2','C4 2193402TX','A1 LP907','A2 GDB1343','C4 KRO1344','B7 21934.170.1','B1 ZIM21934.170.1','C9 0986424484','A2 FE FDB1301','A1 13.0470-3605.2','A2 GDB1258','C4 21934.170.1','A9 BP06025','A1 FQT1301','A1 0986424484','A2 BP06011','A2 RH 2265.41','A9 21934 173 05','A1 FSL850','A2 FE FDB850','A5 43148','A3 ROA 226541','C9 VAL301386','B1 LUCGDB1258','B7 20180.170.1','A9 0986424667','A9 BP06011','A5 41110','B1 VAL301753','A8 215 809','C4 16176F','A2 BP06013','B1 ZIM20180.170.1','C9 21934-17,3','B1 BOS0986424667','A9 GDB1344','A3 TEX 2193402','B1 LUCGDB1189','A2 LP1423','A9 GDB1189','C9 GDB1343','A2 0986424484','A3 TEX 2160702','B1 FEB16351','A1 598386','A2 21607 173 05','A9 FE FDB1867','A3 ROA 226530','A2 RH 2265.40','A1 GDB1189','C4 FDB850','B1 FEB16176','B7 0265.30/REM','A2 0986424667','A1 P06011','C9 FDB1301','B1 BREP06025','C4 05P463','A1 16176 FE','A1 F026000009','C9 2160702','C9 VAL598386','A8 218 406','A9 0986424484','A9 FE FDB1301','C4 GDB1344','A2 BP71006','C9 2193404','B7 0265.40/REM','A9 BP06013','A5 206833','A1 P71006','A1 FDB850','A2 GDB1344','C4 LP1423','A1 WBP118','C4 FDB1301','A1 16196 FE','C9 0986424667','C9 FE16176','B7 0265.50/REM','C4 16196F','A2 LP907','A8 230 119','C9 VAL598753','A2 RH 2265.30','A1 WBP116','A9 FE FDB850','B1 BREP06013','A2 05P463','C9 GDB1189','A2 0986460964','C9 21934-16,3','A1 GDB1343','A1 0986460964','A2 13.04703605.2','A9 0986460964','A2 RH 2265.50','C9 GDB1344','A3 FER FDB1301','B1 VAL301386','A8 203 505','A3 DLP LP907','C4 LP907','A3 BOS 0986460964','A1 GDB1430','A1 LP1423','A2 21934 163 05','A8 241 692','B1 ATE13.0470-3605','A1 P06025','B1 LUCGDB1344','A9 RH 2265.40','A3 BOS 0986424484','A9 BP71006','B1 BREP71006','A3 ROA 226550','A3 DLP LP1423','A1 FDB1867','A8 234 803','A1 16351 FE','A9 21607 173 05','A1 P06013','B1 FEB16196','A2 BP06025','A2 GDB1189','C4 0986424484','A3 FER FDB1867','A1 GDB917','A1 WBP564','A2 21934.170.9','A2 21934.970.1','A2 GDB917','A2 Q109-1097','A2 Q109-1123','A2 QWS0192A','A2 RH 2265.00','A3 QUI 109-1097','A3 QUI 109-1123','A3 QUI 109-1241','A3 QUI WS0104A','A3 QUI WS0106A','A3 QUI WS0161A','A3 QUI WS0197A','A3 ROA 226500','A8 203 699','A8 230 234','A8 234 056','A9 GDB1344DTE','A9 GDB917','A9 Q109-1097','A9 Q109-1123','A9 Q109-1241','A9 QWS0106A','A9 QWS0161B','A9 QWS0192A','A9 RH 2265.00','B1 ABS36824','B1 BLPADB114227','B1 CIF822-180-0','B1 KAMJQ1011700','B1 LUCGDB1344DTE','B1 LUCGDB917','B1 QB109-1097','B1 QB109-1123','B1 QB109-1241','B1 QBWS0161A','B1 QBWS0192A','B1 ZIM21934.170.9','B1 ZIM21934.970.1','B7 0265.00/REM','B7 B110054/DKM','B7 B111092/DKM','C4 21934.170.9','C4 GDB1344DTE','C9 0252160717','C9 0252160717/PD','C9 19-0526','C9 2193481','C9 23-0056','C9 23-0067','C9 GDB1344DTE','C9 GDB917','C9 PP-0105AF','C9 QB109-1097','C9 QB109-1123','C9 QB109-1241','C9 QBWS 0104 A','C9 QBWS 0106 A','C9 QBWS 0161 A','C9 QBWS 0197 A','C9 QBWS 0248 A','C9 QP2191','C9 QP2191C')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #