Rails find record with zero has_many records associated [duplicate]

by

Bah, found it here: https://stackoverflow.com/a/5570221/417872

City.includes(:photos).where(photos: { city_id: nil })

More Related Contents:

  1. ActiveRecord Arel OR condition
  2. Join multiple tables with active records
  3. PostgreSQL where all in array
  4. Rails 4 LIKE query – ActiveRecord adds quotes
  5. Find all records which have a count of an association greater than zero
  6. ActiveRecord find_each combined with limit and order
  7. Rails raw SQL example
  8. How to use ANY instead of IN in a WHERE clause?
  9. PostgreSQL GROUP BY different from MySQL?
  10. MySQL not using indexes with WHERE IN clause?
  11. Best way to count rows by arbitrary time intervals
  12. Disable Rails SQL logging in console
  13. LEFT OUTER JOIN in Rails 4
  14. Rails 3 execute custom sql query without a model
  15. Perform this hours of operation query in PostgreSQL
  16. SQL where joined set must contain all values but may contain more
  17. Find records where join doesn’t exist
  18. Prepared Statement on Postgresql in Rails
  19. Insert into … values ( SELECT … FROM … )
  20. How to create id with AUTO_INCREMENT on Oracle?
  21. Difference between EXISTS and IN in SQL?
  22. How should I pass a table name into a stored proc?
  23. What’s the difference between DoCmd.SetWarnings and CurrentDB.Execute
  24. SQL Join Differences
  25. Get the last inserted row ID (with SQL statement) [duplicate]
  26. Get the week start date and week end date from week number
  27. Sql Server deterministic user-defined function
  28. How to get the numeric part from a string using T-SQL?
  29. How to renumber primary index
  30. SQL query to select distinct row with minimum value

Leave a Comment