SELECT
  *
FROM
  postings Postings
  // LEFT JOIN query ..
WHERE
  (
    // where query..
  )
ORDER BY
  Postings.premium DESC,
  FIELD(Postings.source, "local") DESC,
  Postings.cpc DESC

SELECT
  MATCH (Postings.title) AGAINST ('developer' IN BOOLEAN MODE) AS `Postings__relavance_title`,
  MATCH (Postings.description) AGAINST ('developer' IN BOOLEAN MODE) AS `Postings__relavance_description`,
  // other Fields
FROM
  postings Postings
  // LEFT JOIN queries ...
WHERE
  (
    MATCH (
      Postings.title, Postings.description
    ) AGAINST ('developer' IN BOOLEAN MODE)
  )
ORDER BY
  (Postings__relavance_title * 2)+ Postings__relavance_description DESC,
  Postings.premium DESC,
  FIELD(Postings.source, "local") DESC,
  Postings.cpc DESC