get( 'criteria' ); $artists = $params->get( 'artists' ); $num = $params->get( 'num_artists' ); switch($criteria){ case 'featured': $where = ' WHERE ar.id IN ('.$artists.') ' ; $order = ' ' ; break; case 'random': //$where = ' WHERE ar.publish = 1 ' ; $order = ' ORDER BY RAND() ' ; $limit = ' LIMIT ' . $num ; break; case 'latest': //$where = ' WHERE ar.publish = 1 ' ; $order = ' ORDER BY added DESC ' ; $limit = ' LIMIT ' . $num ; break; } $query = ' SELECT ar.*, ar.picture AS image, ge.genre_name, ar.artist_name AS name FROM #__muscol_artists as ar '. ' LEFT JOIN #__muscol_genres as ge ON ge.id = ar.genre_id ' . $where . $order . $limit ; $_db->setQuery( $query ); $featured_artists_data = $_db->loadObjectList(); if($params->get( 'cardtemplate' ) == "detailed") $showalbums = true; else $showalbums = false; $featured_artists_data = MusColHelper::prepareArtistsData($featured_artists_data, $showalbums); return $featured_artists_data; } }