gerske

Hi Salva, I did what you asked. Not sure if the problem is gone now, no new error mention. The error mail from WP was all of a sudden, a mail while I wasn’t doing anything (but maybe a colleague was).

Kind regards Gerske

I switched off all plugins and this bug was gone. The problem is this plugin: WooCommerce EU/UK VAT Compliance.

Thank you. I will fix it with a code snippet that adds a shipping fee.

Any news, Ollie?

Thanks for the help. It still gets stuck with 1.1.6. ;-(

Here is the info you requested:

` wp-core

version: 6.7.2
site_language: nl_NL
user_language: nl_NL
timezone: Europe/Amsterdam
permalink: /%postname%/
https_status: true
multisite: false
user_registration: 0
blog_public: 1
default_comment_status: open
environment_type: production
user_count: 5454
dotorg_communication: true wp-paths-sizes

wordpress_path: /var/www/vhosts/popcards.nl/httpdocs
wordpress_size: 1,36 GB (1455785445 bytes)
uploads_path: /var/www/vhosts/popcards.nl/httpdocs/wp-content/uploads
uploads_size: 5,95 GB (6392039007 bytes)
themes_path: /var/www/vhosts/popcards.nl/httpdocs/wp-content/themes
themes_size: 74,43 MB (78046721 bytes)
plugins_path: /var/www/vhosts/popcards.nl/httpdocs/wp-content/plugins
plugins_size: 231,09 MB (242312375 bytes)
fonts_path: /var/www/vhosts/popcards.nl/httpdocs/wp-content/uploads/fonts
fonts_size: directory not found
database_size: 4,05 GB (4348919808 bytes)
total_size: 11,66 GB (12517103356 bytes) wp-dropins (2)

advanced-cache.php: true
maintenance.php: true wp-active-theme

name: Enfold (enfold)
version: 7.1
author: Kriesi
author_website: https://kriesi.at
parent_theme: none
theme_features: core-block-patterns, avia_exclude_bbPress, deactivate_tribe_events_calendar, avia_exclude_GFForms, avia_exclude_menu_exchange, avia_exclude_pojo_accessibility, avia_exclude_wp_accessibility, avia_exclude_relevanssi, avia_exclude_wpSEO, avia_exclude_wpml, avia_exclude_instagram_feed, avia_exclude_leaflet_map, avia_exclude_acf, avia_mega_menu, avia_improved_backend_style, avia_option_pages_toggles, avia_sidebar_manager, automatic-feed-links, post-formats, avia_post_meta_compat, force-post-thumbnails-in-widget, title-tag, nav_menus, post-thumbnails, widgets, widgets-block-editor, block-templates, menus, woocommerce, editor-styles, editor-style, customize-selective-refresh-widgets, responsive-embeds, editor-color-palette, editor-font-sizes, wc-product-gallery-zoom, wc-product-gallery-slider, avia-wc-30-product-gallery-feature
theme_path: /var/www/vhosts/popcards.nl/httpdocs/wp-content/themes/enfold wp-mu-plugins (1)

Index WP MySQL For Speed Upgrade Filter for mu-plugins.: author: (undefined), version: 1.5.3 wp-plugins-active (42)

Advanced Woo Search: version: 3.30, author: ILLID
Akismet Anti-spam: Spam Protection: version: 5.3.7, author: Automattic – Anti-spam Team
ATUM Action Logs: version: 1.4.7, author: Stock Management Labs™
ATUM Inventory Management for WooCommerce: version: 1.9.46, author: Stock Management Labs™
BEAR – Bulk Editor and Products Manager Professional for WooCommerce: version: 2.1.4.4, author: realmag777
Booster Plus for WooCommerce: version: 7.2.5, author: Pluggabl LLC
Code Snippets: version: 3.6.8, author: Code Snippets Pro
Decorator – WooCommerce Email Customizer: version: 2.0.3, author: WebToffee
Disable Cart Fragments: version: 2.3, author: Optimocha
Fast Woo Order Lookup: version: 1.1.6, author: Ollie Jones
Force Regenerate Thumbnails: version: 2.2.1, author: Exactly WWW
Iconic Sales Booster for WooCommerce: version: 1.25.0, author: Iconic
Index WP MySQL For Speed: version: 1.5.3, author: Oliver Jones, Rick James
Limit Login Attempts Reloaded: version: 2.26.18, author: Limit Login Attempts Reloaded
LiteSpeed Cache: version: 7.0.1, author: LiteSpeed Technologies
MailerLite – WooCommerce integration: version: 2.1.29, author: MailerLite
Mollie Payments for WooCommerce: version: 8.0.0, author: Mollie
MyParcel: version: 4.24.3, author: MyParcel
PDF Invoices & Packing Slips for WooCommerce: version: 4.3.0, author: WP Overnight
PDF Invoices & Packing Slips for WooCommerce – Premium Templates: version: 2.23.0, author: WP Overnight
PDF Invoices & Packing Slips for WooCommerce – Professional: version: 2.16.4, author: WP Overnight
PixelYourSite: version: 10.2.0, author: PixelYourSite
PixelYourSite Pinterest: version: 5.5.3.1, author: PixelYourSite
Postcode Checker for WooCommerce: version: 3.2.0, author: WP Overnight
Product Feed PRO for WooCommerce: version: 13.4.3, author: AdTribes.io
Rank Math SEO: version: 1.0.242, author: Rank Math SEO
Rank Math SEO PRO: version: 3.0.85, author: Rank Math SEO
Review Slider for WooCommerce: version: 1.5, author: LJ Apps
Temporary Login Without Password: version: 1.9.0, author: StoreApps
TranslatePress – Multilingual: version: 2.9.10, author: Cozmoslabs, Razvan Mocanu, Madalin Ungureanu, Cristophor Hurduban
TranslatePress – Personal: version: 1.4.4, author: Cozmoslabs, Razvan Mocanu, Madalin Ungureanu
User Role Editor: version: 4.64.4, author: Vladimir Garagulya
User Switching: version: 1.9.1, author: John Blackbourn
WebwinkelKeur: version: 3.37, author: Albert Peschar
WooCommerce: version: 9.8.1, author: Automattic
WooCommerce DYMO Print: version: 6.0.0, author: WP Fortune
WooCommerce Dynamic Pricing & Discounts: version: 2.4.6, author: RightPress
WooCommerce EU/UK VAT Compliance (Premium): version: 1.33.1, author: David Anderson
WooCommerce Extended Coupon Features PRO: version: 3.3.8, author: Soft79
Woocommerce Side Cart Premium: version: 4.0.4, author: XootiX
Woosa – bol.com for WooCommerce: version: 3.6.1, author: Woosa
WooThumbs for WooCommerce by Iconic: version: 5.12.0, author: Iconic code-snippets (45)

image_editor: WP_Image_Editor_Imagick
imagick_module_version: 1693
imagemagick_version: ImageMagick 6.9.13-10 Q16 x86_64 18376 https://legacy.imagemagick.org
imagick_version: 3.7.0
file_uploads: 1
post_max_size: 512M
upload_max_filesize: 512M
max_effective_size: 512 MB
max_file_uploads: 20
imagick_limits:
imagick::RESOURCETYPE_AREA: 93 GB
imagick::RESOURCETYPE_DISK: 9.2233720368548E+18
imagick::RESOURCETYPE_FILE: 37500
imagick::RESOURCETYPE_MAP: 47 GB
imagick::RESOURCETYPE_MEMORY: 23 GB
imagick::RESOURCETYPE_THREAD: 1
imagick::RESOURCETYPE_TIME: 0
imagemagick_file_formats: 3FR, 3G2, 3GP, A, AAI, AI, APNG, ART, ARW, AVI, AVS, B, BGR, BGRA, BGRO, BIE, BMP, BMP2, BMP3, BRF, C, CAL, CALS, CANVAS, CAPTION, CIN, CIP, CLIP, CMYK, CMYKA, CR2, CR3, CRW, CUR, CUT, DATA, DCM, DCR, DCX, DDS, DFONT, DNG, DPX, DXT1, DXT5, EPDF, EPI, EPS, EPS2, EPS3, EPSF, EPSI, EPT, EPT2, EPT3, ERF, EXR, FAX, FILE, FITS, FLV, FRACTAL, FTP, FTS, G, G3, G4, GIF, GIF87, GRADIENT, GRAY, GRAYA, GROUP4, H, HALD, HDR, HISTOGRAM, HRZ, HTM, HTML, HTTP, HTTPS, ICB, ICO, ICON, IIQ, INFO, INLINE, IPL, ISOBRL, ISOBRL6, J2C, J2K, JBG, JBIG, JNG, JNX, JP2, JPC, JPE, JPEG, JPG, JPM, JPS, JPT, JSON, K, K25, KDC, LABEL, M, M2V, M4V, MAC, MAGICK, MAP, MASK, MAT, MATTE, MEF, MIFF, MKV, MNG, MONO, MOV, MP4, MPC, MPEG, MPG, MRW, MSL, MSVG, MTV, MVG, NEF, NRW, NULL, O, ORF, OTB, OTF, PAL, PALM, PAM, PANGO, PATTERN, PBM, PCD, PCDS, PCL, PCT, PCX, PDB, PDF, PDFA, PEF, PES, PFA, PFB, PFM, PGM, PGX, PICON, PICT, PIX, PJPEG, PLASMA, PNG, PNG00, PNG24, PNG32, PNG48, PNG64, PNG8, PNM, POCKETMOD, PPM, PS, PS2, PS3, PSB, PSD, PTIF, PWP, R, RADIAL-GRADIENT, RAF, RAS, RAW, RGB, RGBA, RGBO, RGF, RLA, RLE, RMF, RW2, SCR, SCREENSHOT, SCT, SFW, SGI, SHTML, SIX, SIXEL, SPARSE-COLOR, SR2, SRF, STEGANO, SUN, SVG, SVGZ, TEXT, TGA, THUMBNAIL, TIFF, TIFF64, TILE, TIM, TTC, TTF, TXT, UBRL, UBRL6, UIL, UYVY, VDA, VICAR, VID, VIDEO, VIFF, VIPS, VST, WBMP, WEBM, WEBP, WMF, WMV, WMZ, WPG, X, X3F, XBM, XC, XCF, XPM, XPS, XV, XWD, Y, YCbCr, YCbCrA, YUV
gd_version: bundled (2.1.0 compatible)
gd_formats: GIF, JPEG, PNG, WebP, BMP, AVIF, XPM
ghostscript_version: 9.27 wp-server

server_architecture: Linux 4.18.0-553.34.1.lve.el8.x86_64 x86_64
httpd_software: LiteSpeed
php_version: 8.3.19 64bit
php_sapi: litespeed
max_input_variables: 5000
time_limit: 300
memory_limit: 1024M
max_input_time: 300
upload_max_filesize: 512M
php_post_max_size: 512M
curl_version: 7.61.1 OpenSSL/1.1.1k
suhosin: false
imagick_availability: true
pretty_permalinks: true
htaccess_extra_rules: true
current: 2025-04-13T07:45:58+00:00
utc-time: Sunday, 13-Apr-25 07:45:58 UTC
server-time: 2025-04-13T09:45:56+02:00 wp-database

extension: mysqli
server_version: 10.11.10-MariaDB-cll-lve
client_version: mysqlnd 8.3.19
max_allowed_packet: 16777216
max_connections: 75 wp-constants

WP_HOME: undefined
WP_SITEURL: undefined
WP_CONTENT_DIR: /var/www/vhosts/popcards.nl/httpdocs/wp-content
WP_PLUGIN_DIR: /var/www/vhosts/popcards.nl/httpdocs/wp-content/plugins
WP_MEMORY_LIMIT: 1024M
WP_MAX_MEMORY_LIMIT: 1024M
WP_DEBUG: false
WP_DEBUG_DISPLAY: false
WP_DEBUG_LOG: true
SCRIPT_DEBUG: false
WP_CACHE: true
CONCATENATE_SCRIPTS: false
COMPRESS_SCRIPTS: undefined
COMPRESS_CSS: undefined
WP_ENVIRONMENT_TYPE: undefined
WP_DEVELOPMENT_MODE: undefined
DB_CHARSET: utf8
DB_COLLATE: undefined wp-filesystem

wordpress: writable
wp-content: writable
uploads: writable
plugins: writable
themes: writable
fonts: not writable
mu-plugins: writable fast-woo-order-lookup

request: Please create a support topic at https://wordpress.org/support/plugin/fast-woo-order-lookup/ and paste this site info (all of it please) into the topic. We will take a look.
woo-features: analytics:enabled; product_block_editor:disabled; cart_checkout_blocks:disabled; rate_limit_checkout:disabled; marketplace:enabled; order_attribution:enabled; site_visibility_badge:enabled; hpos_fts_indexes:disabled; hpos_datastore_caching:disabled; remote_logging:enabled; email_improvements:disabled; blueprint:disabled; reactify-classic-payments-settings:disabled; block_email_editor:disabled; custom_order_tables:disabled; cost_of_goods_sold:disabled
trigram-table: trigrams:76830;first_id:450;last_id:9209
error0: 2025-04-13 09:09:19 event Indexing start
error1: 2025-04-12 16:44:29
event
deactivate:
Deactivate
error2: 2025-04-12 16:36:10
event
activate:
Indexing start
error3: 2025-04-12 16:33:35
event
deactivate:
Deactivate
error4: 2025-04-12 16:22:52
event
activate:
Indexing start
error5: 2025-04-12 16:21:56
event
deactivate:
Deactivate
error6: 2025-04-12 15:35:13
event
activate:
Indexing start
error7: 2025-04-12 15:35:07
event
deactivate:
Deactivate
error8: 2025-04-12 15:03:12
event
activate:
Indexing start
error9: 2025-04-08 09:27:01
indexing
get_order_metadata:
error:
(indexing V1.1.4)
UJWT8j_postmeta:
0: CREATE TABLE UJWT8j_postmeta (
meta_id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
post_id bigint(20) unsigned NOT NULL DEFAULT 0,
meta_key varchar(255) NOT NULL,
meta_value longtext DEFAULT NULL,
PRIMARY KEY (post_id,meta_key,meta_id),
UNIQUE KEY meta_id (meta_id),
KEY meta_key (meta_key,meta_value(32),post_id,meta_id),
KEY meta_value (meta_value(32),meta_id)
) ENGINE=InnoDB AUTO_INCREMENT=4837392 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
UJWT8j_wc_orders_meta:
0: CREATE TABLE UJWT8j_wc_orders_meta (
id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
order_id bigint(20) unsigned NOT NULL,
meta_key varchar(255) NOT NULL,
meta_value text DEFAULT NULL,
PRIMARY KEY (order_id,meta_key,id),
UNIQUE KEY id (id),
KEY meta_key_value (meta_key,meta_value(32),order_id,id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci
UJWT8j_wc_orders:
0: CREATE TABLE UJWT8j_wc_orders (
id bigint(20) unsigned NOT NULL,
status varchar(20) DEFAULT NULL,
currency varchar(10) DEFAULT NULL,
type varchar(20) DEFAULT NULL,
tax_amount decimal(26,8) DEFAULT NULL,
total_amount decimal(26,8) DEFAULT NULL,
customer_id bigint(20) unsigned DEFAULT NULL,
billing_email varchar(320) DEFAULT NULL,
date_created_gmt datetime DEFAULT NULL,
date_updated_gmt datetime DEFAULT NULL,
parent_order_id bigint(20) unsigned DEFAULT NULL,
payment_method varchar(100) DEFAULT NULL,
payment_method_title text DEFAULT NULL,
transaction_id varchar(100) DEFAULT NULL,
ip_address varchar(100) DEFAULT NULL,
user_agent text DEFAULT NULL,
customer_note text DEFAULT NULL,
PRIMARY KEY (id),
KEY status (status),
KEY date_created (date_created_gmt),
KEY customer_id_billing_email (customer_id,billing_email),
KEY billing_email (billing_email),
KEY type_status (type,status),
KEY parent_order_id (parent_order_id),
KEY date_updated (date_updated_gmt)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci
UJWT8j_woocommerce_order_items:
0: CREATE TABLE UJWT8j_woocommerce_order_items (
order_item_id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
order_item_name text NOT NULL,
order_item_type varchar(200) NOT NULL DEFAULT ”,
order_id bigint(20) unsigned NOT NULL,
PRIMARY KEY (order_item_id),
KEY order_id (order_id)
) ENGINE=InnoDB AUTO_INCREMENT=243362 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
UJWT8j_wc_order_addresses:
0: CREATE TABLE UJWT8j_wc_order_addresses (
id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
order_id bigint(20) unsigned NOT NULL,
address_type varchar(20) DEFAULT NULL,
first_name text DEFAULT NULL,
last_name text DEFAULT NULL,
company text DEFAULT NULL,
address_1 text DEFAULT NULL,
address_2 text DEFAULT NULL,
city text DEFAULT NULL,
state text DEFAULT NULL,
postcode text DEFAULT NULL,
country text DEFAULT NULL,
email varchar(320) DEFAULT NULL,
phone varchar(100) DEFAULT NULL,
PRIMARY KEY (id),
UNIQUE KEY address_type_order_id (address_type,order_id),
KEY order_id (order_id),
KEY email (email),
KEY phone (phone)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci
post-types: adt_product_feed:4;at_checkout_ob:16;attachment:1319;atum_supplier:7;avia_framework_post:18;bol_invoice:4;bol_return:133;br_sale_report:2;cartflows_flow:1;cartflows_step:2;follow_up_email:1;jetpack_migration:2;jp_img_sitemap:1;jp_sitemap:1;jp_sitemap_master:1;language_switcher:10;nav_menu_item:38;oembed_cache:2;page:26;post:1;product:374;product_variation:1;product-feed:1;revision:637;rm_content_editor:1;shop_coupon:10;shop_order:69251;shop_order_refund:78;sp_wcslider:1;user_request:1;wcst_trigger:11;wp_global_styles:1;wp_navigation:1
order-postmeta-key: error Unknown column ‘wp_postmeta.meta_id’ in ‘ON’: SELECT meta_key, COUNT() num FROM UJWT8j_postmeta JOIN UJWT8j_posts ON wp_postmeta.meta_id = wp_posts.ID WHERE post_type = ‘shop_order’ GROUP BY meta_key order-types: error : SELECT CONCAT_WS(‘/’, type , status) ts, COUNT() num FROM UJWT8j_wc_orders GROUP BY type, status
order-meta: error : SELECT meta_key, COUNT(*) num FROM UJWT8j_wc_orders_meta GROUP BY meta_key

Hello Ollie, after upgrading to 1.1.4 and doing a search in the order I get a critical error. After deactivating the plugin, search works again. When activating again the error is back. So there seems to be something wrong with this new version. The former version did work.

Here is the info requested:

fast-woo-order-lookup

request: Please create a support topic at https://wordpress.org/support/plugin/fast-woo-order-lookup/ and paste this site info (all of it please) into the topic. We will take a look.
error0: 2025-04-08 09:27:01
indexing
get_order_metadata:
error:
(indexing V1.1.4)
error1: 2025-04-08 09:15:16
indexing
get_order_metadata:
error:
(indexing V1.1.4)
UJWT8j_postmeta:
0: CREATE TABLE UJWT8j_postmeta (
meta_id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
post_id bigint(20) unsigned NOT NULL DEFAULT 0,
meta_key varchar(255) NOT NULL,
meta_value longtext DEFAULT NULL,
PRIMARY KEY (post_id,meta_key,meta_id),
UNIQUE KEY meta_id (meta_id),
KEY meta_key (meta_key,meta_value(32),post_id,meta_id),
KEY meta_value (meta_value(32),meta_id)
) ENGINE=InnoDB AUTO_INCREMENT=4824150 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
UJWT8j_wc_orders_meta:
0: CREATE TABLE UJWT8j_wc_orders_meta (
id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
order_id bigint(20) unsigned NOT NULL,
meta_key varchar(255) NOT NULL,
meta_value text DEFAULT NULL,
PRIMARY KEY (order_id,meta_key,id),
UNIQUE KEY id (id),
KEY meta_key_value (meta_key,meta_value(32),order_id,id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci
UJWT8j_wc_orders:
0: CREATE TABLE UJWT8j_wc_orders (
id bigint(20) unsigned NOT NULL,
status varchar(20) DEFAULT NULL,
currency varchar(10) DEFAULT NULL,
type varchar(20) DEFAULT NULL,
tax_amount decimal(26,8) DEFAULT NULL,
total_amount decimal(26,8) DEFAULT NULL,
customer_id bigint(20) unsigned DEFAULT NULL,
billing_email varchar(320) DEFAULT NULL,
date_created_gmt datetime DEFAULT NULL,
date_updated_gmt datetime DEFAULT NULL,
parent_order_id bigint(20) unsigned DEFAULT NULL,
payment_method varchar(100) DEFAULT NULL,
payment_method_title text DEFAULT NULL,
transaction_id varchar(100) DEFAULT NULL,
ip_address varchar(100) DEFAULT NULL,
user_agent text DEFAULT NULL,
customer_note text DEFAULT NULL,
PRIMARY KEY (id),
KEY status (status),
KEY date_created (date_created_gmt),
KEY customer_id_billing_email (customer_id,billing_email),
KEY billing_email (billing_email),
KEY type_status (type,status),
KEY parent_order_id (parent_order_id),
KEY date_updated (date_updated_gmt)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci
UJWT8j_woocommerce_order_items:
0: CREATE TABLE UJWT8j_woocommerce_order_items (
order_item_id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
order_item_name text NOT NULL,
order_item_type varchar(200) NOT NULL DEFAULT '',
order_id bigint(20) unsigned NOT NULL,
PRIMARY KEY (order_item_id),
KEY order_id (order_id)
) ENGINE=InnoDB AUTO_INCREMENT=242857 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
UJWT8j_wc_order_addresses:
0: CREATE TABLE UJWT8j_wc_order_addresses (
id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
order_id bigint(20) unsigned NOT NULL,
address_type varchar(20) DEFAULT NULL,
first_name text DEFAULT NULL,
last_name text DEFAULT NULL,
company text DEFAULT NULL,
address_1 text DEFAULT NULL,
address_2 text DEFAULT NULL,
city text DEFAULT NULL,
state text DEFAULT NULL,
postcode text DEFAULT NULL,
country text DEFAULT NULL,
email varchar(320) DEFAULT NULL,
phone varchar(100) DEFAULT NULL,
PRIMARY KEY (id),
UNIQUE KEY address_type_order_id (address_type,order_id),
KEY order_id (order_id),
KEY email (email),
KEY phone (phone)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci
post-types: adt_product_feed:4;at_checkout_ob:16;attachment:1317;atum_supplier:7;avia_framework_post:18;bol_invoice:4;bol_return:133;br_sale_report:2;cartflows_flow:1;cartflows_step:2;follow_up_email:1;jetpack_migration:2;jp_img_sitemap:1;jp_sitemap:1;jp_sitemap_master:1;language_switcher:10;nav_menu_item:38;oembed_cache:2;page:26;post:4;product:374;product_variation:1;product-feed:1;revision:636;rm_content_editor:1;shop_coupon:10;shop_order:69103;shop_order_refund:78;sp_wcslider:1;user_request:1;wcst_trigger:11;wp_global_styles:1;wp_navigation:1
order-postmeta-key: error Unknown column 'wp_postmeta.meta_id' in 'ON': SELECT meta_key, COUNT() num FROM UJWT8j_postmeta JOIN UJWT8j_posts ON wp_postmeta.meta_id = wp_posts.ID WHERE post_type = 'shop_order' GROUP BY meta_key order-types: error : SELECT CONCAT_WS('/', type , status) ts, COUNT() num FROM UJWT8j_wc_orders GROUP BY type, status
order-meta: error : SELECT meta_key, COUNT(*) num FROM UJWT8j_wc_orders_meta GROUP BY meta_key