Unknown column \'p.type\' in \'on clause\' SQL=INSERT INTO jos_hp_temp (`id`, `type`, `address`, `suburb`, `state`, `postcode`, `price`) \n SELECT p.id, p.type, p.address, p.suburb, p.state, p.postcode, p.price\n FROM jos_hp_properties AS p, jos_hp_companies AS c\n LEFT JOIN jos_hp_prop_types AS t ON p.type = t.id\n LEFT JOIN jos_hp_agents AS a ON p.agent = a.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())