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 = "rental") AND (price BETWEEN 1000 AND 2000) AND (rental = "1") AND listings.hidden != "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 = "rental") AND (price BETWEEN 1000 AND 2000) AND (rental = "1") AND listings.hidden != "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.
