В России:
В Португалии:
Select count(id) as n from catalog where catalog.lang="ru" and catalog.hide=0 and limit 1
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 'limit 1' at line 1

Избранное

Select *, (Select fname from catalog_photo where catalog_photo.type="gallery" and catalog_photo.idt=catalog.id order by tomain desc, id asc limit 1) as fname, (Select title_ru from catalog_location where catalog_location.id=catalog.region_id limit 1) as region, (Select title_ru from catalog_location where catalog_location.id=catalog.city_id limit 1) as city from catalog where catalog.lang="ru" and catalog.hide=0 and order by timecreate desc limit 0,33
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 'order by timecreate desc limit 0,33' at line 4