alexx855

-- ALL SUBSCRIBERS WITH AN ORDER COMPLETED
SELECT 
    u.ID, um.meta_value AS user_role, COALESCE(COUNT(p.ID), 0) AS completed_orders
FROM wp_users AS u JOIN wp_usermeta AS um ON u.ID = um.user_id 
	LEFT JOIN wp_postmeta AS pm ON pm.meta_value = um.user_id  
    LEFT JOIN wp_posts AS p ON p.ID = pm.post_id 
WHERE um.meta_key = 'wp_capabilities'
    AND um.meta_value LIKE '%subscriber%' 
    AND um.meta_value NOT LIKE '%administrator%'
    AND pm.meta_key = '_customer_user'

alexx855

Code Principles

TypeScript

• Strict type inference only. No as assertions, no any, no ! non-null assertions
• No type annotations when inference works. Let TS infer return types, variable types
• Use satisfies over as when type validation needed
• ES modules only. No require(), no dynamic import(), no conditional imports
• Static imports at file top.