SELECT a.*,(select segment_name from segment where id=a.segment_id) as segment_name FROM productinfo a WHERE brand_id='epiphone' AND segment_id='66'

Electric Guitar