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 VAL598472','B1 CIF822-337-1','C9 VAL301019','C4 05P1236','C9 13.0460-7251.2','A1 16718 FE','B1 ATE13.0460-7160','A9 24137 167 05','C9 0252413716/PD','A9 25212 161 05','A8 233 550','A2 LP1958','B1 ATE13.0470-7251','C9 VAL301783','A2 13.04607251.2','B1 ATE13.0460-7195','A1 WBP261','A8 215 830','B1 VAI25-0226-1','C9 FDB1766','B7 0842.70/REM','A5 126375','A9 FE FDB1766','A3 DLP LP1701','B1 BLPADA104249','A9 T 2413781','A2 0986494528','A5 206736','A1 13.0460-7253.2','A1 573018J JRD','B1 ATE13.0460-7251','A3 TEX 2521281','A9 13.04607253.2','A1 573186JC JRD','A2 13.04607209.2','C4 607209','C9 2413701','C4 0986495216','A2 RH 2842.20','A1 13.0460-7251.2','A8 224 322','A9 0986494528','A2 LP1701','A9 BP59042','A1 0986494528','B7 1263700619/JP','A5 77557','B1 FEB16744','B7 1263700610/JP','A2 13.04607195.2','A2 FE FDB1540','B1 KAMJQ1013532','A3 VAC V25-0226-1','C4 607195','A8 226 640','A1 13.0470-7251.2','B1 VAL301472','A2 25212 161 05','A2 13.04607160.2','A3 ROA 284220','A1 P59042','B1 VAI25-0226','D1 BP ADA104249','B1 BOS0986494528','B7 0842.20/REM','C4 LP1958','B1 VAL301019','C9 PF0243','A3 VAC V25-0226','C9 VAL598783','C9 24137-16,7 EPAD','A9 FE FDB1931','C4 24137.168.1','A2 40 91 6744','A1 FDB1931','B1 FEB16718','E1 60 91 6428','C1 RH 2842.20','B1 BREP59042','A3 BOS 0986494127','B1 ABS37477','C4 2413701TX','C9 VAL601044','C9 0986494528','C9 VAL872482','C9 VAL601008','B1 FEB16428','A5 44896','A1 FDB1540','A3 TEX 2521201','B1 ATE13.0460-7253','A2 BP59042','C4 16428F','B7 24137.168.1','A3 FER FDB1766','C4 0986494528','A9 RH 2842.20','C4 0986494127','B7 0842.30/REM','A1 0986424617','A1 WBP334','A2 0986494032','A8 250 533','A1 FSL1931','B1 ATE13.0460-7209','A9 FE FDB1540','A1 16864 FE','A1 16744 FE','C4 FDB1766','A1 598472','B1 ABS37216','A2 FE FDB1931','C4 0986494032','C9 ADA104249','C9 0252413716','A3 BOS 0986494528','B7 SP 357','A5 206735','A2 0986495216','A9 BD S253','A2 T 2413781','C9 25212-16,1 EPAD','B1 BOS0986494127','C9 0986494032','A3 DLP LP1958','C9 FDB1931','C9 0986494127','A9 0986494032','A1 13.0460-7195.2','E1 40 91 6744','A9 13.04607195.2','A1 0986494032','C4 FDB1931','A2 BD S253','C9 13.0460-7253.2','C9 24137-16,8','A1 13.0460-7160.2','A2 13.04607253.2','A1 13.0460-7209.2','B7 1563603219/JP','C9 13.0460-7209.2','A2 05P1236','A3 TEX 2413701','A3 FER FDB1540','A5 112895','C4 2521201TX','B1 BOS0986494032','A2 FE FDB1766','C9 VAL301472','A3 BOS 0986495216','A1 LP1701','C9 VAL301001','C9 FDB1540','A1 0986494127','A3 FER FDB1931','A2 0986494127','A1 16428 FE','A1 LP1958','C9 13.0470-7251.2','C4 LP1701','A9 13.04607160.2','B1 ZIM24137.168.1','C9 13.0460-7195.2','B1 FEB16864','A5 309187','C4 FDB1540','A9 13.04607209.2','C9 VAL872137','A1 FDB1766','A1 573209JC JRD','A3 TEX 2413781','C9 13.0460-7160.2','A3 CIF 822-337-1','A1 0986495216','C4 607160','C9 2521201','C9 25212-16,1','A2 24137 167 05','A9 13.04607251.2','B1 VAL301783','A3 BOS 0986494032','A1 J3613019HB','A2 25212.160.1','A2 Q109-1755','A3 JAP PP-005AF','A3 QUI 109-1755','A5 78802','A8 223 661','A9 Q109-1755','B1 BLPADBP420005','B1 BLPADN142114','B1 BREP59042X','B1 QB109-1755','B1 ZIM25212.160.1','B7 25212.160.1','B7 KBP-6554/KAVO','C4 25212.160.1','C9 0252413717/PD','C9 19-0523','C9 24137 00 702 00','C9 ADBP420005','C9 ADN142114','C9 QB109-1755','C9 QP2195','C9 QP2195C','D1 BP ADN142114','E6 BP1392')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #