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