SQL – JOIN last child

This is the solution I came up with:

SELECT child_ID, posts.post_author, wp1.post_author FROM wp_posts posts
LEFT JOIN (
         SELECT MAX(ID) as child_ID, post_parent FROM wp_posts 
         WHERE post_type="ticket_reply"
         GROUP BY post_parent
         ) sl ON posts.ID = sl.post_parent
INNER JOIN wp_posts wp1 on sl.child_ID = wp1.ID
WHERE posts.ID = 1499

Related Posts:

  1. What is a stored procedure?
  2. Unknown column in ‘field list’ error on MySQL Update query
  3. SQL Inner-join with 3 tables?
  4. Conversion failed when converting date and/or time from character string while inserting datetime
  5. MySQL create table if not exists and insert record only if table was created
  6. error, string or binary data would be truncated when trying to insert
  7. ORA-00907: missing right parenthesis
  8. Rename column SQL Server 2008
  9. Why do we need “Relationships” between tables at all?
  10. Using group by on multiple columns
  11. How to declare a variable in MySQL?
  12. How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?
  13. ORA-01843 not a valid month- Comparing Dates
  14. How do I escape a single quote in SQL Server?
  15. Teradata: how to convert varchar value (format ‘dd.mm.yyyy’) to date (format ‘yyyy-mm-dd’ )?
  16. How Stuff and ‘For Xml Path’ work in SQL Server?
  17. Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2)
  18. Oracle SELECT TOP 10 records
  19. must appear in the GROUP BY clause or be used in an aggregate function
  20. How can I return pivot table output in MySQL?
  21. The multi-part identifier could not be bound
  22. MySQL syntax for Join Update
  23. SQLite – UPSERT *not* INSERT or REPLACE
  24. how to drop partition without dropping data in MySQL?
  25. Simple way to calculate median with MySQL
  26. The ALTER TABLE statement conflicted with the FOREIGN KEY constraint
  27. Error 1046 No database Selected, how to resolve?
  28. What is it exactly a BLOB in a DBMS context
  29. How do I do multiple CASE WHEN conditions using SQL Server 2008?
  30. Insert text with single quotes in PostgreSQL
  31. SQL Server IF NOT EXISTS Usage?
  32. How to insert date values into table
  33. Arithmetic overflow error converting numeric to data type numeric
  34. How to SUM and SUBTRACT using SQL?
  35. I want to use CASE statement to update some records in sql server 2005
  36. SELECT DISTINCT on one column
  37. how to remove time from datetime
  38. TSQL PIVOT MULTIPLE COLUMNS
  39. MySQL – UPDATE multiple rows with different values in one query
  40. How to create a MySQL hierarchical recursive query?
  41. Microsoft OLE DB Provider for SQL Server error ‘80004005’
  42. Query to convert from datetime to date mysql
  43. How to query MongoDB with “like”
  44. Equivalent of Oracle’s RowID in SQL Server
  45. Subtract one day from datetime
  46. MySQL equivalent of DECODE function in Oracle
  47. what is the difference between triggers, assertions and checks (in database)
  48. Is it possible to specify condition in Count()?
  49. Replacing NULL with 0 in a SQL server query
  50. How to delete from multiple tables in MySQL?
  51. SQL Server: Make all UPPER case to Proper Case/Title Case
  52. How to copy a row and insert in same table with a autoincrement field in MySQL?
  53. How do I query for all dates greater than a certain date in SQL Server?
  54. Backup a single table with its data from a database in sql server 2008
  55. Error converting data type varchar
  56. updating table rows in postgres using subquery
  57. I want to use CASE statement to update some records in sql server 2005
  58. Cannot create an instance of OLE DB provider Microsoft.Jet.OLEDB.4.0 for linked server null
  59. ORDER BY items must appear in the select list if SELECT DISTINCT is specified
  60. ROW_NUMBER() in MySQ
  61. Foreign key references invalid table
  62. Is there a coalesce-like function in Excel?
  63. What are database constraints?
  64. How do I count unique items in field in Access query?
  65. Postgresql column reference “id” is ambiguous
  66. Inner Joining three tables
  67. How do I view the Explain Plan in Oracle Sql developer?
  68. ORA-01779: cannot modify a column which maps to a non key-preserved table
  69. SUM OVER PARTITION BY
  70. MySQL LIKE IN()?
  71. Filter data based on date in sql
  72. Varchar invalid for Sum operator
  73. SQL: How to properly check if a record exists
  74. ora-06553 pls-306 wrong number or types of arguments in call to ‘ogc_x’
  75. SQL query to extract only the “current” wp_posts?
  76. Sorting search results by taxonomy terms
  77. SQL select of users by metadata
  78. How to properly sanitize strings without $wpdb->prepare?
  79. How to retrieve sticky post in raw sql?
  80. How to remove in the wordpress database all posts revisions except the last three?
  81. Backticks (`) Instead of Single Quotes (‘) in an SQL Statement?
  82. $wpdb get_var issue
  83. posts_where Fails with More than One Custom Field in Query
  84. WP Optimization: Removing Orphaned wp_options (especially the autoload ones)
  85. Inserting rows into a custom table, when plugin is activated
  86. WordPress database error: You have an error in your SQL syntax
  87. dbDelta not creating table (yes, once more)
  88. Restose content from revisions – sql query
  89. Inner Join user tables to select users with roles
  90. $wpdb->prepare with LIKE returning blank array instead of rows
  91. Posts modified in the last 48 hours
  92. Removing posts by sql
  93. Why line returns are not reapply after doing esc_sql?
  94. post id not displaying
  95. How to export 2 week’s worth of posts
  96. Search results sort order failing: set by date only
  97. Insert multiple checkbox values
  98. How to get EVENT based on startday, using BETWEEN
  99. wpdb prepare without placeholder
  100. Firebase with WordPress instead of SQL?