SQL Query Error (SELECT c.*, (select name from countries where id = c.ref_country) as country, s.name as state, s.code as state_code
                FROM (regions AS c) 
              
INNER JOIN city_regions AS city_regions ON c.id = city_regions.ref_region
              
INNER JOIN items AS items ON city_regions.ref_city = items.ref_city  AND items.ref_type_level in (4,5,6)
 LEFT JOIN states AS s ON c.ref_state = s.id
 WHERE  c.ref_state = 33 GROUP BY c.id  ORDER BY name ASC) : Got error -1 from storage engine