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
