Összetett keresés

Keresési feltétel(ek)
Sikertelen adatbázisművelet.
index.php:61 {require_once()}
Expression #1 of ORDER BY clause is not in SELECT list, references column 'webvitam_wvita.yis_itemoption.opt_order' which is not in SELECT list; this is incompatible with DISTINCT
SELECT DISTINCT opt_name, yis_item_variant.variant_id, variant_name 
              FROM yis_item_variant
              JOIN yis_variant USING (variant_id)
              JOIN yis_itemoption ON yis_variant.opt_id = yis_itemoption.opt_id WHERE opt_search = 'yes' 
              ORDER BY opt_order, opt_name, variant_order, variant_name
Szűkítő feltétel(ek)

 ...