Joins/Pivot tables

[Daniel_37]

SELECT * FROM basketball_market where (name LIKE '%- Total Points' OR name LIKE '%- Money Line' OR name LIKE '%- Spread') AND type_id like '266'

basketball_market table:
http://my.jetscreenshot.com/5886/20150305-us2v-35kb

SELECT * 
FROM  `basketball_participant` 
WHERE  `market_id` =242319098
LIMIT 0 , 30

http://my.jetscreenshot.com/5886/m_20150305-dfdx-16kb.jpg

SELECT * 
FROM  `basketball_participant` 
WHERE  `market_id` =242319099
LIMIT 0 , 30

http://my.jetscreenshot.com/5886/20150305-ziux-19kb

SELECT * 
FROM  `basketball_participant` 
WHERE  `market_id` =242319100
LIMIT 0 , 30

http://my.jetscreenshot.com/5886/20150305-derh-17kb

What I want it to look like:
http://my.jetscreenshot.com/5886/20150305-rg24-16kb

I know pivot tables have to be used as well as joins. Any idea which joins have to be used?