:: SELECT dbm_news.* FROM dbm_news WHERE dbm_news.status AND online_date>DATE_SUB(NOW(),INTERVAL 1 YEAR) AND language='' ORDER BY online_date DESC, id DESC:: UPDATE dbm_news SET clicks=clicks+1,degr=degr+1 WHERE id=13605:: SELECT *,(SELECT name FROM dbm_user WHERE id=dbm_news.user) uname  FROM dbm_news WHERE status AND language='en' AND id=13605:: SELECT CONCAT(firstName, ' ', lastName) FROM dbm_agent WHERE agencyId=5 AND userName=''