SELECT t0.id AS t0_0, t0.url AS t0_1, t0.name AS t0_2, t0.intro AS t0_3, t0.snippet AS t0_4, t0.description AS t0_5, t0.image_id AS t0_6, t0.image_id2 AS t0_7, t0.region_id AS t0_8, t0.range_group AS t0_9, t0.c_order AS t0_10, t1.id AS t1_0, t1.range_name AS t1_1, t1.aus_status AS t1_2, t1.nz_status AS t1_3, t1.uk_status AS t1_4, t1.us_status AS t1_5, t1.morder AS t1_6 FROM ranges t0 LEFT JOIN ranges_to_region t1 ON (t0.range_group = t1.id) WHERE t0.region_id = 'uk' AND t1._status = '1' ORDER BY t1.morder