SELECT * FROM #__iclub_club_v WHERE #__iclub_club_v.published=1 order by #__iclub_club_v.category_tx, #__iclub_club_v.name_tx

print