rror geting. (In aggregated query without GROUP BY, expression #2 of SELECT list contains nonaggregated column 'linkycom_eshpd.pr.prod_id'; this is incompatible with sql_mode=only_full_group_by)
Sql: SELECT count(*) as total, pr.* FROM xoodigital_products pr WHERE pr.prod_cat_id LIKE '%44%' AND pr.prod_status = '1' ORDER BY pr.prod_name