SQL counting all rows instead of counting individual rows

by

You’re missing GROUP BY, so it’s counting everything instead of grouping by some columns.

LEFT JOIN
(
    select `ID` as `AuraID`, `Status` as `AuraStatus`, count(*) as `Aura`
    from messages_aura
    GROUP BY AuraID, AuraStatus
) aura ON (var.Poster = aura.AuraID AND var.ID = aura.AuraStatus)

More Related Contents:

  1. get first occurrence of last changed value of a column [closed]
  2. SQL Print the name of all Employees together with the name of their supervisor
  3. MySQL – Rows to Columns
  4. ROW_NUMBER() in MySQL
  5. Left Outer Join doesn’t return all rows from my left table?
  6. How can I temporarily disable a foreign key constraint in MySQL?
  7. MySQL offset infinite rows
  8. Ordering by the order of values in a SQL IN() clause
  9. sql joins as venn diagram
  10. How can I join multiple SQL tables using the IDs?
  11. MySQL, better to insert NULL or empty string?
  12. SQL: Repeat a result row multiple times, and number the rows
  13. Compare dates in MySQL
  14. Why do results from a SQL query not come back in the order I expect?
  15. MySQL combine two columns and add into a new column
  16. Invalid default value for ‘dateAdded’
  17. How to set a MySQL row to READ-ONLY?
  18. Split a string and loop through values in MySQL stored procedure
  19. How to create dummy variable columns for thousands of categories in Google BigQuery?
  20. MySQL Select Query – Get only first 10 characters of a value
  21. Most efficient way to store IP Address in MySQL [duplicate]
  22. SQL date format convert? [dd.mm.yy to YYYY-MM-DD]
  23. mysql select id and name from other table and join query
  24. SQL (MySQL) vs NoSQL (CouchDB) [closed]
  25. DELETE FROM `table` AS `alias` … WHERE `alias`.`column` … why syntax error?
  26. What happens when I exhaust a bigint generated key? How to handle it?
  27. MySQL update statement to store ranking positions
  28. is there a length limit to group_concat or another reason why it would not work on a text field
  29. How to convert a varchar column type to date type without losing the dates
  30. MySQL Multiple Joins in one query?

Leave a Comment