select ar_pages.p_id,p_title,p_thumb,p_url,p_summary,p_date from ar_pages inner join pages_categories on ar_pages.p_id = pages_categories.p_id where pages_categories.c_id =196 and pages_categories.lang=1 and p_deleted=0 and p_active=1 order by p_date desc , p_priority ,p_id desc limit 0,10