Formule
(( ROUND((CHAR_LENGTH(b.article_nom)-CHAR_LENGTH(REPLACE(b.article_nom, 'green', '')))/LENGTH('green')) + ROUND((CHAR_LENGTH(b.article_description)-CHAR_LENGTH(REPLACE(b.article_description, 'green', '')))/LENGTH('green')) ) * 3.5) + (( ROUND((CHAR_LENGTH(b.article_nom)-CHAR_LENGTH(REPLACE(b.article_nom, 'leaves', '')))/LENGTH('leaves')) + ROUND((CHAR_LENGTH(b.article_description)-CHAR_LENGTH(REPLACE(b.article_description, 'leaves', '')))/LENGTH('leaves')) ) * 2.6) + (( ROUND((CHAR_LENGTH(b.article_nom)-CHAR_LENGTH(REPLACE(b.article_nom, 'yellow', '')))/LENGTH('yellow')) + ROUND((CHAR_LENGTH(b.article_description)-CHAR_LENGTH(REPLACE(b.article_description, 'yellow', '')))/LENGTH('yellow')) ) * 2.6) + (( ROUND((CHAR_LENGTH(b.article_nom)-CHAR_LENGTH(REPLACE(b.article_nom, 'hoshi', '')))/LENGTH('hoshi')) + ROUND((CHAR_LENGTH(b.article_description)-CHAR_LENGTH(REPLACE(b.article_description, 'hoshi', '')))/LENGTH('hoshi')) ) * 2.5) + (( ROUND((CHAR_LENGTH(b.article_nom)-CHAR_LENGTH(REPLACE(b.article_nom, 'shigi', '')))/LENGTH('shigi')) + ROUND((CHAR_LENGTH(b.article_description)-CHAR_LENGTH(REPLACE(b.article_description, 'shigi', '')))/LENGTH('shigi')) ) * 2.5) + (( ROUND((CHAR_LENGTH(b.article_nom)-CHAR_LENGTH(REPLACE(b.article_nom, 'streaked', '')))/LENGTH('streaked')) + ROUND((CHAR_LENGTH(b.article_description)-CHAR_LENGTH(REPLACE(b.article_description, 'streaked', '')))/LENGTH('streaked')) ) * 1.8) + (( ROUND((CHAR_LENGTH(b.article_nom)-CHAR_LENGTH(REPLACE(b.article_nom, 'autumn', '')))/LENGTH('autumn')) + ROUND((CHAR_LENGTH(b.article_description)-CHAR_LENGTH(REPLACE(b.article_description, 'autumn', '')))/LENGTH('autumn')) ) * 1.6) + (( ROUND((CHAR_LENGTH(b.article_nom)-CHAR_LENGTH(REPLACE(b.article_nom, 'spring', '')))/LENGTH('spring')) + ROUND((CHAR_LENGTH(b.article_description)-CHAR_LENGTH(REPLACE(b.article_description, 'spring', '')))/LENGTH('spring')) ) * 1.6) + (( ROUND((CHAR_LENGTH(b.article_nom)-CHAR_LENGTH(REPLACE(b.article_nom, 'tender', '')))/LENGTH('tender')) + ROUND((CHAR_LENGTH(b.article_description)-CHAR_LENGTH(REPLACE(b.article_description, 'tender', '')))/LENGTH('tender')) ) * 1.6) + (( ROUND((CHAR_LENGTH(b.article_nom)-CHAR_LENGTH(REPLACE(b.article_nom, 'light', '')))/LENGTH('light')) + ROUND((CHAR_LENGTH(b.article_description)-CHAR_LENGTH(REPLACE(b.article_description, 'light', '')))/LENGTH('light')) ) * 1.5)