SELECT DISTINCT a.* FROM `#__projects` AS a WHERE a.state = 1 ORDER BY a.ordering ASC