select DISTINCT i.id, i.* from items i where i.is_deleted = 0 and i.item_type = 'prints_sub' and i.parent_id = 1242 order by CONVERT (i.title USING tis620) asc limit 0,100