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='67'

Have a good day!

Will be adding products soon.

For more information about this product. Please contact us.