nozzy

SELECT COUNT(DISTINCT( object_id)) as totalobject FROM $cbxwpbookmrak_table WHERE user_id = %d

add_action('wp_ajax_wpcf7_rescanned_form', 'wpcf7_rescanned_form');
add_action('wp_ajax_nopriv_wpcf7_rescanned_form', 'wpcf7_rescanned_form');

function wpcf7_rescanned_form() {
  update_option( 'my_option', 'my_value' );
}

add_filter( 'wpcf7_before_send_mail', 'fl_wpcf7_before_send_mail_function' ); 
function fl_wpcf7_before_send_mail_function( $contact_form ) {
  $my_value = get_option( 'my_option' );
}

select 
t1.ID
from wp_posts t1
inner join
(
  select 
  post_id
  from wp_postmeta
  where meta_key = 'status_payment' and meta_value = 'payd' 
) t2 on t2.post_id = t1.ID 
inner join 
(
  select 
  post_id
  from wp_postmeta
  where meta_key = 'items'
) t3 on t3.post_id = t2.post_id
where t1.post_type = 'orders'

SELECT t1.post_id, SUM(t1.dl)
FROM wp_day_download t1
INNER JOIN wp_term_relationships t2 ON t2.object_id = t1.post_id
INNER JOIN wp_term_taxonomy t3 ON t3.term_taxonomy_id = t2.term_taxonomy_id
					                     AND t3.term_id = 179
WHERE t1.date >= DATE_ADD(CURRENT_TIMESTAMP,INTERVAL -7 DAY) 
GROUP BY t1.post_id