- executeQuery::: SELECT `regiok_id`,`dbnume`, `realnume`,`aktiv`, `id` ,`menu_hely_x`, `menu_hely_y`, `menu_irashely_x`, `menu_irashely_y` FROM info_master.geo_regions LEFT JOIN info_master.geo_cities ON geo_cities.regio = geo_regions.regiok_id WHERE geo_regions.regiok_id > 0 AND `aktiv` LIKE '1' AND `regiok_orszag` = ORDER BY `dbnume` ASC;