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 '%Madras Carpet Service%' )
ORDER BY t1.display_position DESC, t4.user_plan DESC,t1.listing_id DESC