Array ( [0] => HY000 [1] => 2006 [2] => MySQL server has gone away ) select s2.VALUE, s3.NAME, s3.CODE, count(s1.ID) as CNT from gxvg_products as s1 join gxvg_prop2prod as s2 on s1.ID=s2.PROD_ID join gxvg_props as s3 on s3.ID = s2.PROP_ID where ACTIVE = "Y" AND s3.FILTERED = "Y" group by s3.CODE, s2.VALUE ;