select t1.id, t2.vimeoid, t2.leadimage, t1.year, t1.make, t1.model, t3.type_name from boattest_lifestyle.bt_reviews t1 join boattest_lifestyle.videos t2 on t2.fk_bt_id = t1.id join boattest_lifestyle.types t3 on t3.id = t1.fk_type_id where t1.islive = 1 and t1.fk_brand_id in (1266) order by t1.make asc, t1.year desc , t1.length_ft desc limit 20