SHOW:
|
|
- or go back to the newest paste.
| 1 | SELECT | |
| 2 | pro.productID, | |
| 3 | pro.`name`, | |
| 4 | pro.brief_description, | |
| 5 | cat.categoryID | |
| 6 | FROM | |
| 7 | MB_products AS pro | |
| 8 | - | INNER JOIN MB_category_products AS cat ON cat.productID = pro.productID AND COUNT(pro.productID) = 1 |
| 8 | + | INNER JOIN MB_category_products AS cat ON cat.productID = pro.productID |
| 9 | WHERE | |
| 10 | pro.enabled = 1 | |
| 11 | GROUP BY | |
| 12 | - | pro.productID |
| 12 | + | pro.productID |
| 13 | HAVING MIN(pro.productID) = pro.productID |
