friendly_link no has in the query: select friendly_link from news_group  where  (is_show = 1 and lang = 'fr' and group_id = '38')   order by show_order desc, date_create asc  limit 0,1