I have already tested SQL in MySQL separately. It worked there but not from within PHP. The problem for this was somewhere in PHP, not MySQL. I've checked the column and table names are all correct.