SELECT h.id, r.id_region FROM cni_hopespots h, cni_hopespot_region r WHERE h.status = 1 AND AND h.id = r.id_hopespot
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 h.id = r.id_hopespot' at line 3