SELECT 
						`references`.*,
						`pictures`.`thumbnail`,
						CONCAT(Seo_Url(`reference_title`), '/', `references`.`id`) as `seo_name`
					FROM
						`references`
					LEFT JOIN
						`pictures`
						ON `pictures`.`table`='references' AND `item_id`=`references`.`id` AND `default_pic`=1
					WHERE
							 `language`="0" AND `active`=1
					ORDER BY
						`reference_year` DESC, `id` DESC LIMIT 0,24