г. Петрозаводск
Select catalog_stores.id, catalog_stores.geopoint, catalog_stores.title, catalog_stores.timetable, catalog_rests.count from catalog_rests, catalog_stores where catalog_rests.idc= and catalog_stores.id=catalog_rests.ids and catalog_stores.hide=0 and catalog_rests.count>0 order by catalog_stores.pos asc