Query utili

Trovare gli utenti Admin

SELECT u.ID, u.user_login, u.user_email
FROM wp_users u
INNER JOIN wp_usermeta um ON u.ID = um.user_id
WHERE um.meta_key = 'wp_capabilities'
  AND um.meta_value LIKE '%administrator%';

Woocommerce

Stati del prodotti:

• publish
• draft
• pending
• trash

Visualizzare Prodotti nel cestino

SELECT p.ID, p.post_title, p.post_status, p.post_type
FROM wp_posts p
WHERE p.post_type = 'product'
  AND p.post_status = 'pending';

SELECT p.ID, p.post_title, p.post_status, p.post_type
FROM wp_posts p
WHERE p.post_type = 'product_variation'
  AND p.post_status = 'trash';

Eliminazioni prodotti da Cestino

DELETE p, pm, tr
FROM wp_posts p
LEFT JOIN wp_postmeta pm ON p.ID = pm.post_id
LEFT JOIN wp_term_relationships tr ON p.ID = tr.object_id
WHERE p.post_type = 'product'
  AND p.post_status = 'trash';

Elenco Prodotti e relativi Vendor Dokan

SELECT 
  p.ID                AS product_id,
  p.post_title        AS product_name,
  MAX(CASE WHEN pm.meta_key = '_sku' THEN pm.meta_value END) AS sku,
  p.post_author       AS vendor_id,
  u.user_login        AS vendor_user_login,
  u.user_email        AS vendor_email
FROM wp_posts p
LEFT JOIN wp_postmeta pm ON pm.post_id = p.ID
LEFT JOIN wp_users u ON u.ID = p.post_author
WHERE p.post_type IN ('product','product_variation')
GROUP BY p.ID, p.post_title, p.post_author, u.user_login, u.user_email
ORDER BY p.ID;

Aggiornare Siteurl e Home

SELECT option_name, option_value FROM wp_options WHERE option_name in ('siteurl','home');

UPDATE wp_options SET option_value = 'http://pve.wp.webmobili.local' WHERE option_name in ('siteurl','home');