Модуль вывода материала с признаком "Рекомендуем", есть? - Mosets Tree

/ Shuffled Featured Listing
} elseif ( $type == 2 && $shuffle_listing ) {

	$database->setQuery( "SELECT l.*, c.cat_name, c.cat_id FROM (#__mt_links AS l, #__mt_cl AS cl, #__mt_cats AS c)"
		.	"\n WHERE link_published='1' && link_approved='1' && link_featured='1'"
		. "\n AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '$now'  ) "
		. "\n AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '$now' ) "
		. "\n AND l.link_id = cl.link_id "
		. "\n AND c.cat_id = cl.cat_id "
		. "\n AND cl.main = 1 "
		.	( (!empty($only_subcats_sql)) ? $only_subcats_sql : '' )
		.	"\n ORDER BY $order $sort "
		//.	"\n LIMIT $count" 
		);
	
	$listing = $database->loadObjectList();

	shuffle( $listing );
	$listing = array_slice( $listing, 0, $count );