SELECT DISTINCT listings.id
FROM assoc_employees2listings
JOIN listings ON assoc_employees2listings.premium_id = listings.id
LEFT JOIN events ON events.premium_id = listings.id
LEFT JOIN log_sold ON log_sold.premium_id = listings.id
WHERE (category = "featureproperty") AND (location_type LIKE "%Excellent Location%") AND (featureproperty = "1") AND listings.hidden != "1" AND ( DATE_SUB(CURDATE(), INTERVAL 30 DAY) <= log_sold.date_sold OR listings.sold != "1" )
ORDER BY dateadded DESC
Unknown column 'category' in 'where clause'
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/imcn/premium.co.nz/includes/db_objects/listing_finder.php on line 43
SELECT DISTINCT listings.id
FROM assoc_employees2listings
JOIN listings ON assoc_employees2listings.premium_id = listings.id
LEFT JOIN events ON events.premium_id = listings.id
LEFT JOIN log_sold ON log_sold.premium_id = listings.id
WHERE (category = "featureproperty") AND (location_type LIKE "%Excellent Location%") AND (featureproperty = "1") AND listings.hidden != "1" AND ( DATE_SUB(CURDATE(), INTERVAL 30 DAY) <= log_sold.date_sold OR listings.sold != "1" )
ORDER BY dateadded DESC
Unknown column 'category' in 'where clause'
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/imcn/premium.co.nz/includes/db_objects/listing_finder.php on line 70
Sorry, no listings matching those criteria were found. Please edit your search criteria above.
