SELECT match_id as id, CONCAT(`home`.`team_name`,' vs ', `away`.`team_name` ) as title, field.field_name as `location`, field.field_id as `field_id`, m.match_field as `match_field`, DATE_FORMAT(`match_date`,'%m/%d/%Y') as `event_date`, DATE_FORMAT(`match_date`,'%Y-%m-%d') as `startdate`, DATE_FORMAT(`match_date`,'%Y-%m-%d') as `enddate`, DATE_FORMAT(`match_time`,'%H:%i') as `event_time`, 'match' as source, `m`.`division_id` as `division_id`, `d`.`division_name` as `division_name`, 'Games' as `header`, `c`.`competition_name` as `competition_name` FROM `match` m LEFT JOIN `competition` c ON (c.competition_id = m.competition_id) LEFT JOIN division d ON (d.division_id = m.division_id) LEFT JOIN team home ON ( m.team_home_id = home.team_id ) LEFT JOIN team away ON ( m.team_visitor_id = away.team_id ) LEFT JOIN field ON (field.field_id = m.field_id) WHERE m.match_date > DATE_SUB(NOW(), INTERVAL 1 MONTH) ORDER BY event_date, field_id, event_time, match_field ASC FlagPlus Football League - About Us