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 ('A2 GDB1498DTE','A9 0986494036','A3 FER FDB1628','B1 FEB116031','A1 13.0470-7167.2','C4 FDB4221','A1 FDB1628','C4 GDB1498DTE','A1 P06046','B1 BREP06054','A2 T 2331207','A3 TEX 2331303','A9 24161.200.1','C4 2331282TX','A2 13.04707167.2','A1 0986424651','B1 TRU08.34.104','C9 2331282','A1 116031 FE','A3 BOS 0986494036','A5 130786','A3 TEX 2331282','B1 BOS0986494036','A1 0986494036','A5 72972','B1 ATE13.0470-7237','A2 301410','A1 598410','C9 VAL598898','A1 LP1794','A8 225 936','A3 TEX 2331211','A2 BP06045','B1 ZIM23312.200.1','A2 13.04607237.2','B1 ATE13.0460-7167','A2 13.04707237.2','B1 BLPADB114207','C9 23312-20,3 EPAD','E1 20 91 6433','B1 ATE13.0470-7167','B1 ATE13.0460-7296','C4 23312.200.1','B1 BREP06046','C9 23312-20,3 9 5','A3 FER FDB4221','A9 BP06054','C4 LD7296','A1 P06081','A1 P06054','A2 LP1794','A9 GDB1498DTE','C9 13.0470-7296.2','B1 ZIM24161.200.1','B1 VAL301410','A1 13.0470-7237.2','C9 23313-20,3 9 5 EPAD','A2 T 2416101','A1 13.0460-7167.2','A8 228 935','D1 BP ADB114207','A9 13.04607167.2','A3 TEX 2331281','B1 ZIM23312.200.9','A2 T 2331211','B7 0857.30/REM','B7 24161.200.1','A8 234 073','C9 0252344717','A9 T 2331211','C9 0252334720','A2 13.04607167.2','C4 FDB1628','B1 FEB16433','A9 13.04707296.2','A8 224 325','A9 T 2331303','A3 TEX 2331207','A5 48895','B7 0857.00/REM','A1 GDB1498DTE','B7 23312.200.1','C9 13.0470-7167.2','A3 BOS 0986495082','A2 BP06046','C9 0986494036','A3 TEX 2416101','A2 FE FDB1628','C9 FDB1628','C9 2331382','A2 13.04607296.2','C9 23312-20,3 9 5 EPAD','A2 05P1510','A8 233 820','C4 2331303TX','A8 233 942','C4 2331207TX','B1 LUCGDB1498DTE','A2 24161.200.1','C9 2331207','A3 TEX 2331382','A1 2331211 TEX','A2 0986494036','A1 WBP440','A9 BP06046','A9 LP1794','A1 0986495082','A1 16433 FE','D2 EO FDB1628','C4 0986494036','B1 ABS37346','C4 LP1794','C9 VAL598410','A2 FE FDB4221','C4 607237','A2 05P1193','C9 0252416120','C9 0252334720/PD','B7 23312.200.9','C9 13.0470-7237.2','A9 13.04607237.2','A2 BP06054','C9 23312-20,3 0 5','A1 P06045','A5 171351','C9 2331281','C9 23313-20,3 9 5','A9 FE FDB1628','C9 2331211','C4 607296','A3 TEX 2331204','C9 13.0460-7237.2','C4 0986495082','C9 VAL301410','A1 13.0470-7296.2','C9 221533','C4 2331211TX','A3 TRU 08.34.104','A3 DLP LP1794','A9 13.04607296.2','C9 13.0460-7167.2','C9 0252416120/PD','A2 T 2331303','A2 13.04707296.2','C4 LD7237','A5 206948','A1 13.0460-7237.2','A1 573210JC JRD','A1 P06031','A9 13.04707237.2','B1 ATE13.0460-7237','C4 607167','C4 16433F','C9 13.0460-7296.2','A9 FE FDB4221','A8 228 205','A1 573189JC JRD','C4 23312.200.9','A1 13.0460-7296.2','A3 VAC V20-8121','A9 13.04707167.2','B1 ATE13.0470-7296','A1 FDB4221','A9 T 2331207','A1 571990JC JRD','C4 05P1193','A2 T 2331281','C9 GDB1498DTE','C9 2331303','B1 BREP06081','A1 13.0460-7306.2','A2 13.04607306.2','A2 Q109-1644','A2 QWS0218A','A2 QWS0224A','A2 QWS0259A','A2 RH 2857.00','A3 QUI WS0218A','A3 QUI WS0224A','A3 QUI WS0259A','A3 QUI WS0294A','A3 ROA 285700','A8 524 100','A8 524 102','A8 524 166','A9 13.04607306.2','A9 Q109-1644','A9 QWS0218A','A9 QWS0224A','A9 QWS0259A','A9 QWS0292A','A9 RH 2857.00','B1 ATE13.0460-7306','B1 BREP06054X','B1 CIF822-558-0','B1 KAMJQ101092','B1 KAMJQ1013256','B1 QB109-1644','B1 QBWS0218A','B1 QBWS0224A','B1 QBWS0259A','B1 ZIM23312.200.2','B1 ZIM23312.900.1','B7 B111225/DKM','C4 1170090','C4 LP3630','C9 13.0460-7306.2','C9 19-2872','C9 QB109-1644','C9 QBWS 0218 A','C9 QBWS 0259 A','C9 QBWS 0286 A','C9 QBWS 0292 A','C9 QBWS 0294 A','C9 QP1685','C9 QP1685C','E7 P9573.00/W')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #