SELECT act.id, act_name, description, act_mini_bio.bio_short, LOWER(act_url) AS act_url, price.nett_fee FROM act LEFT JOIN ( act_nett_prices AS price NATURAL JOIN( SELECT act_id, nett_fee FROM act_nett_prices WHERE nett_fee > 0 AND county_id = 12 GROUP BY act_id ) t ) ON act.id = price.act_id JOIN act_types ON act.id = act_types.act_id JOIN act_mini_bio ON act.id = act_mini_bio.act_id WHERE active = "y" AND price.nett_fee >0 AND act_types.act_event_id = 1 AND act_types.act_type_id=3 AND act_types.act_sub_type_id = 23 AND act_mini_bio.event_type_id = 1 AND act.min_members <= 55 AND act.max_members >= 0 AND price.nett_fee > 0 AND price.nett_fee <= 10000000000 GROUP BY act_name ORDER BY display_order ASC SELECT act.id, act_name, description, act_mini_bio.bio_short, LOWER(act_url) AS act_url, price.nett_fee FROM act LEFT JOIN ( act_nett_prices AS price NATURAL JOIN( SELECT act_id, nett_fee FROM act_nett_prices WHERE nett_fee > 0 AND county_id = 12 GROUP BY act_id ) t ) ON act.id = price.act_id JOIN act_types ON act.id = act_types.act_id JOIN act_mini_bio ON act.id = act_mini_bio.act_id WHERE active = "y" AND price.nett_fee >0 AND act_types.act_event_id = 1 AND act_types.act_type_id=3 AND act_types.act_sub_type_id = 23 AND act_mini_bio.event_type_id = 1 AND act.min_members <= 55 AND act.max_members >= 0 AND price.nett_fee > 0 AND price.nett_fee <= 10000000000 GROUP BY act_name ORDER BY display_order ASC LIMIT 12