getQuery(true); $q_concerts->select('*, DATE_FORMAT(concert_date, \'%d %b %Y\') AS concert_date_format'); $q_concerts->from($db->quoteName('sophie_concert','con')); $q_concerts->join('LEFT', $db->quoteName('sophie_country','cou') . ' ON concert_country = country_short'); $q_concerts->join('LEFT', $db->quoteName('sophie_tour','tou') . ' ON concert_tour = tour_id'); //$q_concerts->where($db->quoteName('alb_type') . ' = '. $db->quote($album_type)); $q_concerts->order('concert_date DESC'); //$database->setQuery("SELECT *, DATE_FORMAT(concert_date, '%d %b %Y') AS concert_date_format FROM sophie_concert LEFT JOIN sophie_country ON concert_country = country_short LEFT JOIN sophie_tour ON concert_tour = tour_id ORDER BY concert_date DESC"); $db->setQuery($q_concerts); $concert_list = $db->loadAssocList(); for ($i=0; $i < count($concert_list);$i++) { if ($concert_list[$i-1]['concert_tour'] != $concert_list[$i]['concert_tour'] && !empty($concert_list[$i]['tour_name']) ) { ?>

 
 
.png" title="" border="0" hspace="1">