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 ('A8 256 778','C9 FDB1540','A1 WBP334','A3 TEX 2413781','A9 0986494032','C4 GDB1621','B1 BREP59042','A1 LP1958','A1 FQT1931','C9 ADN142114','C4 2413701TX','A1 FDB1540','A3 TEX 2413701','A9 FE FDB1540','A3 CIF 822-337-1','B1 ABS37216','A2 FE FDB1931','A2 BP59042','A9 0986494528','A1 0986494032','A2 0986494127','A9 GDB1621','C9 0986494528','A2 0986494528','A9 13.04607195.2','A2 13.04707195.2','C9 VAL872482','B1 BOS0986494528','A1 13.0470-7251.2','A2 J3611045','C9 PF0569','A1 13.0470-7195.2','B1 VAL301019','C9 ADA104249','D1 BP ADA104249','A3 FER FDB1931','C9 13.0470-7251.2','A3 BOS 0986495055','A5 206754','A8 224 322','A9 RH 2842.20','C9 24137-16,7 EPAD','C9 24137-16,8','C9 VAL598783','A9 24137 167 05','C4 607195','C9 0252413716/PD','A3 BOS 0986494032','A2 GDB1621','A1 FDB1766','B1 ATE13.0470-7195','A5 126375','B7 24137.168.1','C4 05P1236','A2 LP1958','C4 FDB1766','C9 FDB1931','A5 112895','A1 P59042','C4 24137.168.1','A9 J3611045','A1 FSL1540','A1 J3613019HB','A3 JAP PP-005AF','A3 FER FDB1675','C9 0252413717','B7 51005/JAPKO','C9 PF0431','C9 0252348216/PD','A9 FE FDB1931','B1 LUCGDB1621','B1 CIF822-337-1','C4 FDB1540','C4 FDB1931','C4 LP1958','C4 KRO1621','A9 BP59042','B1 ABS37477','A5 78802','A5 274009','E1 40 91 6744','A2 0986494032','C9 0986494032','C9 0252413717/PD','B1 BOS0986494127','C1 RH 2842.20','A3 DLP LP1958','A1 WBP261','A2 24137 167 05','C9 0252348216','A1 0986494528','B1 BLPADA104249','A1 51-00-005ASK','A8 250 533','C4 0986494127','B7 0842.20/REM','A9 T 2413781','A2 05P1236','B7 SP 357','A9 13.04707195.2','C9 GDB1621','B7 1263700610/JP','A1 FSL1766','B1 BLPADN142114','C4 LP1701','C4 0986494032','A1 13.0460-7195.2','C4 1170006','A1 FSL1931','A3 FER FDB1766','A1 FQT1540','C4 FQT1540','A3 ROA 284220','B1 ATE13.0470-7251','C9 PF0243','A2 13.04607195.2','A8 215 830','C9 500038667','D1 BP ADN142114','A3 DLP LP1701','B7 BP-6563/KAVO','A2 0986495055','B1 FEB16718','A2 40 91 6744','A1 16718 FE','A1 FDB1675','A1 0986495055','A1 0986494127','C9 2413701','A2 T 2413781','C9 FDB1766','A3 BOS 0986494528','A3 FER FDB1540','A5 44896','A5 77557','C4 0986494528','C4 J3611045','C9 VAL301019','A2 LP1701','A1 FDB1931','C9 PP-005AF','A2 FE FDB1540','A2 50 91 6718','A9 BD S253','B1 ATE13.0460-7195','A1 GDB1621','A1 LP1701','A8 230 381','C9 13.0470-7195.2','A2 BD S253','A2 FE FDB1766','E1 50 91 6718','A9 FE FDB1766','A8 226 640','E6 BP1392','A3 BOS 0986494127','C9 13.0460-7195.2','A1 FSL1540-PROMO','C9 0986494127','B1 ZIM24137.168.1','B1 BOS0986494032','A2 RH 2842.20','A1 0986424617','A1 GDB2086','A2 GDB2086','A5 194973','A8 234 094','A8 240 462','A9 GDB1621DTE','A9 GDB2086','B1 KAMJQ1013532','B1 LUCGDB1621DTE','B1 LUCGDB2086','C4 GDB1621DTE','C4 GDB2086','C4 KRO2086','C9 0252413716','C9 GDB1621DTE','C9 GDB2086')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #