Displaying 1 result from an estimated 1 matches for "merch_items".
2005 Dec 10
0
Paginate - Count(*) Broken or Am I Cheating?
...nly three.
Is this a bug? It seems strange that the two operations would have different
limiting factors.
Perhaps I am cheating by putting DISTINCT into the :select option. If so, is
there another way to handle this?
You can see the generated queries below:
LOG: statement: SELECT COUNT(*) FROM merch_items as mi JOIN merch_formats
mf ON mi.id = mf.merch_item_id JOIN artists art ON mi.artist_id = art.id
WHERE (mf.active_status = 1 AND format_name = ''T-Shirt'' AND format_name <>
''Poster'')
LOG: statement: SELECT DISTINCT mi.id, mi.merch_image, mi.created_at,
m...