SELECT DISTINCT t1 . * , t4.user_plan FROM vv_listings AS t1 LEFT JOIN vv_users AS t4 ON t1.user_id = t4.user_id WHERE t1.listing_is_delete != '2'
AND (listing_name LIKE '%STIFEN SOFA REPAIR WORKS%' OR meta_keys LIKE '%STIFEN SOFA REPAIR WORKS%' )
ORDER BY t1.display_position DESC, t4.user_plan DESC,t1.listing_id DESC