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 ('B7 23554.170.3','C4 GDB1813','C9 FDB1788','C9 GDB1330','C9 13.0470-2820.2','C4 FDS1083','A9 23554 172 14','A1 P85020','A3 ROA 226350','C4 GDB1416','A1 GDB1330','A8 258 535','A9 FE FDB1083','A1 P85020X','C4 2355402TX','A2 LP565','A1 FDB1083','A2 GDB1813','A8 222 055','A3 FER FDB1083','A1 598559','B1 FEB16488','A1 FQT1083','C4 05P634','A8 230 114','A9 BP85020','A1 2355402 TEX','A1 GDB1196','C9 VAL598559','C9 GDB1813','C4 FSL1083','A2 LP2254','B1 FEB16457','A1 16342 FE','B1 LUCGDB1813','A2 0986461769','A5 113386','A1 FQT1788','A1 571906JC JRD','A2 BP85020','A9 0986461769','A1 16457 FE','C4 16052F','B1 BOS0986461769','C4 GDB1330','A3 BOS 0986461769','A1 16052 FE','A1 GDB1813','A1 F026000133','A1 598474','A1 LP565','A1 FDB1788','A1 FDB1083-PROMO','A2 23554.170.1','C9 VAL598474','A1 FDB1788-PROMO','C4 23554.170.3','A1 16488 FE','C4 0986461769','A1 GDB1267','C4 FDB1788','A2 RH 2263.50','A1 16404 FE','B1 FEB16404','A1 GDB1311','C4 FDB1083','C4 KRO1330','A9 05P634','A5 165392','A5 42596','C4 LP2254','A2 13.04702820.2','C9 2355402','A9 FE FDB1788','A8 200 292','A9 RH 2263.50','A5 206748','B7 23554.170.1','A1 FSL1083','B7 0263.50/REM','A9 GDB1813','C9 FDB1083','A9 13.04702820.2','A1 0986461769','A2 GDB1416','A1 P61088','C9 19-0428','D2 8671016188','B1 BREP85020','A1 GDB1372','A9 GDB1330','A2 BP61088','C9 20961-17,4 1 4','B1 LUCGDB1416','A3 TEX 2355402','A1 WBP272','A1 GDB1416','B1 FEB16052','A2 FE FDB1083','C9 23554-17,2','C4 23554.170.1','A3 DLP LP2254','C4 LD2820','C4 FDB1083W','A1 LP1713','B1 ZIM23554.170.3','A8 241 413','A3 TEX 2096110','A1 LP2254','A3 FER FDB1788','A5 386533','C4 16488F','C4 LP565','C9 0986461769','B1 BREP85020X','A2 FE FSL1083','A2 GDB1330','A1 13.0470-2820.2','B1 ZIM23554.170.1','B7 05P634/SUZ','C9 GDB1416','A2 05P634','B1 BREP61088','B1 LUCGDB1330','A9 GDB1416','B1 ATE13.0470-2820','A3 DLP LP565','A8 205 625','A2 FE FDB1788','A2 23554 172 14','A1 571906D JRD','A1 573032JC JRD','A1 FDB4178','A1 GDB1330DTE','A2 GDB1330DTE','A2 Q109-1211','A2 RH 2263.03','A2 RH 2263.05','A3 CIF 822-100-1','A3 QUI 109-1211','A3 QUI 109-1685','A3 ROA 226303','A3 ROA 226305','A5 289249','A8 206 982','A8 234 054','A8 236 862','A9 GDB1330DTE','A9 Q109-1211','A9 Q109-1685','B1 ABS36623/1','B1 BLPADR164201','B1 BLPADV184206','B1 BOS0986494596','B1 CIF822-100-1','B1 FEB16146','B1 KAMJQ1013576','B1 LUCGDB1330DTE','B1 QB109-1211','B1 QB109-1685','B1 VAL301463','B1 ZIM20961.172.1','B7 0263.03/REM','B7 0263.05/REM','B7 20961.172.1','B7 B110041/DKM','C4 07.35.105','C4 16146F','C4 20961.172.1','C4 FDB4178','C4 GDB1330DTE','C9 0252096117','C9 0252096117/PD','C9 0986494596','C9 20961 10 704 00','C9 GDB1330DTE','C9 PP-0018AF','C9 QB109-1211','C9 QB109-1685','C9 QP8078','C9 QP8078C','D1 BP ADR164201','D1 BP ADV184206')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #