vfontjr icon

create_view.sql

vfontjr | PRO | 07/15/22 03:39:34 PM UTC | 0 ⭐ | 12115 πŸ‘οΈ | Never ⏰ | []
SQL |

550 B

|

None

|

0 πŸ‘

/

0 πŸ‘Ž

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;

Comments

  •  icon
    01/01/70 12:00:00 AM UTC
    Plain Text |

    0 B

    |

    πŸ‘

    /

    πŸ‘Ž

    
        
  •  icon
    01/01/70 12:00:00 AM UTC
    Plain Text |

    0 B

    |

    πŸ‘

    /

    πŸ‘Ž

    
        
  •  icon
    01/01/70 12:00:00 AM UTC
    Plain Text |

    0 B

    |

    πŸ‘

    /

    πŸ‘Ž

    
        
  •  icon
    01/01/70 12:00:00 AM UTC
    Plain Text |

    0 B

    |

    πŸ‘

    /

    πŸ‘Ž

    
        
  •  icon
    01/01/70 12:00:00 AM UTC
    Plain Text |

    0 B

    |

    πŸ‘

    /

    πŸ‘Ž

    
        
  •  icon
    01/01/70 12:00:00 AM UTC
    Plain Text |

    0 B

    |

    πŸ‘

    /

    πŸ‘Ž

    
        
  •  icon
    01/01/70 12:00:00 AM UTC
    Plain Text |

    0 B

    |

    πŸ‘

    /

    πŸ‘Ž

    
        
  •  icon
    01/01/70 12:00:00 AM UTC
    Plain Text |

    0 B

    |

    πŸ‘

    /

    πŸ‘Ž

    
        
  •  icon
    01/01/70 12:00:00 AM UTC
    Plain Text |

    0 B

    |

    πŸ‘

    /

    πŸ‘Ž

    
        
  •  icon
    01/01/70 12:00:00 AM UTC
    Plain Text |

    0 B

    |

    πŸ‘

    /

    πŸ‘Ž

    
        
  •  icon
    01/01/70 12:00:00 AM UTC
    Plain Text |

    0 B

    |

    πŸ‘

    /

    πŸ‘Ž