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 13.0460-2894.2','A9 13.04602886.2','A9 13.04602984.2','C9 GDB1330','A8 236 862','A2 FE FDB1083','A2 RH 2263.05','A3 FER FDB1788','A9 FE FDB1083','C4 LP571','A1 FDB4178','C9 FDB1788','A2 13.04602864.2','A9 23554 172 14','C4 FDB1083','C9 13.0460-2819.2','A5 206852','C4 GDB1330','A1 WBP275','A5 17709','C9 VAL301180','A9 13.04702820.2','A3 TEX 2355402','A2 FE FDB1788','A1 WBP350','B1 ATE13.0460-2886','B1 VAL301180','A3 ROA 226305','B1 ATE13.0460-2820','C4 LP565','A1 13.0470-2820.2','C9 13.0460-2864.2','A1 GDB1196','A1 13.0460-2820.2','B1 ATE13.0470-2820','A5 206748','C4 602820','C9 2355402','B1 LUCGDB1330','A2 FE FDB4178','A5 206677','A1 2355402 TEX','C9 13.0460-2984.2','A1 GDB1330','B1 ATE13.0460-2894','C4 2355402TX','A2 13.04702820.2','A1 FDB1788','C4 KRO1330','A1 13.0460-2886.2','A8 222 055','C4 602819','A5 150151','A2 BP85020','B1 BREP85020','B1 ATE13.0460-2984','A5 206681','A1 WBP272','C4 602894','A2 13.04602819.2','B1 BOS0986494596','A8 254 312','A9 13.04602820.2','D2 8671016188','A9 FE FDB4178','A2 13.04602984.2','A1 WBP271','C9 0986494596','A2 13.04602823.2','C4 602886','C9 13.0470-2820.2','C9 13.0460-2823.2','C9 19-0428','A8 230 114','A3 DLP LP571','A5 165392','A9 BP85020','A2 23554 172 14','A1 FDB1083','A1 GDB1055','A2 13.04602894.2','A2 GDB1330','A1 FDB1788-PROMO','A9 FE FDB1788','B1 ATE13.0460-2819','C4 602984','A1 FDB1083-PROMO','B1 ATE13.0460-2864','B7 0263.05/REM','A5 74906','C9 23554-17,2','C4 FDB4178','C9 13.0460-2894.2','A9 13.04602819.2','A2 13.04602886.2','C4 602823','A1 13.0460-2864.2','C4 FDB1788','C9 FDB1083','C9 13.0460-2820.2','C4 LD2820','A2 13.04602820.2','A5 138171','C9 13.0460-2886.2','A2 LP565','B1 ATE13.0460-2823','A1 P85020','A1 LP565','A1 13.0460-2823.2','C4 602864','A3 DLP LP565','C4 FDB1083W','A1 LP571','A9 13.04602864.2','A5 42596','A1 13.0460-2819.2','A9 GDB1330','A1 13.0460-2984.2','A3 FER FDB4178','A2 LP571','A3 FER FDB1083','A9 13.04602894.2','A1 13.0460-2740.2','A1 13.0460-2787.2','A1 13.0460-2842.2','A1 13.0460-2860.2','A1 13.0470-2740.2','A1 13.0470-2886.2','A1 16488 FE','A1 571906D JRD','A1 571906JC JRD','A1 573032JC JRD','A1 GDB1328','A1 GDB1330DTE','A1 GDB1504','A1 GDB1622','A1 GDB1622DTE','A1 GDB1813','A1 GDB823','A1 P85020X','A1 WBP556','A1 WBP562','A2 13.04602740.2','A2 13.04602787.2','A2 13.04702886.2','A2 BD S831P','A2 GDB1328','A2 GDB1330DTE','A2 GDB1416','A2 GDB1504','A2 GDB1622','A2 GDB1622DTE','A2 GDB823','A2 Q109-1211','A2 Q109-1263','A2 Q113-1301','A2 Q113-1302X','A2 RH 2263.00','A2 RH 2263.01','A2 RH 2263.03','A2 RH 2263.10','A2 RH 2263.50','A2 RH 2263.74','A3 CIF 822-100-1','A3 QUI 109-1211','A3 QUI 109-1263','A3 QUI 109-1685','A3 QUI 113-1301','A3 QUI 113-1302X','A3 ROA 226300','A3 ROA 226303','A3 ROA 226310','A3 ROA 226374','A5 172832','A5 194995','A5 289249','A5 289492','A5 342235','A5 386533','A5 386818','A5 77328','A8 205 625','A8 206 982','A8 230 196','A8 230 238','A8 230 382','A8 230 478','A8 234 054','A8 234 095','A9 13.04602740.2','A9 13.04602787.2','A9 13.04602860.2','A9 13.04702740.2','A9 13.04702886.2','A9 BD S831P','A9 GDB1328','A9 GDB1330DTE','A9 GDB1416','A9 GDB1504','A9 GDB1622','A9 GDB1622DTE','A9 GDB1813','A9 GDB823','A9 GDB823DTE','A9 Q109-1211','A9 Q109-1263','A9 Q109-1685','A9 Q113-1301','A9 Q113-1302X','A9 RH 2263.00','A9 RH 2263.15','A9 RH 2263.50','A9 RH 2263.74','B1 ABS36623/1','B1 ATE13.0460-2740','B1 ATE13.0460-2787','B1 ATE13.0460-2860','B1 ATE13.0470-2740','B1 ATE13.0470-2787','B1 ATE13.0470-2886','B1 BLPADR164201','B1 BLPADV184206','B1 BREP85020X','B1 CIF822-100-1','B1 FEB116018','B1 FEB16146','B1 FEB16488','B1 FEB16639','B1 KAMJQ1013576','B1 LUCGDB1328','B1 LUCGDB1330DTE','B1 LUCGDB1416','B1 LUCGDB1504','B1 LUCGDB1622','B1 LUCGDB1622DTE','B1 LUCGDB1813','B1 LUCGDB823','B1 LUCGDB823DTE','B1 QB109-1211','B1 QB109-1263','B1 QB109-1685','B1 QB113-1302X','B1 VAL301463','B7 0263.00/REM','B7 0263.03/REM','B7 0263.10/REM','B7 0263.74/REM','B7 B110041/DKM','C4 16146F','C4 16639F','C4 602740','C4 602787','C4 GDB1328','C4 GDB1330DTE','C4 GDB1416','C4 GDB1504','C4 GDB1622','C4 GDB1622DTE','C4 GDB1813','C4 GDB823','C4 GDB823DTE','C4 KRO1622','C4 KRO823','C4 LD2886','C9 0252096115','C9 0252096115/PD','C9 0252096117','C9 0252096117/PD','C9 0252355417/PD','C9 0252355417/W','C9 13.0460-2740.2','C9 13.0460-2787.2','C9 13.0460-2860.2','C9 13.0470-2740.2','C9 13.0470-2886.2','C9 20961 10 704 00','C9 GDB1328','C9 GDB1330DTE','C9 GDB1416','C9 GDB1504','C9 GDB1622','C9 GDB1622DTE','C9 GDB1813','C9 GDB823','C9 GDB823DTE','C9 PP-0018AF','C9 PP-0903AF','C9 QB109-1211','C9 QB109-1685','C9 QB113-1302X','C9 QP8078','C9 QP8078C','D1 BP ADR164201','D1 BP ADV184206')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #