StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POMYSQL issue with join query
text
Body
copied!<h1>tbl_group</h1> <p>(<code>group_id</code>, <code>user_id</code>, <code>group_name</code>, <code>group_image</code>, <code>group_description</code>, <code>doi</code>)</p> <pre><code>(9, 28, 'bbb', '1339660354imagesv.jpg', 'dfdsfsdf', '2012-06-14 13:22:34'), (11, 1, 'cccc', '', '', '2012-06-14 14:49:56'), (22, 1, '000', '', '', '2012-06-14 15:31:43'); </code></pre> <h1>tbl_groupnews</h1> <p><code>news_id</code>, <code>user_id</code>, <code>group_id</code>, <code>group_news</code>, <code>doi</code></p> <pre><code>(1, 1, 22, 'hi \n', '2012-06-14 16:20:36'), (2, 1, 22, 'hello', '2012-06-14 16:21:59'), (3, 1, 22, '1111', '2012-06-14 16:25:13'), (4, 1, 22, 'jj', '2012-06-14 16:34:41'), (5, 28, 9, 'hi', '2012-06-15 09:48:47'); </code></pre> <h1> <code>tbl_groupmembers</code></h1> <p><code>groupmember_id</code>, <code>group_id</code>, <code>adder</code>, <code>member</code>, <code>doi</code></p> <pre><code>(1, 9, 28, 1, '2012-06-14 13:22:35'), (2, 9, 28, 66, '2012-06-14 13:22:35'), (4, 11, 1, 2, '2012-06-14 14:49:56'), (5, 11, 1, 28, '2012-06-14 14:49:56'), (6, 11, 1, 62, '2012-06-14 14:49:56'), (36, 22, 1, 28, '2012-06-14 16:15:41'), (37, 22, 1, 62, '2012-06-14 16:16:55'), (38, 22, 1, 66, '2012-06-14 16:18:35'), (39, 22, 1, 70, '2012-06-14 16:19:33'); </code></pre> <p>I run the query </p> <pre><code> SELECT tbl_groups.*, COUNT (tbl_groupnews.news_id) AS cn1, COUNT (tbl_groupmembers.group_id) AS cn2 FROM tbl_groups LEFT JOIN tbl_groupnews ON tbl_groups.group_id = tbl_groupnews.group_id LEFT JOIN tbl_groupmembers ON tbl_groupmembers.group_id = tbl_groups.group_id WHERE (tbl_groups.user_id = 28 OR tbl_groupmembers.member = 28) GROUP BY tbl_groups.group_id </code></pre> <p>My requirement is that I need get all the values from group, count of news and count of members <code>WHERE user_id = 28 or member id = 28</code>.</p> <p>Can anyone help me to find a solution?</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload