WordPress database error: [Table 'madeofstorm.wp_comments' doesn't exist]
SELECT ID, COUNT( comment_ID ) AS ccount
FROM wp_posts
LEFT JOIN wp_comments ON ( comment_post_ID = ID AND comment_approved = '1')
WHERE ID IN (20,19,18,17,16)
GROUP BY ID
Et finalement le résultat fut plutôt satisfaisant. Voyez plutôt :
WordPress database error: [Table 'madeofstorm.wp_comments' doesn't exist]
SELECT COUNT(comment_ID) FROM wp_comments WHERE comment_post_ID = 20 AND comment_approved = '1';
WordPress database error: [Table 'madeofstorm.wp_comments' doesn't exist]
SELECT COUNT(*) FROM wp_comments WHERE comment_post_ID = '20' AND comment_approved = '1'
WordPress database error: [Table 'madeofstorm.wp_comments' doesn't exist]
SELECT COUNT(comment_ID) FROM wp_comments WHERE comment_post_ID = 19 AND comment_approved = '1';
WordPress database error: [Table 'madeofstorm.wp_comments' doesn't exist]
SELECT COUNT(*) FROM wp_comments WHERE comment_post_ID = '19' AND comment_approved = '1'
WordPress database error: [Table 'madeofstorm.wp_comments' doesn't exist]
SELECT COUNT(comment_ID) FROM wp_comments WHERE comment_post_ID = 18 AND comment_approved = '1';
WordPress database error: [Table 'madeofstorm.wp_comments' doesn't exist]
SELECT COUNT(*) FROM wp_comments WHERE comment_post_ID = '18' AND comment_approved = '1'
J’ai cassé mon lacet gauche.
Ma maman m’en a donné un de remplacement en attendant…
WordPress database error: [Table 'madeofstorm.wp_comments' doesn't exist]
SELECT COUNT(comment_ID) FROM wp_comments WHERE comment_post_ID = 17 AND comment_approved = '1';
WordPress database error: [Table 'madeofstorm.wp_comments' doesn't exist]
SELECT COUNT(*) FROM wp_comments WHERE comment_post_ID = '17' AND comment_approved = '1'
WordPress database error: [Table 'madeofstorm.wp_comments' doesn't exist]
SELECT COUNT(comment_ID) FROM wp_comments WHERE comment_post_ID = 16 AND comment_approved = '1';
WordPress database error: [Table 'madeofstorm.wp_comments' doesn't exist]
SELECT COUNT(*) FROM wp_comments WHERE comment_post_ID = '16' AND comment_approved = '1'