==== ftp ==== [[http://vacwdjk.cluster028.hosting.ovh.net]] > Nom d'hôte (serveur FTP) : ftp.cluster028.hosting.ovh.net > Identifiant (login FTP) : vacwdjk > Mot de passe (password FTP) : g3d3UuhAuq5R ==== ssh ==== > ssh vacwdjk@ssh.cluster028.hosting.ovh.net -p 22 > Votre mot de passe est : g3d3UuhAuq5R ==== mysql ==== [[https://phpmyadmin.cluster028.hosting.ovh.net/index.php?pma_username=vacwdjkprod&pma_servername=vacwdjkprod.mysql.db]] > vacwdjkprod.mysql.db > vacwdjkprod > QTrFPrXJ5YCgQgxB ===== PREPROD ===== [[https://preprod.mr-scandinave.fr]] ==== mysql ==== [[https://phpmyadmin.cluster028.hosting.ovh.net/index.php?pma_username=vacwdjkdev&pma_servername=vacwdjkdev.mysql.db]] > vacwdjkdev.mysql.db > vacwdjkdev > QTrFPrXJ5YCgQgxB ===== SQL AIDE ===== ** Afficher tous les produits shopping en brouillon avant le 15-09**


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

** Passer en archive tous les produits shopping en brouillon avant le 15-09**

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'

** Afficher tous les produits shopping en brouillon** SELECT * FROM `wp_posts` WHERE `post_status` LIKE 'draft' AND `post_type` LIKE 'shopping' ** Afficher tous les produits shopping en brouillon contenant le mot matelas**

SELECT * FROM `wp_posts` WHERE `post_status` LIKE 'draft' AND `post_type` LIKE 'shopping' AND `post_title` LIKE '%matelas%';

** Supprimer tous les produits shopping en brouillon contenant le mot matelas**

DELETE FROM `wp_posts` WHERE `post_status` LIKE 'draft' AND `post_type` LIKE 'shopping' AND `post_title` LIKE '%matelas%';

** Afficher les produits les + cliqués **

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;