SHARE
TWEET

Untitled

a guest Jul 17th, 2017 50 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT sort_label, release_id, track_info, sort_month, sort_title, sort_year, anv, sort_day, sub_type_id, is_main_release, artist_id, master_id, artist_credit_id, main_type_id,
  2. IF(master_id, concat("M_",master_id), concat("R_", release_id)) AS bucket
  3.  
  4. FROM artist_credits_2 ac
  5.  
  6. WHERE artist_id = 27 AND main_type_id = "4" AND sub_type_id = "5"
  7.  
  8. GROUP BY bucket, main_type_id, sub_type_id
  9.  
  10. ORDER BY IF(sort_year>0, sort_year, 99999) ASC, IF(sort_month>0, sort_month, 99999) ASC, IF(sort_day>0, sort_day, 99999) ASC, sort_title ASC, is_main_release DESC
  11.  
  12.  
  13. LIMIT 500
RAW Paste Data
Top