select v.id as id_vlog, v.title, v.platforma, v.abonati, v.nr_videos, v.vizualizari, DATE_FORMAT(v.last_update, '%d.%m.%Y %H:%i:%s') as d_last_update, v.autor, DATE_FORMAT(v.data_creare, '%d.%m.%Y') as data_start, v.id_canal, v.id_spec1, cs.denumire_ro as city_s_ro , cs.denumire_en as city_s_en, ts.denumire_ro as country_s_ro , ts.denumire_en as country_s_en, c.denumire_ro as city_ro , c.denumire_en as city_en, t.denumire_ro as country_ro , t.denumire_en as country_en, l.denumire_ro as lang_ro, l.denumire_en as lang_en , viz_vl as ord_saved from vlogs v left outer join clasamente_vloguri cv on cv.id_vlog=v.id left outer join cities cs on cs.id_city=v.id_city_sursa left outer join regions rs on rs.id_region=cs.id_region left outer join countries ts on ts.id_country=v.id_country_sursa left outer join cities c on c.id_city=v.id_city_curent left outer join regions r on r.id_region=c.id_region left outer join countries t on t.id_country=v.id_country_curent left outer join languages l on l.id_lang=v.id_lang where 1=1 and v.tip_canal=1 and v.stare=0 and id in (select id_vlog from vlogs_categories where id_categorie= 42) /* and (v.abonati>10000 or v.abonati=0) and v.vizualizari>100000) */ order by ord_saved limit 0, 20

---