Rank full text search results with weighted scores

weighted.sql

SELECT *
FROM products
NATURAL JOIN search_product_conversions 
NATURAL JOIN items
WHERE items.keywords @@ ts_query('fuji | apple')
  AND items.retailer_location_id = 123
  AND search_products_conversions.query = 'fuji apple'
ORDER BY 
  (100 * search_product_conversions.count) + 
  ( 10 * products.popularty) +
  (  1 * ts_rank(items.keywords, ts_query('fuji | apple')))
  DESC
LIMIT 1000