We are experiencing some sever technical problems following a move to another host. Please excuse the inconvenience, we are aiming to get the content of the site back up and running within the next two weeks. Having assessed the work required we would like to take this opportunity to perform a long overdue overhaul of the website. This should improve functionality, and draw upon lessons learned over the last few years. Again, please excuse the inconvenience.
Add this page to your development related bookmarks using the button below.
Support this Initative
Studying Development is maintained by a small group of volunteers. If you like the site and think it's a useful resource, you can support the initiative by making a small donation towards our running costs. We appreciate any support you can provide!
More than 180 courses in over 42 countries, and counting...
Course Directory
Unknown column \'p.agent\' in \'on clause\' SQL=SELECT p.*, a.id AS agentid, a.name AS agent, a.user AS user, 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, 2