Clés USB Logo arrow Clés USB Promotionnelles
Le Spécialiste de la clé usb publicitaire et personnalisée !

Column \'type\' in order clause is ambiguous 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 (jos_hp_properties AS p, jos_hp_companies AS c)\n LEFT JOIN jos_hp_agents AS a ON p.agent = a.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=\'1\'\nORDER BY type desc
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 
 FROM (jos_hp_properties AS p, jos_hp_companies AS c)
 LEFT JOIN jos_hp_agents AS a ON p.agent = a.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='1'
ORDER BY type desc

Warning: Invalid argument supplied for foreach() in /home/awanaby/sd/www.cles-usb-publicitaires/www/components/com_hotproperty/functions.hotproperty.php on line 69
> CLES USB
Affiche #
  Trier par : | << AZ >> | << Fabriquant >> | << Type >> |
Pas de fiches

Résultats 1 - 25 sur 108
<< Début < Précédente 1 2 3 4 5 Suivante > Fin >>

Top des ventes

CLE USB USB-056
GI-USB-056

Events Calendar

Mai 2012
D L M M J V S
29301 2 3 4 5
6 7 8 9 10 11 12
13 14 15 16 17 18 19
20 21 22 23 24 25 26
27 28 29 30 31 1 2
Juin 2012
D L M M J V S
27282930311 2
3 4 5 6 7 8 9
10 11 12 13 14 15 16
17 18 19 20 21 22 23
24 25 26 27 28 29 30

Grossiste Import USB
objets entreprise