daily pastebin goal
75%
SHARE
TWEET

Untitled

a guest Jul 17th, 2017 52 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
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top