BOG

      SELECT DISTINCT
         `ID`, `post_date`, `object_status_order`, `huis_KoopPrijs`, `huis_HuurPrijs`, `yog-nbpr_HuurMin`, `yog-nbpr_KoopAanneemSomMin`, `bedrijf_KoopPrijs`, `bedrijf_HuurPrijs`
      FROM 
         `abovo_object_search_index`
      WHERE
         1=1
         AND post_type IN ('bedrijf')
      ORDER BY object_status_order ASC, CAST(`bedrijf_KoopPrijs` AS SIGNED), CAST(`bedrijf_HuurPrijs` AS SIGNED) ASC, post_date DESC