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 ('C4 607194','B7 SP 357','B7 1263700610/JP','A3 CIF 822-337-1','C9 13.0460-7278.2','A1 573018J JRD','E1 40 91 6744','C9 25218-16,3','A2 RH 2842.20','A1 P59042','A3 VAC V25-0226','C4 FDB1540','A2 FE FDB1540','A1 FDB1766','A3 FER FDB1540','A9 24137 167 05','A2 05P1236','C4 0986494528','B1 BREP68057','A9 13.04607253.2','A2 0986494032','A5 126375','A2 23482 168 05','A2 T 2413781','A9 BD S253','A9 FE FDB1540','A9 05P815','A2 05P815','A1 13.0460-7194.2','C9 2526501','B1 BLPADA104249','A1 16428 FE','A3 ROA 284260','A9 0986494528','A1 0986494528','B1 CIF822-337-2','C9 0252348216','B1 ABS37216','B1 BOS0986494528','C9 0252413716','B7 24137.168.1','C4 2413701TX','C9 23482-16,8','A2 13.04607287.2','A8 207 978','A9 T 2413781','B1 ZIM24137.168.1','A1 573186JC JRD','D1 BP ADA104249','A1 13.0460-7287.2','C4 LP1958','A1 LP1958','A9 BP59042','B1 ATE13.0460-7287','A3 TEX 2348202','A1 FSL1931','C9 PF0431','A5 205674','A3 TEX 2521801','A2 0986494528','A1 WBP334','A1 13.0460-7253.2','C9 0986494032','A9 FE FDB1766','A1 0986495216','A1 FDB1540','C4 FDB1766','C4 24137.168.1','A5 112895','C9 PP-005AF','C4 607287','C4 2348202TX','A1 0986494127','A3 TEX 2413781','B1 KAMJQ1013532','A1 16744 FE','A1 51-00-005ASK','A9 23482 168 05','A9 RH 2842.20','C9 25265-16,2','A3 FER FDB1766','C4 0986494127','A2 13.04607194.2','B7 0842.20/REM','C4 05P1236','A5 44896','A1 P61110','B1 ATE13.0460-7194','C9 VAL301472','B7 1263700619/JP','A3 VAC V25-0226-1','B7 KBP-6554/KAVO','A2 24137 167 05','C9 24137-16,8','A1 16890 FE','A2 LP1958','C9 FDB1766','A5 76446','C4 05P815','C9 VAL301783','A8 250 533','B1 BREP61110','C4 607278','B1 FEB16890','B1 BOS0986494127','A5 131044','A5 206736','A3 BOS 0986494127','A2 BD S253','B1 FEB16744','C9 0252413716/PD','B1 VAL301783','C9 VAL598783','A3 TEX 2413701','A3 BOS 0986495216','B7 51005/JAPKO','B1 VAI25-0226','A3 TEX 2526501','A1 13.0460-7278.2','A9 RH 2842.60','B1 ABS37870','B1 VAI25-0226-1','B1 VAL301472','C9 24137-16,7 EPAD','A2 40 91 6744','A3 BOS 0986494032','A9 13.04607194.2','B7 0842.60/REM','A8 226 640','A2 0986495216','C9 FDB1540','C1 RH 2842.20','C4 2521801TX','A8 217 305','C9 PF0243','A3 BOS 0986494528','A2 FE FDB1766','A8 228 746','A1 P68057','B7 1563603219/JP','C9 13.0460-7287.2','E7 346.2','A2 BP59042','C9 2413701','C4 1170006','A8 224 322','A3 JAP PP-005AF','C4 0986494032','C9 0986494528','C9 2348202','A2 0986494127','C4 16428F','C4 0986495216','A2 13.04607253.2','A5 78802','C9 13.0460-7194.2','A2 RH 2842.60','B7 0842.00/REM','A3 DLP LP1958','B1 FEB16428','A1 0986494032','A1 598472','B1 ATE13.0460-7253','C9 0986494127','B1 BOS0986494032','B7 0842.40/REM','B1 ABS37477','C9 2521801','C9 ADA104249','A3 ROA 284220','A8 215 830','B1 BREP59042','B1 ATE13.0460-7278','C9 0252348216/PD','C9 VAL598472','A9 0986494032','C9 13.0460-7253.2','B1 CIF822-337-1','A1 LP1701','A3 ROA 284200','C4 KRO1621','C4 N3613022','A1 GDB1621','A1 13.0460-7195.2','A1 13.0470-7195.2','A1 J3613019HB','A2 13.04607195.2','A2 13.04707195.2','A2 N3613022','A2 Q109-1123','A2 Q109-1755','A2 QWS0313A','A2 RH 2842.30','A2 RH 2842.40','A3 QUI 109-1123','A3 QUI 109-1755','A3 QUI WS0313A','A3 ROA 284230','A3 ROA 284240','A5 206754','A5 77557','A8 203 699','A8 223 661','A9 13.04607195.2','A9 13.04707194.2','A9 13.04707195.2','A9 N3613022','A9 Q109-1123','A9 Q109-1755','A9 QWS0313A','A9 RH 2842.30','A9 RH 2842.40','B1 ABS37869','B1 ATE13.0460-7195','B1 ATE13.0470-7194','B1 ATE13.0470-7195','B1 BREP59042X','B1 FEB16718','B1 QB109-1123','B1 QB109-1755','B1 QBWS0313A','B1 ZIM23482.165.2','B7 0842.30/REM','B7 B111338/DKM','C4 23482.165.2','C4 607195','C9 0252413717/PD','C9 13.0460-7195.2','C9 13.0470-7194.2','C9 13.0470-7195.2','C9 19-0523','C9 23-0112','C9 QB109-1123','C9 QB109-1755','C9 QP2195','C9 QP2195C','A8 230 381','A8 GDB1621 TRW','B5 1809458','C4 GDB1621','E6 BP1392')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #