PageHelpersqlsqlcount;
execute using the paging plug-in, nesting a layer of SELECT COUNT (*) FROM (main sql) tmp_count
SELECT count(*)
FROM (SELECT
c.company_name,
c.company_type,
...
FROM company c
INNER JOIN t_seller ts ON ts.city_site_id = c.city_site_id
....
WHERE c.city_site_id = 1) tmp_count
cout