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 mos_hp_properties AS p, mos_hp_companies AS c\n LEFT JOIN mos_hp_agents AS a ON p.agent = a.id\n LEFT JOIN mos_hp_prop_types AS t ON p.type = t.id\n LEFT JOIN mos_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 mos_hp_properties AS p, mos_hp_companies AS c
LEFT JOIN mos_hp_agents AS a ON p.agent = a.id
LEFT JOIN mos_hp_prop_types AS t ON p.type = t.id
LEFT JOIN mos_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/regency/public_html/components/com_hotproperty/functions.hotproperty.php on line 69
AUSTRALIA is an enormous country, and visitors expecting to see an opera in Sydney one night and meet Crocodile Dundee the next will have to re-think.......
BHUTAN,First opened to Tourists in 1974 in a very regulated manner upon the coronation of the Bhutan`s present King, this mountain kingdom is still perhaps the world`s.......
DUBAI, in the northeastern United Arab Emirates, is the capital of the state of Dubai and is located on the western side of Dubai Creek.Known as the Venice of the Gulf, Dubai is the chief.....
INDIA a land that showcases culture, ethos, heritage and values. So come and explore the majesty of this enchanting Indian land!! Your tour to India will offer you some fond memories.......
INDONESIA,the largest archipelago in the world,The name Indonesia came from two Greek words: "Indos" meaning Indian and "Nesos" meaning Islands........
MALAYSIA,No visit to South East Asia is complete with without a stopover at Malaysia. A visitor to Malaysia is always struck by the friendly hospitality of her people. Over 19 million......
Marco Polo referred to the Maldives as the ".....flower of the Indies", and Ibn Batuta called her in his chronicles "One of the wonders of the world". Truly a.........
In MAURITIUS,you will see Port Louis the capital of Mauritius, Curepipe , Pample mousses Garden, Casela Bird Park, Chamarel seven color of earth, Ile aux cerf........
NEPAL is a country of amazing extremes. There are the world's highest mountains including Sagarmatha (Mt.Everest) towering above populated valleys and forested..........
SINGAPORE,Renowned worldwide as a thriving, dynamic centre for commerce and industry, Singapore's central location, excellent facilities, cleanliness, fascinating cultural contrasts.........
Seychelles (a group of 115 islands) are located in the western part of Indian ocean just four Degree to the Equator. The climate is warm with maximum temperature and average sunshine of 7 hours a day.
