HIBA:
Unknown column 'assignables_mutations.id' in 'field list'

SQL:

SELECT COUNT(assignables_mutations.id) AS numofrows FROM assignables_mutations m LEFT JOIN assignables a on a.id=m.assignable_id WHERE (name like '%%' OR descript LIKE '%%') AND lang='hu' AND a.is_active=1 AND m.is_active=1 AND now() BETWEEN a.date_active_from AND a.date_active_to AND a.category_id=30