John Henry Newman

Query=select S.id,S.name,S.price,S.description,MT.MusicType,V.Voice from wp_wp_eStore_tbl as S, A_Musicians as M, A_Musician_Song as AMS, A_Music_Types as MT, A_Voices as V where MT.MusicTypeID=S.MI_MusicTypesID and V.VoiceID=S.MI_VoicesID and S.id=AMS.WP_StoreProductID and M.user_id=AMS.musician_id and M.user_id='14'

Title	Description
Brightly Beams Our Fathers Mercy / Lead Kindly Light	Sung almost out of the hymnbook, Brightly Beams is a choir arrangement with Lead, Kindly Light sung in conjunction with the second verse. They have a similar theme, so they work well together.