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