Un client és la persona més important a Fincas Armengol: un client no depèn de nosaltres, nosaltres depenem d'ell. Un client no interromp el nostre treball, perquè ell és l'objectiu del nostre treball. No li fem el favor de servir-li. Ell ens fa el favor de donar-nos l'oportunitat de servir-lo.
Column \'type\' in order clause is ambiguous 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, p.piscina_ AS piscina, p.garaje_ AS garaje, p.full_text AS full_text, p.superficie AS superficie, p.ascensor AS ascensor, p.intro_text AS intro_text, p.suburb AS barrio\n FROM jos_hp_properties AS p\n LEFT JOIN jos_hp_agents AS a ON p.agent = a.id\n inner join jos_hp_companies AS c on a.company=c.id\n LEFT JOIN jos_hp_prop_types AS t ON p.type = t.id\n LEFT JOIN jos_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()) AND type=\'35\'\nORDER BY type desc\nLIMIT 0, 10
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, p.piscina_ AS piscina, p.garaje_ AS garaje, p.full_text AS full_text, p.superficie AS superficie, p.ascensor AS ascensor, p.intro_text AS intro_text, p.suburb AS barrio
FROM jos_hp_properties AS p
LEFT JOIN jos_hp_agents AS a ON p.agent = a.id
inner join jos_hp_companies AS c on a.company=c.id
LEFT JOIN jos_hp_prop_types AS t ON p.type = t.id
LEFT JOIN jos_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 type='35'
ORDER BY type desc
LIMIT 0, 10
Apartments and flats 
