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 GDB1328','C4 16328F','A1 16540 FE','C4 GDB1330','A2 GDB1330','C4 602864','B1 FEB16488','C9 2355401','C4 GDB1328','C4 16502F','A3 TEX 2355401','B1 VAL301180','A1 598463','B1 ATE13.0460-2886','B1 ZIM20961.972.1','C4 16148F','A1 FDB1788','C4 2355401TX','A3 DLP LP2255','A1 16328 FE','C4 KRO1330','A1 16488 FE','B1 ATE13.0460-2864','A1 116210 FE','C4 16639F','C9 VAL598485','B1 FEB16457','B1 FEB16502','B1 LUCGDB1328','C4 FDB1788','A1 16457 FE','C9 13.0460-2864.2','A2 13.04602864.2','A1 16639 FE','D1 BP ADV184206','A8 201 645','C9 13.0460-2886.2','C9 2355402','A8 258 535','A1 16502 FE','B1 FEB16338','C9 ADV184206','C9 GDB1328','B1 ATE13.0460-2860','C9 VAL301180','A9 GDB1416','A1 LP2255','A1 598485','A1 2355401 TEX','A5 206681','C4 0986461769','B1 VAL301463','A3 FER FDB1788','A9 23554 152 14','A9 GDB1330','A2 13.04602860.2','A2 RH 2263.50','C9 VAL598474','A2 13.04602842.2','C9 GDB1416','A3 ROA 226350','C9 23554-17,2','A9 FE FDB1788','A9 0986461769','C9 VAL301474','A8 222 055','A5 206852','C4 LP2255','A9 13.04602864.2','C4 602886','A1 13.0460-2842.2','A8 230 478','C4 GDB1416','C9 PA-0610AF','A5 150151','A1 GDB1416','A2 23554 172 14','A5 165392','A1 16446 FE','C4 16446F','B1 VAL301474','A2 FE FDB1788','A1 13.0460-2886.2','A3 TEX 2355402','D2 8671016188','B1 ATE13.0460-2842','A1 GDB1439','A2 0986461769','B1 LUCGDB1416','C4 2355402TX','A1 571906D JRD','A2 23554 152 14','B1 FEB16146','B1 FEB16148','A9 GDB1328','A1 16146 FE','C9 VAL872960','A2 GDB1416','A1 FDB1788-PROMO','A3 BOS 0986461769','A9 23554 172 14','A1 598180','B1 FEB171000','B1 FEB16328','B1 FEB16540','A1 16148 FE','C9 FE16328','B1 ABS36623/1','A1 598474','A1 16338 FE','A9 RH 2263.50','A1 13.0460-2864.2','A8 205 625','B1 FEB16639','A2 GDB1328','B1 BOS0986461769','B1 BLPADV184206','A1 571906JC JRD','C9 VAL598180','C9 13.0460-2860.2','A1 2355402 TEX','C9 FE16148','A8 230 114','A9 13.04602860.2','A9 13.04602886.2','C9 VAL301463','C4 16146F','A1 GDB1458','B1 FEB116210','B1 FEB16446','A1 GDB1330','A2 LP2255','C9 FDB1788','C9 23554-15,2','C9 19-0428','C4 16488F','C9 GDB1330','A1 13.0460-2860.2','B1 LUCGDB1330','C9 0986461769','A1 WBP272','A2 13.04602886.2','C9 VAL598463','A1 0986461769','A1 13.0460-2820.2','A1 13.0460-2894.2','A1 13.0470-2820.2','A1 13.0470-2894.2','A1 GDB1330DTE','A1 LP565','A1 P85020','A1 P85020X','A2 13.04602820.2','A2 13.04602894.2','A2 13.04702820.2','A2 BP85020','A2 GDB1330DTE','A2 Q109-1211','A2 RH 2263.03','A2 RH 2263.05','A3 CIF 822-100-1','A3 DLP LP565','A3 QUI 109-1211','A3 ROA 226303','A3 ROA 226305','A5 17709','A5 206748','A5 206750','A5 289249','A5 74906','A8 206 982','A8 234 054','A9 13.04602820.2','A9 13.04602894.2','A9 13.04702820.2','A9 13.04702894.2','A9 BP85020','A9 GDB1330DTE','A9 Q109-1211','B1 ATE13.0460-2820','B1 ATE13.0460-2894','B1 ATE13.0470-2820','B1 ATE13.0470-2894','B1 BLPADR164201','B1 BREP85020','B1 BREP85020X','B1 CIF822-100-1','B1 KAMJQ1012166','B1 LUCGDB1330DTE','B1 QB109-1211','B1 ZIM20961.172.1','B7 0263.03/REM','B7 0263.05/REM','B7 20961.172.1','B7 B110041/DKM','C4 20961.172.1','C4 602820','C4 602894','C4 GDB1330DTE','C4 LD2820','C4 LD2894','C4 LP565','C9 0252096117','C9 0252096117/PD','C9 13.0460-2820.2','C9 13.0460-2894.2','C9 13.0470-2820.2','C9 13.0470-2894.2','C9 20961 00 704 00','C9 GDB1330DTE','C9 QB109-1211','C9 QP8078','C9 QP8078C','D1 BP ADR164201')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #