Mon, May 17, 2021
 
https://devcodepro.comdevcodepro
X
Home · Latest · Trends  /  SQL
4

select *, COUNT left join MySQL

SELECT *, COUNT(reviewid) AS counter FROM article LEFT JOIN reviews on article.id = reviews.articleid GROUP BY article.id, reviews.articleid ORDER BY article.id DESC LIMIT 12;
rated 4 times (4) (0)
comments: 0 / hits: 3255  / 4 years ago, sun, aug 6, 17, 05:14:06
More From » SQL
 

Comments

There are no comments for this Snippet yet
Only authorized users can post. Please sign in first, or register a free account
 
Share
Posted
bigjoe
Member since Aug 6, 2017
Total Code Snippets: 5
Total Comments: 0
Location: n/a
bigjoe snippets
4 years ago, sun, aug 6, 17, 5:31:35
comments: 0 / hits: 2562
SQL
4 years ago, tue, aug 22, 17, 7:46:43
comments: 0 / hits: 1790
4 years ago, tue, aug 22, 17, 6:12:46
comments: 1 / hits: 6197
CSS
4 years ago, wed, aug 30, 17, 5:56:41
comments: 0 / hits: 1452