http://www.abu-dhabi-real-estate.com

Unknown column \'p.agent\' in \'on clause\' SQL=SELECT p.*, a.name AS agent, a.user AS user, p.agent AS agentid, c.name AS company, c.id AS companyid, t.name AS type, p.type AS typeid \n FROM abu_hp_properties AS p, abu_hp_companies AS c\n LEFT JOIN abu_hp_agents AS a ON p.agent = a.id\n LEFT JOIN abu_hp_prop_types AS t ON p.type = t.id\n LEFT JOIN abu_hp_featured AS f ON f.property = p.id\n WHERE p.published=\'1\' AND p.approved=\'1\' AND t.published=\'1\'\n AND a.company=c.id\n AND (publish_up = \'0000-00-00 00:00:00\' OR publish_up <= NOW())\n AND (publish_down = \'0000-00-00 00:00:00\' OR publish_down >= NOW())\nAND p.featured=\'1\'\nORDER BY f.ordering ASC\nLIMIT 0, 3

SELECT p.*, a.name AS agent, a.user AS user, p.agent AS agentid, c.name AS company, c.id AS companyid, t.name AS type, p.type AS typeid 
 FROM abu_hp_properties AS p, abu_hp_companies AS c
 LEFT JOIN abu_hp_agents AS a ON p.agent = a.id
 LEFT JOIN abu_hp_prop_types AS t ON p.type = t.id
 LEFT JOIN abu_hp_featured AS f ON f.property = p.id
 WHERE p.published='1' AND p.approved='1' AND t.published='1'
 AND a.company=c.id
	AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= NOW())
	AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= NOW())
AND p.featured='1'
ORDER BY f.ordering ASC
LIMIT 0, 3

Warning: Invalid argument supplied for foreach() in /home/dubaicbh/www.abu-dhabi-real-estate.com/components/com_stbestate/functions.stbestate.php on line 64