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 ('C9 2160702','A3 TEX 2193402','A1 FSL850','C9 0986424667','B7 0265.40/REM','A9 21934 163 05','B1 ZIM20180.170.1','A9 BP06025','A1 FDB1301','B1 BREP06011','B1 LUCGDB1344','A5 43148','C9 GDB1189','B1 LUCGDB1343','A3 BOS 0986424484','A1 GDB1258','A1 GDB1343','B1 BOS0986460964','C9 VAL301386','C9 2193404','A1 GDB1430','B7 0265.30/REM','A3 FER FDB1301','C9 21607-17,3','A5 206833','B1 VAL301753','A2 GDB1189','C9 FE16176','A2 GDB1343','B1 FEB16351','A1 GDB1344','A2 LP907','A3 BOS 0986460964','C4 05P463','A2 0986424667','B1 BREP06013','A2 05P463','A2 FE FDB850','A2 RH 2265.40','A1 FQT1301','C9 VAL301753','C4 21934.170.1','A9 BP06013','A3 FER FDB1867','A2 13.04703605.2','A1 16176 FE','A1 0986460964','B1 LUCGDB1258','A3 TEX 2160702','A1 P06025','A9 0986424484','A2 RH 2265.50','C9 2193402','B1 BREP71006','A1 0986424667','A8 218 406','A2 FE FDB1301','B7 21934.170.1','C9 VAL598386','A8 203 503','A1 598386','A9 FE FDB1301','A3 ROA 226541','C9 FE16351','B1 LUCGDB1189','A9 0986424667','A1 LP1423','A3 ROA 226550','A1 FSL1301','A1 P71006','B1 ZIM21934.170.1','A9 BP71006','B1 VAL301386','A2 LP1423','A2 0986460964','A2 FE FDB1867','A2 21934 173 05','C9 FDB1301','C4 0986424484','A9 13.04703605.2','A9 21607 173 05','A3 DLP LP907','A2 BP06025','A5 41110','A2 BP06011','A1 WBP118','C9 0986424484','C4 LP1423','A9 GDB1189','C4 LD3605','A9 GDB1343','A1 LP907','A2 21607 173 05','A1 F026000009','C4 FDB1867','A2 0986424484','C9 GDB1343','B1 BOS0986424667','C4 16176F','B1 ATE13.0470-3605','A2 GDB1344','A2 RH 2265.41','B1 BOS0986424484','C4 FDB850','A8 203 505','A1 16196 FE','A3 BOS 0986424667','C9 GDB1258','C4 2193402TX','B1 BREP06025','A9 GDB1344','A1 13.0470-3605.2','A3 FER FDB850','A2 RH 2265.30','A1 WBP116','A9 21934 173 05','A3 TEX 2193404','A9 BP06011','A1 FDB1867','C9 13.0470-3605.2','A1 GDB1189','A3 DLP LP1423','C9 VAL598753','A9 0986460964','A3 TRW GDB1258','B7 0265.41/REM','C4 FSL850','A9 RH 2265.50','A9 RH 2265.40','B1 FEB16196','A8 234 803','C9 21934-17,3','A1 P06011','C4 KRO1344','A9 GDB1258','A2 BP71006','A3 ROA 226540','A9 FE FDB850','A1 16351 FE','A8 241 692','C4 FDB1301','A5 195038','A5 131294','C9 GDB1344','A9 FE FDB1867','C9 21934-16,3','A3 ROA 226530','B7 20180.170.1','C4 16196F','A8 230 119','A8 215 809','B1 FEB16176','C9 0986460964','C4 GDB1344','A1 FDB850','C4 LP907','A2 21934 163 05','A1 FQT850','A1 P06013','B7 0265.50/REM','A2 GDB1258','A2 BP06013','A1 0986424484','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)) #