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 ('A1 GDB1469','C4 GDB1469','A2 LP1958','C4 LP1958','A1 0986494127','A5 309187','B1 VAL301472','B1 LUCGDB2033','A1 13.0460-7194.2','A9 13.04607251.2','C4 607209','C9 VAL598783','A2 GDB2033','A2 13.04607194.2','A3 TEX 2413701','A9 GDB1621','D2 8671016680','B1 LUCGDB1469','B1 ATE13.0460-7209','A9 RH 2842.70','A3 FER FDB1766','B1 BOS0986494528','C9 0986494528','B1 VAL301783','A5 112895','A2 GDB1469','A9 GDB1469','A2 RH 2842.30','C9 ADA104249','A9 RH 2842.20','C1 RH 2842.20','C9 FDB1766','A2 24137 167 05','A2 BP59042','A1 16428 FE','A2 05P1236','C4 GDB1621','A3 BOS 0986494127','D1 BP ADA104249','B1 ZIM24137.968.1','A2 0986494127','A1 573186JC JRD','C9 13.0460-7194.2','A2 RH 2842.70','B1 BREP59042','C4 GDB2033','C4 16428F','A9 RH 2842.40','A5 206735','C4 KRO1469','B1 BLPADA104249','A2 BD S253','A5 76446','A5 274009','A9 0986494528','A1 16718 FE','A2 13.04607251.2','A1 P59042','A5 126375','C4 607194','C9 GDB1469','C9 2413701','A9 24137 167 05','B1 FEB16428','C9 13.0460-7251.2','A8 230 175','C4 2413701TX','C4 0986494528','A1 WBP334','B1 LUCGDB1621','B1 ATE13.0460-7251','A5 414205','A8 230 381','A3 ROA 284230','A1 GDB1621','A3 DLP LP1958','C1 RH 2842.30','A1 13.0460-7251.2','A9 BP59042','A9 RH 2842.30','A8 224 322','A2 FE FDB1766','A1 0986494528','A8 241 561','C9 13.0470-7251.2','C4 KRO1621','C4 0986494127','A2 0986494528','A1 LP1958','C9 GDB1621','C9 VAL301783','C4 05P1236','A9 GDB2033','A1 FDB1766','A3 ROA 284220','A2 GDB1621','C9 0986494127','B1 ATE13.0470-7251','A2 RH 2842.20','A1 GDB2033','A9 13.04607209.2','C9 13.0460-7209.2','A2 13.04607209.2','B1 ATE13.0460-7194','A3 BOS 0986494528','A8 226 640','A2 RH 2842.40','C4 FDB1766','C9 GDB2033','A3 ROA 284240','C9 24137-16,8','A5 194981','C9 VAL598472','A8 250 533','A3 ROA 284270','A9 FE FDB1766','B1 FEB16718','B1 BOS0986494127','C9 VAL301472','B7 0842.20/REM','A1 598472','A9 13.04607194.2','A1 13.0470-7251.2','A1 13.0460-7209.2','A9 BD S253','A1 0986495216','A1 GDB2086','A1 J3613019HB','A2 0986495216','A2 GDB2086','A2 N3613022','A2 Q109-1755','A2 QWS0313A','A3 BOS 0986495216','A3 CIF 822-337-1','A3 JAP PP-005AF','A3 QUI 109-1755','A3 QUI WS0313A','A5 194973','A5 78802','A8 223 661','A8 234 094','A8 240 462','A9 13.04707194.2','A9 GDB1621DTE','A9 GDB2086','A9 N3613022','A9 Q109-1755','A9 QWS0313A','B1 ABS37477','B1 ATE13.0470-7194','B1 BREP59042X','B1 CIF822-337-1','B1 KAMJQ1013532','B1 LUCGDB1621DTE','B1 LUCGDB2086','B1 QB109-1755','B1 QBWS0313A','B1 VAI25-0226','B7 KBP-6554/KAVO','C4 0986495216','C4 1170006','C4 GDB1621DTE','C4 GDB2086','C4 KRO2086','C4 N3613022','C9 0252413716','C9 0252413716/PD','C9 13.0470-7194.2','C9 19-0523','C9 23-0112','C9 24137 00 702 00','C9 GDB1621DTE','C9 GDB2086','C9 QB109-1755','C9 QP2195','C9 QP2195C')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #