DokuWiki

Site Tools

Trace: • goneo • perso • sidebar • compte • technique • mrscandi-ovh • compte2
Hotfix release available: 2025-05-14b "Librarian". upgrade now! [56.2] (what's this?)
serveurs:mrscandi-ovh

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
serveurs:mrscandi-ovh [2021/02/05 09:49] – [PREPROD] quentinserveurs:mrscandi-ovh [2025/08/20 09:41] (current) – external edit 127.0.0.1
Line 11: Line 11:
  
 ==== mysql ==== ==== mysql ====
-[[https://phpmyadmin.cluster028.hosting.ovh.net/index.php?pma_username=vacwdjksql&pma_servername=vacwdjksql.mysql.db]] +[[https://phpmyadmin.cluster028.hosting.ovh.net/index.php?pma_username=vacwdjkprod&pma_servername=vacwdjkprod.mysql.db]] 
-> vacwdjksql.mysql.db +> vacwdjkprod.mysql.db 
-> vacwdjksql+> vacwdjkprod
 > QTrFPrXJ5YCgQgxB > QTrFPrXJ5YCgQgxB
  
Line 26: Line 26:
 > QTrFPrXJ5YCgQgxB > QTrFPrXJ5YCgQgxB
  
 +===== SQL AIDE =====
 +
 +** Afficher tous les produits shopping en brouillon avant le 15-09**
 +<code `sql`>
 +SELECT * FROM `wp_posts` WHERE `post_status` LIKE 'draft' AND `post_modified` < '2021-09-15 15:09:01' AND `post_type` LIKE 'shopping' ORDER BY `wp_posts`.`post_modified` ASC
 +</code>
 +
 +
 +** Passer en archive tous les produits shopping en brouillon avant le 15-09**
 +<code `sql`>UPDATE `wp_posts` SET `post_status` = 'archive' WHERE `post_status` LIKE 'draft' AND `post_modified` < '2021-09-15 15:09:01' AND `post_type` LIKE 'shopping'</code>
 +
 +** Afficher tous les produits shopping en brouillon**
 +<code `sql`>SELECT * FROM `wp_posts` WHERE `post_status` LIKE 'draft' AND `post_type` LIKE 'shopping'</code>
 +
 +
 +** Afficher tous les produits shopping en brouillon contenant le mot matelas**
 +<code `sql`>SELECT * FROM `wp_posts` WHERE `post_status` LIKE 'draft' AND `post_type` LIKE 'shopping' AND `post_title` LIKE '%matelas%';</code>
 +
 +** Supprimer tous les produits shopping en brouillon contenant le mot matelas**
 +<code `sql`>DELETE FROM `wp_posts` WHERE `post_status` LIKE 'draft' AND `post_type` LIKE 'shopping' AND `post_title` LIKE '%matelas%';</code>
 +
 +
 +** Afficher les produits les + cliqués **
 +<code `sql`>SELECT p.ID, p.guid, p.post_title, meta_value as nb_clics
 +FROM `wp_postmeta` pm, wp_posts p 
 +WHERE meta_key = 'nb_clics'
 +AND pm.post_id = p.ID
 +ORDER BY CAST(meta_value AS DECIMAL) DESC
 +LIMIT 200;</code>
serveurs/mrscandi-ovh.1612514981.txt.gz · Last modified: (external edit)