FileXXXXXXXXXXX

?????????????? ?????????????? ?????????????? ?????????????? ?????????????? ?????????????? ?????????????? ?????????????? ?????????????? ?????????????? ?????????????? ?????????????? ?????????????? ?????????????? ?????????????? ?????????????? FileXXXXXXXXXXX

File manager - Edit - /home/paocyvk/.mysql_history

Back
SELECT DATE_FORMAT(post_date, '%Y-%m') AS order_month, COUNT() AS order_count FROM wp_posts WHERE post_type = 'shop_order' GROUP BY order_month ORDER BY order_month DESC; SELECT DATE_FORMAT(post_date, '%Y-%m') AS order_month, COUNT() AS order_count FROM wp_posts WHERE post_type = 'shop_order' GROUP BY order_month ORDER BY order_month DESC; SELECT COUNT() AS orders_last_30_days FROM wp_wc_orders WHERE date_created_gmt >= UTC_TIMESTAMP() - INTERVAL 30 DAY; SELECT COUNT() AS orders_last_30_days FROM wp_wc_orders WHERE date_created_gmt >= UTC_TIMESTAMP() - INTERVAL 30 DAY; SELECT COUNT() AS orders_last_30_days FROM wp_posts WHERE post_type = 'shop_order' AND post_date >= NOW() - INTERVAL 30 DAY; SELECT COUNT() AS orders_last_30_days FROM wp_posts WHERE post_type = 'shop_order' AND post_date >= NOW() - INTERVAL 30 DAY; show tables; SELECT COUNT() AS orders_last_30_days FROM wor7490_wc_orders WHERE date_created_gmt >= UTC_TIMESTAMP() - INTERVAL 30 DAY; SELECT COUNT() AS orders_last_30_days FROM wor7490_wc_orders WHERE date_created_gmt >= UTC_TIMESTAMP() - INTERVAL 30 DAY; SELECT COUNT() AS orders_last_30_days FROM wor7490_wc_orders WHERE date_created_gmt >= UTC_TIMESTAMP() - INTERVAL 30 DAY AND status LIKE 'wc-%' AND status NOT IN ('wc-failed','wc-cancelled','wc-refunded','trash'); SELECT COUNT() AS orders_last_30_days FROM wor7490_wc_orders WHERE date_created_gmt >= UTC_TIMESTAMP() - INTERVAL 30 DAY AND status LIKE 'wc-%' AND status NOT IN ('wc-failed','wc-cancelled','wc-refunded','trash');