SELECT M.id, (SELECT name FROM sc_media WHERE catID=M.id AND modul='products' AND type='image' AND mode='' ORDER BY ordering LIMIT 1) as kep, M.name_hun as name, M.kulcsszo_hun as kulcsszo,
                M.afa, M.aktiv, M.ptype, M.fitimgtoframe,
                (SELECT if(onsale,saleprice,price) FROM sc_ws_products_price WHERE product_variant_id=V.id AND valuta_id='' AND usergroup_id='10' ORDER BY price LIMIT 1) as pprice 
           FROM sc_ws_products M
          INNER JOIN sc_ws_products_variant V ON V.product_id=M.id
          WHERE M.name_hun!='' AND M.aktiv='1' AND V.aktiv='1' 
          GROUP BY M.name_hun
          
          ORDER BY M.name_hun<br>Error!: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'M.name_hun' in 'field list'<br/>