Query lost WHERE clause when im filtering data in grid
error msg:

Couldn't execute query. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND LOWER(good_name) LIKE LOWER('%yo%')) table_count' at line 1 –

SELECT count(*) as c
FROM
(
SELECT `id`,`sh`,`ty`,`good_name`,`sastavs`,`price`
FROM `edz` AND LOWER(good_name) LIKE LOWER('%yo%')
)

table_count

Formatted query (`edz` AND LOWER == `edz` WHERE LOWER )