SELECT z.full_title, z.entry_seo, g.text as genretype_text, e.id, q.date_year, q.date_month, q.date_day, r.release_year, r.release_month, r.release_day, e.availabletype_id, m.text as machine_type_text,coalesce(z.orig_pubs, z.orig_comps) as pub_names FROM entries e INNER JOIN sc_entries z ON e.id = z.id INNER JOIN releases r on e.id = r.entry_id AND r.release_seq = 0 INNER JOIN search_by_origins q on e.id = q.entry_id LEFT JOIN genretypes g on e.genretype_id = g.id LEFT JOIN machinetypes m on e.machinetype_id = m.id LEFT JOIN availabletypes y on e.availabletype_id = y.id WHERE (e.availabletype_id IS NULL OR e.availabletype_id <> '*') AND (e.id IN (SELECT entry_id FROM search_by_publishers WHERE label_id = (89)) OR e.id IN (SELECT entry_id FROM search_by_authors WHERE label_id = (89)) OR e.id IN (SELECT entry_id FROM relatedlicenses k inner join licensors l on k.license_id = l.license_id WHERE l.label_id = (89))) AND e.is_xrated = 0 AND e.id NOT IN (14579,15100,15101,15102,15103,32305,7376,7716,32241) GROUP BY e.id ORDER BY IF(z.full_title like '[%',1,0), q.library_title, r.release_year, e.id