Pagination with sorting

[eluser]spyro[/eluser]
I am sure the error would help. It is trying to count from accounts.


A Database Error Occurred

Error Number: 1054

Unknown column 'count(mrc.userid_c)' in 'field list'

SELECT `a`.`id`, `a`.`name`, `a`.`billing_address_street`, `a`.`billing_address_city`, `a`.`billing_address_state`, `a`.`billing_address_postalcode`, `a`.`billing_address_country`, `a`.`website`, `a`.`description`, `ac`.`eighthundrednumber_c`, `ac`.`mechanixlooprating_c`, `ac`.`extension_c`, `ac`.`petfriendly_c`, `ac`.`womenowned_c`, `ac`.`providearide_c`, `count(mrc`.`userid_c)` as num_reviews FROM (`accounts` a) JOIN `accounts_cstm` ac ON `ac`.`id_c` = `a`.`id` LEFT JOIN `mech_reviews_cstm` mrc ON `mrc`.`userid_c` = `a`.`id` AND mrc.inactive_c = 1 WHERE `a`.`billing_address_state` = 'Ga' AND `a`.`billing_address_city` = 'Atlanta' ORDER BY `count(mrc`.`id_c)` desc, `a`.`premiummember_c` desc, `a`.`mechanixlooprating_c` desc LIMIT 6