DataBase error - SELECT count(*) FROM
(
SELECT COUNT(*)
FROM tblproduct
WHERE producttype ='Himalayan Bazaar'
AND isactive='Yes'
AND stateid='22'
GROUP BY full_address, full_address,contact_emailid,contact_phoneno
) d1DataBase error - SELECT tblorganization.organizationname,
tblorganization.organizationid,
contact_name, full_address,contact_emailid,contact_phoneno,
group_concat( productname order by productname asc SEPARATOR ',') AS productname
FROM tblproduct
LEFT JOIN tblorganization
ON tblproduct.organizationid = tblorganization.organizationid
WHERE producttype ='Himalayan Bazaar'
AND tblproduct.isactive='Yes'
AND tblproduct.stateid='22'
GROUP BY contact_name, full_address,contact_emailid,contact_phoneno Limit 0, 10
Friends Of The Farmer Ministry of Agriculture Govt Of India