SELECT `products`.* FROM `products` INNER JOIN collection_items ON products.collection_item_id = collection_items.id WHERE `products`.`product_type_id` = 1 AND (products.status = 'live') AND (products.belongs_to_sv = true) ORDER BY products.weight DESC
I am trying to get the record set ordered by
products.weight but with only unique values for
When I try to group, the
ORDER BY isn't obeyed.