Formule
(( ROUND((CHAR_LENGTH(b.article_nom)-CHAR_LENGTH(REPLACE(b.article_nom, 'cascade', '')))/LENGTH('cascade')) + ROUND((CHAR_LENGTH(b.article_description)-CHAR_LENGTH(REPLACE(b.article_description, 'cascade', '')))/LENGTH('cascade')) ) * 3.7) + (( 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, 'narrow', '')))/LENGTH('narrow')) + ROUND((CHAR_LENGTH(b.article_description)-CHAR_LENGTH(REPLACE(b.article_description, 'narrow', '')))/LENGTH('narrow')) ) * 2.6) + (( ROUND((CHAR_LENGTH(b.article_nom)-CHAR_LENGTH(REPLACE(b.article_nom, 'small', '')))/LENGTH('small')) + ROUND((CHAR_LENGTH(b.article_description)-CHAR_LENGTH(REPLACE(b.article_description, 'small', '')))/LENGTH('small')) ) * 2.5) + (( ROUND((CHAR_LENGTH(b.article_nom)-CHAR_LENGTH(REPLACE(b.article_nom, 'bathroom', '')))/LENGTH('bathroom')) + ROUND((CHAR_LENGTH(b.article_description)-CHAR_LENGTH(REPLACE(b.article_description, 'bathroom', '')))/LENGTH('bathroom')) ) * 1.8) + (( ROUND((CHAR_LENGTH(b.article_nom)-CHAR_LENGTH(REPLACE(b.article_nom, 'interior', '')))/LENGTH('interior')) + ROUND((CHAR_LENGTH(b.article_description)-CHAR_LENGTH(REPLACE(b.article_description, 'interior', '')))/LENGTH('interior')) ) * 1.8) + (( ROUND((CHAR_LENGTH(b.article_nom)-CHAR_LENGTH(REPLACE(b.article_nom, 'exterior', '')))/LENGTH('exterior')) + ROUND((CHAR_LENGTH(b.article_description)-CHAR_LENGTH(REPLACE(b.article_description, 'exterior', '')))/LENGTH('exterior')) ) * 1.8) + (( ROUND((CHAR_LENGTH(b.article_nom)-CHAR_LENGTH(REPLACE(b.article_nom, 'planters', '')))/LENGTH('planters')) + ROUND((CHAR_LENGTH(b.article_description)-CHAR_LENGTH(REPLACE(b.article_description, 'planters', '')))/LENGTH('planters')) ) * 1.8) + (( ROUND((CHAR_LENGTH(b.article_nom)-CHAR_LENGTH(REPLACE(b.article_nom, 'kitchen', '')))/LENGTH('kitchen')) + ROUND((CHAR_LENGTH(b.article_description)-CHAR_LENGTH(REPLACE(b.article_description, 'kitchen', '')))/LENGTH('kitchen')) ) * 1.7) + (( ROUND((CHAR_LENGTH(b.article_nom)-CHAR_LENGTH(REPLACE(b.article_nom, 'colour', '')))/LENGTH('colour')) + ROUND((CHAR_LENGTH(b.article_description)-CHAR_LENGTH(REPLACE(b.article_description, 'colour', '')))/LENGTH('colour')) ) * 1.6)