create_view.sql

CREATE OR REPLACE VIEW wp_irclu_view [('rate_id', 'dropdown_label', 'interest_rate', 'display_color')] AS SELECT t1.meta_value AS rate_id, t2.meta_value AS dropdown_label, t3.meta_value AS interest_rate, t4.meta_value AS display_color FROM `wp_frm_item_metas` t1 LEFT JOIN `wp_frm_item_metas` t2 ON t2.item_id = t1.item_id LEFT JOIN `wp_frm_item_metas` t3 ON t3.item_id = t1.item_id LEFT JOIN `wp_frm_item_metas` t4 ON t4.item_id = t1.item_id WHERE t1.field_id = '1131' AND t2.field_id = '1129' AND t3.field_id = '1130' AND t4.field_id = '1136' ORDER BY t1.meta_value;