On Tue, 20 Oct 2009, DaWiz wrote:
I would try:
select max(object_id), term_taxonomy_id
group by term_taxonomy_id
order by term_taxonomy_id;
max(column) returns a single value so distinct is not needed.
The group by and order by should only have columns thaqt are displayed and
that are not aggregate columns.
You end up with the same object_id.
select max(object_id), term_taxonomy_id from wp_term_relationships where
term_taxonomy_id IN (122,127) group by term_taxonomy_id order by
term_taxonomy_id;
+----------------+------------------+
| max(object_id) | term_taxonomy_id |
+----------------+------------------+
| 1503 | 122 |
| 1503 | 127 |
+----------------+------------------+
I'm trying to formulate a query on a Wordpress database that will give me
the highest 'object_id' with the highest 'term_taxonomy_id', something
like:
+-------------------------+------------------+
| max(distinct object_id) | term_taxonomy_id |
+-------------------------+------------------+
| 1503 | 127 |
| 1494 | 122 |
+-------------------------+------------------+
But I just can't seem to get there?
select max(distinct object_id), term_taxonomy_id from wp_term_relationships
where term_taxonomy_id IN (122,127) group by term_taxonomy_id, object_id
order by term_taxonomy_id desc, object_id desc
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
