Searching for real estate properties in goa to buy, sale or rent - Choose from wide range of properties at goaproperty4u.com - Goa's read more
fastest growing real estate site providing information on all types of Real Estate Property.
ResidentialCommercial
SELECT *, CAST(wmpr.meta_value AS SIGNED) as proprating FROM `wp_posts` wp
INNER JOIN `wp_postmeta` wmpr ON (wmpr.`post_id` = wp.`ID`)
INNER JOIN `wp_postmeta` wm1 ON (wm1.`post_id` = wp.`ID`) INNER JOIN `wp_term_relationships` wtr2 ON (wp.`ID` = wtr2.`object_id`)
INNER JOIN `wp_term_taxonomy` wtt2 ON (wtr2.`term_taxonomy_id` = wtt2.`term_taxonomy_id`)
INNER JOIN `wp_terms` wt2 ON (wt2.`term_id` = wtt2.`term_id`)
WHERE wp.post_type = 'properties' AND wp.post_status = 'publish'
AND (
( wmpr.meta_key = 'proprating' )
AND ( wtt2.taxonomy = 'city_location' AND wt2.`slug`= 'quepem') AND wm1.meta_key = 'sale_type' AND wm1.meta_value like '%Rent%'
)
GROUP BY wp.ID
ORDER BY wp.post_date DESC limit 0 , 20