Ok so what should I look for?
I see some queries with LIMIT, but they concerns tables: oc_t_item, oc_t_latest_searches and oc_t_pages . But there's nothing about cities/regions. The only query about city is this:
SELECT pk_i_id, fk_i_region_id, s_name, s_name_native, fk_c_country_code, b_active, s_slug, d_coord_lat, d_coord_long
FROM (oc_t_city)
WHERE fk_i_region_id = '3858788'
ORDER BY s_name ASC
So, it should return all cities with region ID 3858788, which is a valid region ID existing in database. When I've run this query in phpmyadmin, I got 5 pages (each with 500 cities) with this ID. So the query works just fine. But when I click on the select field in the dashboard>listings>Edit ad page, the select list of cities is incomplete and it looks like that it has <=1000 cities. Reselecting the region fixes this, and the list of cities is complete. But it's never complete after loading the edit page.