Q&A Home



SELECT problems.id as problem_id, problems.problem_title, problems.state_name, max(date_time) as max_time, min(date_time) as min_time FROM `entries` JOIN problems on entries.problem_id = problems.id WHERE entries.date_time > '1980-01-01 00:00:00' AND ( entries.problem_id = 32919 ) GROUP BY problems.id state_name ;
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'state_name' at line 14