SELECT competition.inscriptions_end, competition_descriptions.title as title_competition, competition_descriptions.permalink as permalink_competition, modality.id as id_modality, modality_descriptions.title as title_modality, modality_descriptions.permalink as permalink_modality FROM competition join competition_descriptions on competition_descriptions.id_competition = competition.id join stage on stage.id_competition = competition.id join modality on competition.id_modality = modality.id join modality_descriptions on modality_descriptions.id_modality = modality.id WHERE competition.active = 1 and competition_descriptions.active = 1 and modality.active = 1 and modality_descriptions.active = 1 and competition_descriptions.id_languages = 1 and modality_descriptions.id_languages = 1 and competition.inscriptions_active = 1 and (DATE(FROM_UNIXTIME(competition.inscriptions_start)) <= '2013-06-19' and DATE(FROM_UNIXTIME(competition.inscriptions_end)) >= '2013-06-19') group by competition.id order by stage.start_date DESC, competition_descriptions.title asc