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 0986494127','A2 BP59042','A2 LP1701','A2 13.04607195.2','C4 1170006','C4 607195','B1 ATE13.0460-7195','C9 25212-16,1 EPAD','A2 T 2413781','C4 FDB1931','A2 50 91 6718','A1 16718 FE','A2 13.04707195.2','A3 TEX 2521281','B1 BOS0986494127','B1 ATE13.0470-7195','A1 573186JC JRD','A3 DLP LP1701','C9 24137-16,7 EPAD','A1 0986494127','C9 FDB1931','E1 50 91 6718','A5 126375','A2 BD S253','A2 RH 2842.20','A3 BOS 0986494127','A9 RH 2842.20','A8 230 381','A9 FE FDB1931','C9 13.0470-7195.2','C9 GDB1621','A1 13.0470-7195.2','C9 2413701','A3 VAC V25-0226','A3 TEX 2521201','A5 206754','A2 FE FDB1931','A8 224 322','A2 0986494127','A2 GDB1621','A1 598472','A8 226 640','A5 274009','B7 0842.20/REM','C4 05P1236','A3 TEX 2413701','A1 LP1701','B1 BREP59042','C4 0986494127','A1 WBP261','C4 GDB1621','A1 GDB1621','A3 TEX 2413781','A3 ROA 284220','A9 13.04707195.2','B1 VAI25-0226','C9 25212-16,1','C4 2413701TX','B1 CIF822-337-1','A3 FER FDB1931','A2 05P1236','B1 ABS37477','C4 LP1701','A9 BP59042','B1 FEB16718','A9 25212 161 05','A1 FSL1931','B1 LUCGDB1621','A2 25212 161 05','A1 FQT1931','A3 CIF 822-337-1','C9 24137-16,8','A1 FDB1931','A9 13.04607195.2','C4 2521201TX','A1 P59042','A9 T 2413781','C4 KRO1621','C9 VAL598472','A1 13.0460-7195.2','A9 GDB1621','C9 13.0460-7195.2','A2 24137 167 05','C1 RH 2842.20','A9 24137 167 05','A9 BD S253','C9 0252413716','A5 77557','C9 2521201','B1 ZIM24137.968.1','A8 233 550','A3 ROA 284200','D1 BP ADA104249','E1 40 91 6744','A1 13.0460-7160.2','A1 13.0460-7194.2','A1 13.0460-7209.2','A1 13.0460-7253.2','A1 GDB1613','A1 GDB2086','A1 J3613019HB','A1 P24148','A1 P24148X','A2 13.04607160.2','A2 13.04607194.2','A2 13.04607251.2','A2 13.04607253.2','A2 BP24148','A2 GDB1613','A2 GDB2086','A2 RH 2888.40','A5 194973','A5 206735','A5 206736','A5 309187','A5 76446','A8 230 378','A8 234 094','A8 236 683','A8 240 462','A9 13.04607160.2','A9 13.04607194.2','A9 13.04607209.2','A9 13.04607251.2','A9 13.04607253.2','A9 13.04707194.2','A9 BP24148','A9 GDB1613','A9 GDB1613DTE','A9 GDB1621DTE','A9 GDB2086','A9 RH 2888.40','B1 ATE13.0460-7160','B1 ATE13.0460-7194','B1 ATE13.0460-7209','B1 ATE13.0460-7251','B1 ATE13.0460-7253','B1 ATE13.0470-7194','B1 ATE13.0470-7251','B1 BLPADA104249','B1 BLPADN142114','B1 BREP24148','B1 BREP24148X','B1 BREP59042X','B1 FEB16428','B1 KAMJQ1013532','B1 LUCGDB1613','B1 LUCGDB1613DTE','B1 LUCGDB1621DTE','B1 LUCGDB2086','B1 VAL301019','B1 VAL301783','B7 0888.40/REM','B7 B111338/DKM','C4 607160','C4 607194','C4 607209','C4 GDB1613','C4 GDB1613DTE','C4 GDB1621DTE','C4 GDB2086','C4 KRO1613','C4 KRO2086','C9 0252348216','C9 0252348216/PD','C9 0252413716/PD','C9 13.0460-7194.2','C9 13.0460-7209.2','C9 13.0460-7251.2','C9 13.0460-7253.2','C9 13.0470-7194.2','C9 13.0470-7251.2','C9 19-0523','C9 19-0632','C9 ADA104249','C9 ADN142114','C9 GDB1613','C9 GDB1613DTE','C9 GDB1621DTE','C9 GDB2086','C9 PA-027AF','C9 QP2195','C9 QP2195C','C9 QP5524','C9 QP5524C','D1 BP ADN142114','E1 60 91 6428','E6 BP1392','B5 1809458','C4 LP1958','C4 N3613022')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #