Associated titles [0]
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 = (15689)) OR
e.id IN (SELECT entry_id FROM search_by_authors WHERE label_id = (15689)) 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 = (15689))) 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