The query below returns 6 products instead of 4 products, I noticed that when I just select everything that there are 3 transactions and I think it selects these as well, how can I fix that?
SELECT tblstores.*, COUNT(tblproducts.product_id) AS products FROM tblstores LEFT JOIN tblproducts ON tblstores.store_id = tblproducts.store_id ORDER BY tblstores.store_id DESC LIMIT 20
