Vous devez etre connecté

OK

Connexion

Catégories [+]

In aggregated query without GROUP BY, expression #2 of SELECT list contains nonaggregated column 'accrophi.enchere.type'; this is incompatible with sql_mode=only_full_group_by
SELECT *, IF(type=1,prix_depart,prix_direct ) as prix, mise_en_valeur as miseEnValeur FROM enchere WHERE deletedInterface=0 AND actif=1 AND vendu =0 AND commissionDebutPaye=1 AND date_debut<='2024-07-15 07:31:40' AND (`date_fin` > "2024-07-15 07:31:40" OR ( `date_fin` > "2024-07-15 07:31:20" AND `extension_enchere`=1 )) AND `quantite_initial` >`quantite_vendu` AND (categorie0='14555' OR categorie1='14555' OR categorie2='14555' OR categorie3='14555' OR categorie4='14555' OR categorie5='14555' OR categorie_secondaire0='14555' OR categorie_secondaire1='14555' OR categorie_secondaire2='14555' OR categorie_secondaire3='14555' OR categorie_secondaire4='14555' OR categorie_secondaire5='14555') ORDER BY top_categorie DESC, id DESC, date_fin DESC