select t1.id,t1.miestas,t1.miestas_kitas,t1.mikrorajonas,t1.mikrorajonas_kitas,t1.gatve,t1.kambariu_skaicius,t1.plotas,t1.aukstas,t1.aukstu_skaicius,t1.pastato_tipas,t1.pastato_tipas_kitas,t1.kaina,t1.foto,nsb.is_vip from mb_ns_butai_info as t1 INNER JOIN mb_ns_butai AS nsb ON nsb.id = t1.id AND nsb.veiksmas = 0 inner join mb_ns_butai_ypatumai as ty on ty.id=t1.id and ty.value='0' where t1.id > 0 ORDER BY t1.id DESC limit 0,25