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 ('C4 16422F','C4 16488F','A1 WBP275','A2 13.04602823.2','A1 GDB1439','B1 FEB16146','C9 VAL598180','A3 TEX 2096110','C4 FDB1083','B1 BOS0986461769','A1 13.0460-2842.2','A1 13.0460-2820.2','B1 ATE13.0460-2823','A1 573032JC JRD','B1 ATE13.0460-2820','A2 GDB1504','A2 RH 2263.01','C9 VAL872960','A2 BP85020','A8 254 312','B1 BLPADV184206','C9 13.0460-2819.2','A1 13.0460-2823.2','A1 0986494516','A5 42596','B1 LUCGDB1504','A3 ROA 226301','C4 LP2254','A2 13.04602819.2','A5 206677','A8 258 535','B1 BREP85020','B1 BOS0986494514','A3 BOS 0986424751','C9 ADV184206','A2 RH 2263.05','A2 13.04602984.2','A1 LP2254','C9 0986461769','A9 0986461769','C4 602819','A9 FE FDB1083','A9 13.04602984.2','A9 GDB1504','A1 13.0460-2860.2','A9 13.04602819.2','B1 ATE13.0460-2819','B1 BREP61088','B1 ATE13.0460-2937','C4 602937','A3 DLP LP2254','C9 0986494514','A2 13.04602860.2','A9 13.04602937.2','A2 0986424751','A1 16488 FE','B1 FEB16488','A2 BP61088','C9 2355402','A2 13.04602820.2','A9 23554 172 14','A1 598463','A2 0986461769','C4 GDB1504','B1 ATE13.0460-2842','A1 13.0460-2937.2','A1 16639 FE','C9 13.0460-2820.2','C4 16639F','A3 BOS 0986494514','C9 13.0460-2860.2','A2 LP2255','C4 16146F','C9 13.0460-2984.2','C9 FDB1083','C4 FDB1083W','C9 VAL598463','B1 ABS36623/1','A3 BOS 0986494516','A2 23554 172 14','A9 BP85020','C9 GDB1083','A1 FDB1083-PROMO','C9 PP-0018AF','A1 P85020','B1 ATE13.0460-2860','A5 77648','C4 LP565','A1 16457 FE','A2 13.04602937.2','C4 23554.170.3','A1 FDB1083','A1 13.0460-2819.2','A1 GDB1083','A3 BOS 0986461769','B1 ZIM23554.170.3','B1 ATE13.0460-2984','A1 16146 FE','A9 13.04602860.2','B1 BOS0986424751','A1 GDB1196','A8 217 810','C4 0986461769','A1 2355402 TEX','A9 0986424751','C9 13.0460-2823.2','A5 138171','B1 FEB16422','A9 13.04602820.2','A2 FE FDB1083','B1 BOS0986494516','A8 219 787','C4 05P868','A1 GDB1372','C9 13.0460-2937.2','A1 0986424751','D1 BP ADV184206','C9 0986424751','A1 LP565','C4 602823','A2 13.04602842.2','A3 DLP LP2255','A1 P61088','C4 2355402TX','C9 0986494516','A1 0986494514','B1 FEB16639','A2 LP565','A1 LP2255','C4 602984','A2 LP2254','A1 13.0460-2984.2','C4 0986494514','C4 0986424751','A2 05P868','A9 05P868','C4 602820','B7 23554.170.3','C9 GDB1504','A3 FER FDB1083','C9 23554-17,2','C4 LP2255','A3 TEX 2355402','A3 ROA 226305','A1 GDB1504','A1 0986461769','A8 230 196','A1 16422 FE','A5 17709','A3 DLP LP565','B1 FEB16457','A8 222 055','A1 598180','C9 20961-17,4 1 4','B1 LUCGDB1083','A1 0986494399','A1 13.0470-2820.2','A1 GDB1330','A1 GDB1330DTE','A1 P85020X','A2 05P634','A2 0986494399','A2 13.04702820.2','A2 GDB1330','A2 GDB1330DTE','A2 GDB1416','A2 Q109-1211','A2 RH 2263.03','A2 RH 2263.50','A3 CIF 822-100-1','A3 QUI 109-1211','A3 ROA 226303','A5 113386','A5 165392','A5 206748','A5 289249','A8 205 625','A8 206 982','A8 230 114','A8 234 054','A8 236 862','A8 236 938','A9 0986494399','A9 13.04702820.2','A9 GDB1330','A9 GDB1330DTE','A9 GDB1416','A9 Q109-1211','A9 RH 2263.50','B1 ATE13.0470-2820','B1 BLPADR164201','B1 BOS0986494596','B1 BOS0986494621','B1 BREP85020X','B1 CIF822-100-1','B1 KAMJQ1012166','B1 KAMJQ1013576','B1 LUCGDB1330','B1 LUCGDB1330DTE','B1 LUCGDB1416','B1 QB109-1211','B1 VAL301463','B1 VAL301474','B1 ZIM20961.172.1','B7 0263.03/REM','B7 0263.05/REM','B7 20961.172.1','B7 B110041/DKM','C4 05P634','C4 0986494399','C4 20961.172.1','C4 GDB1330','C4 GDB1330DTE','C4 GDB1416','C4 KRO1330','C4 LD2820','C9 0252096115','C9 0252096115/PD','C9 0252096117','C9 0252096117/PD','C9 0986494596','C9 0986494621','C9 13.0470-2820.2','C9 19-0428','C9 20961 10 704 00','C9 GDB1330','C9 GDB1330DTE','C9 GDB1416','C9 QB109-1211','C9 QP8078','C9 QP8078C','D1 BP ADR164201','D2 8671016188')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #