SELECT *, (MATCH(content) AGAINST ('The Argentine has acknowledged the mood in the camp was poor at the start of the year and warns Real Madrid are still in the title race')) score FROM posts WHERE post_id != 2274 AND active = 1 ORDER BY MATCH(content) AGAINST ('The Argentine has acknowledged the mood in the camp was poor at the start of the year and warns Real Madrid are still in the title race') DESC, ABS(CAST(hits - 900 AS SIGNED)) ASC LIMIT 7
BIGINT UNSIGNED value is out of range in '(`indi_news`.`posts`.`hits` - 900)'