nozzy

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
t3.Continent,
t3.Region,
sum(t3.Countries),
sum(t3.LifeDuration),
sum(t3.Population),
sum(t3.Cities),
sum(t4.Languages)
from
(
select
  t1.Code,
  t1.Continent,
  t1.Region,
  t1.Countries,
  t1.LifeDuration,
  t1.Population,
  t2.Cities
  from
   ( 
     select
     Code,
     Continent,
     Region,
     count(Name) as Countries,
     ROUND(AVG(LifeExpectancy), 2) as LifeDuration, 
     SUM(Population) as Population
     from country
     group by Code,Continent,Region
) t1 left join 
(
  select
  CountryCode,
  count(Name) as Cities
  from city
  group by CountryCode 
) t2 on t2.CountryCode = t1.Code
) t3 left join 
(
  select 
  CountryCode,
  count(Language) as Languages
  from countrylanguage
) t4 on t4.CountryCode = t3.Code

group by t3.Continent,t3.Region

select 
p.id,
t.tags,
t.count_tags
from Posts p
inner join 
(
  select 
  posts,
  tags,
  count(tags) as count_tags
  from Posts_Tags 
  group by posts, tags	
) t on t.posts = p.id
where p.date = (за последний час)
order by t.count_tags, p.id

select 
t1.id,
t2.name
from 
shop_products as t1
inner join shop_category_i18n as t2 on t2.id = t1.category_id

SELECT
t1.YEAR,
t1.MONTH,
((t1.REGS - t2.REGS) / t1.REGS) * 100 as DYNAMIC
FROM
(
SELECT
  EXTRACT(YEAR FROM created_at) as YEAR,
  EXTRACT(MONTH FROM created_at) as MONTH,
  COUNT(*) AS REGS
FROM users
GROUP BY EXTRACT(YEAR FROM created_at), EXTRACT(MONTH FROM created_at)
) t1
LEFT JOIN
(
SELECT
  EXTRACT(YEAR FROM created_at) as YEAR,
  EXTRACT(MONTH FROM created_at) as MONTH,
  COUNT(*) AS REGS
FROM users
GROUP BY EXTRACT(YEAR FROM created_at), EXTRACT(MONTH FROM created_at)
) t2 ON t2.YEAR = t1.YEAR
	AND t2.MOUNT = (t1.MOUNT) + 1 

ORDER BY t1.YEAR,t1.MONTH;

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