• Home
  • About Us
  • Our Services
  • How it works
  • Contact Us
  • Get quote now
  • My Account
  • All Listings
  • Log In
  • Register

Please Select Radious

SELECT  p.ID, p.post_author,
					CONVERT(um.meta_value, UNSIGNED INTEGER) AS package_id
                    
                    FROM
                    wp_posts as p

    

            INNER JOIN wp_postmeta AS pm ON p.ID = pm.post_id
            INNER JOIN wp_usermeta AS um ON p.post_author = um.user_id
            INNER JOIN wp_term_relationships AS tr ON p.ID = tr.object_id
            INNER JOIN wp_term_taxonomy AS tt ON tr.term_taxonomy_id = tt.term_taxonomy_id
            INNER JOIN wp_terms AS t ON tt.term_id = t.term_id
            WHERE p.post_type = 'listing_type' AND `t`.`slug` ='house-hold-services'
            AND p.post_status = 'publish' AND um.meta_key = 'wlt_membership'

    
     GROUP by p.ID 
    
SELECT  p.ID, p.post_author,
					CONVERT(um.meta_value, UNSIGNED INTEGER) AS package_id
                    
                    FROM
                    wp_posts as p

    

            INNER JOIN wp_postmeta AS pm ON p.ID = pm.post_id
            INNER JOIN wp_usermeta AS um ON p.post_author = um.user_id
            INNER JOIN wp_term_relationships AS tr ON p.ID = tr.object_id
            INNER JOIN wp_term_taxonomy AS tt ON tr.term_taxonomy_id = tt.term_taxonomy_id
            INNER JOIN wp_terms AS t ON tt.term_id = t.term_id
            WHERE p.post_type = 'listing_type' AND `t`.`slug` ='house-hold-services'
            AND p.post_status = 'publish' AND um.meta_key = 'wlt_membership'

    
     GROUP by p.ID 
     ORDER BY `package_id` DESC, `p`.`ID` DESC limit 0,25
 

All Categories
Car cleaning
Carpet cleaning
Commercial cleaning
Decontamination
Domestic Cleaning
Garden cleaning
Industrial cleaning
Laundry
Oven Cleaning
Pest Control
Removals
Tile Cleaning
Vet
Window cleaning
 
 

contact
& info

Kleanify Office Address
17 Ensign House,
Admirals Way,
London E14 9XQ
United Kingdom

Call: 02033902201
Email: info@kleanify.com
 

Site Links 
  • Why Choose Kleanify
  • How it works
  • Search Option
Useful Links 
  • Terms and Conditions
  • Privacy Policy
  • Verified Professionals
Help 
  • FAQ
  • Get Quote
  • Testimonials
Newsletter 

Our newsletters will inform you with all changes, updates and achievements made within Kleanify.

Copyright Kleanify ©2021. All Rights Reserved.
Home
  • Home
  • About Us
  • Our Services
  • How it works
  • Contact Us
  • Get quote now

Where are you now?

Set your location by clicking on the map below or typing in your address below.


This website uses cookies to improve user experience. By using our website you consent to all cookies in accordance with our Cookie Policy. Find out more.