SELECT i.*, c.name as categoryname,c.id as categoryid, c.alias as categoryalias, c.params as categoryparams 
  FROM #__k2_items as i RIGHT JOIN #__k2_categories AS c 
  ON c.id = i.catid 
  WHERE i.published = 1 
  AND i.access IN(1,1) 
  AND i.trash = 0 
  AND c.published = 1 
  AND c.access IN(1,1) 
  AND c.trash = 0 
  AND c.language IN ('en-GB','*') 
						
  AND i.language IN ('en-GB','*') 
  AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2014-05-28 08:50:43' ) 
  AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2014-05-28 08:50:43' ) 
  AND i.id IN (SELECT itemID 
  FROM #__k2_tags_xref 
  WHERE tagID=5) 
  ORDER BY i.id DESC 
  LIMIT 0, 10