DokuWiki

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 vacwdjk@ssh.cluster028.hosting.ovh.net -p 22
Votre mot de passe est : g3d3UuhAuq5R

https://phpmyadmin.cluster028.hosting.ovh.net/index.php?pma_username=vacwdjkprod&pma_servername=vacwdjkprod.mysql.db

vacwdjkprod.mysql.db
vacwdjkprod
QTrFPrXJ5YCgQgxB

https://preprod.mr-scandinave.fr

https://phpmyadmin.cluster028.hosting.ovh.net/index.php?pma_username=vacwdjkdev&pma_servername=vacwdjkdev.mysql.db

vacwdjkdev.mysql.db
vacwdjkdev
QTrFPrXJ5YCgQgxB

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;