Unknown column 'my_crimerate.php' in 'where clause'

Select d.council_id,d.council_name,d.hectares area, sum(a.vio_total) vio_total, sum(a.sex_total) sex_total, sum(a.dish_total) dish_total, sum(a.fire_total) fire_total, sum(a.other_total) other_total, sum(a.misc_total) misc_total, sum(a.motor_total) motor_total, sum(a.all_total) all_total , c.title_short from total_electoral_ward a join scotland_electoral_ward b on a.ward_id=b.unit_id join scotland_council d on b.council_id=d.council_id join crimeyear c on a.crimeyearid=c.ID where d.council_id=my_crimerate.php group by d.council_id,d.council_name,d.hectares, c.title_short order by c.ID desc