$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, ORDER__BY__001 AS title
+ SELECT me.id, me.source, me.owner, me.price, me.title
FROM (
- SELECT me.id, me.source, me.owner, me.price, ORDER__BY__001
+ SELECT me.id, me.source, me.owner, me.price, me.title
FROM (
- SELECT me.id, me.source, me.owner, me.price, title AS ORDER__BY__001
+ SELECT me.id, me.source, me.owner, me.price, me.title
FROM books me
JOIN owners owner ON owner.id = me.owner
WHERE ( source = ? )
ORDER BY title
FETCH FIRST 5 ROWS ONLY
) me
- ORDER BY ORDER__BY__001 DESC
+ ORDER BY me.title DESC
FETCH FIRST 2 ROWS ONLY
) me
- ORDER BY ORDER__BY__001
+ ORDER BY me.title
) me
JOIN owners owner ON owner.id = me.owner
WHERE ( source = ? )