Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $rep_metas = array(
- 'cidade',
- 'estado',
- 'endereco',
- 'telefone_1',
- 'telefone_2',
- 'website',
- 'email',
- 'marca'
- );
- $sql = "SELECT $wpdb->posts.ID, $wpdb->posts.post_title, $wpdb->posts.post_name, ";
- foreach ($rep_metas as $key => $post_meta) {
- $sql .= "pm".$key.".meta_value AS ".$post_meta.", ";
- }
- $sql = substr($sql, 0, -2)." ";
- $sql .= "FROM $wpdb->posts ";
- foreach ($rep_metas as $key => $post_meta) {
- $sql .= "
- LEFT OUTER JOIN $wpdb->postmeta pm".$key."
- ON $wpdb->posts.ID = pm".$key.".post_id && pm".$key.".meta_key = '".$post_meta."'
- ";
- }
- $sql .= "WHERE $wpdb->posts.post_status = 'publish' ";
- $sql .= "AND $wpdb->posts.post_type = 'distribuidor' ";
- $sql .= "AND pm1.meta_value = '".$param['estado']."' ";
- if($param['cidade'] != '0'){
- $sql .= "AND pm0.meta_value = '".$param['cidade']."' ";
- }
- $sql .= "ORDER BY $wpdb->posts.post_title DESC ";
- $response = $wpdb->get_results($sql, OBJECT );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement