$books_45_and_owners->search ({}, { group_by => 'title', order_by => 'title' })->as_query,
'(SELECT me.id, me.source, me.owner, me.price, owner.id, owner.name
FROM (
- SELECT me.id, me.source, me.owner, me.price
+ SELECT me.id, me.source, me.owner, me.price, me.title
FROM (
SELECT TOP 2
- me.id, me.source, me.owner, me.price, ORDER__BY__001
+ me.id, me.source, me.owner, me.price, me.title
FROM (
SELECT TOP 5
- me.id, me.source, me.owner, me.price, title AS ORDER__BY__001
+ me.id, me.source, me.owner, me.price, me.title
FROM books me
JOIN owners owner ON owner.id = me.owner
WHERE ( source = ? )
GROUP BY title
ORDER BY title
) me
- ORDER BY ORDER__BY__001 DESC
+ ORDER BY title DESC
) me
- ORDER BY ORDER__BY__001
+ ORDER BY title
) me
JOIN owners owner ON owner.id = me.owner
WHERE ( source = ? )