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 VAI25-0226-1','A2 13.04707194.2','A9 13.04607253.2','A2 05P815','A9 T 2413781','B7 0842.20/REM','A2 24137 167 05','A9 13.04607194.2','A8 240 462','B1 FEB16744','A1 LP1701','A2 13.04607194.2','A1 13.0460-7209.2','B1 BLPADA104249','A2 T 2413781','A1 GDB1621','A2 BP59042','A1 FDB1766','A1 GDB2086','B1 VAL301783','B1 ZIM24137.968.1','A1 16744 FE','A9 05P815','C9 24137-16,7 EPAD','C9 13.0470-7251.2','A8 230 381','A9 13.04607209.2','A1 FSL1766','A1 13.0470-7194.2','B1 LUCGDB2086','A3 TEX 2413781','A1 13.0460-7253.2','B1 FEB16890','A2 LP1701','A2 13.04607209.2','C4 05P815','A2 BD S253','C9 GDB2086','A3 VAC V25-0226-1','B1 ATE13.0460-7209','A1 13.0460-7194.2','A9 0986494528','C9 VAL872137','A1 0986424617','A8 234 094','C4 607209','A3 BOS 0986494528','A8 217 305','B1 FEB16718','C9 13.0460-7194.2','C9 0252413716/PD','C4 LP1701','B1 ATE13.0470-7194','B1 BOS0986494528','A2 40 91 6744','A8 224 322','B7 24137.168.1','C9 VAL301783','A9 24137 167 05','E1 40 91 6744','A1 16718 FE','A9 13.04607251.2','A8 250 533','C4 KRO1621','C4 N3613022','A2 GDB2086','A1 GDB1621DTE','B1 ATE13.0460-7251','C9 FDB1766','C9 GDB1621DTE','C9 13.0460-7251.2','A8 256 778','C9 0986494528','C4 GDB1621','B1 BREP59042','A5 76446','C9 13.0470-7194.2','A1 16890 FE','A5 309187','A9 GDB1621DTE','A9 BP59042','A1 J3613019HB','C9 2413701','A9 RH 2842.20','B1 VAI25-0226','A9 BD S253','A1 P59042','C9 VAL598783','B1 LUCGDB1621','A1 13.0470-7251.2','A9 FE FDB1766','B1 ATE13.0460-7253','C4 0986494528','A3 VAC V25-0226','A1 WBP261','A5 274009','D1 BP ADA104249','A9 GDB2086','C4 607194','A5 112895','A2 13.04607251.2','A1 573018J JRD','C9 ADA104249','A2 0986494528','A9 N3613022','A2 RH 2842.20','C4 2413701TX','C1 RH 2842.20','A5 131044','A2 GDB1621DTE','A5 194973','C4 FDB1766','A3 DLP LP1701','B1 ATE13.0470-7251','A1 13.0460-7251.2','A5 206736','A3 TEX 2413701','B1 ZIM24137.168.1','C4 24137.168.1','C9 PP-0006AF','B1 ATE13.0460-7194','C9 13.0460-7209.2','C9 GDB1621','A2 GDB1621','A9 GDB1621','C9 13.0460-7253.2','C4 GDB2086','A2 13.04607253.2','A2 FE FDB1766','C4 GDB1621DTE','C9 24137-16,8','A9 13.04707194.2','A1 573186JC JRD','A3 FER FDB1766','A5 206735','B1 LUCGDB1621DTE','A3 ROA 284220','C4 KRO2086','A1 0986494528','A2 N3613022','A1 GDB1469','A1 GDB1938','A1 GDB2033','A2 GDB1469','A2 GDB1469DTE','A2 GDB1938','A2 GDB2033','A5 194981','A5 284606','A5 414205','A8 230 175','A8 234 070','A8 241 187','A8 241 561','A9 GDB1469','A9 GDB1469DTE','A9 GDB1938','A9 GDB2033','B1 ABS37477','B1 BREP59042X','B1 LUCGDB1469','B1 LUCGDB1469DTE','B1 LUCGDB1938','B1 LUCGDB2033','B1 ZIM23482.165.2','B7 B110650/DKM','B7 B111338/DKM','B7 KBP-6554/KAVO','C4 1170006','C4 23482.165.2','C4 GDB1469','C4 GDB1469DTE','C4 GDB1938','C4 GDB2033','C4 KRO1469','C4 KRO1938','C9 19-0523','C9 19-2918','C9 GDB1469','C9 GDB1469DTE','C9 GDB1938','C9 GDB2033','C9 PA-027AF','C9 QP2195','C9 QP2195C')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #