Please upgrade here. These earlier versions are no longer being updated and have security issues.
HackerOne users: Testing against this community violates our program's Terms of Service and will result in your bounty being denied.

How to "select DISTINCT" with metode Gdn::sql()

Hello, i ask again about database access.
I modified tag plugins to show trending tag based on latest tag add in discussion.

So, i use metode Gdn::sql() to show tag from database.

My question, how to use select DISTINCT.
I try this code but error:

->select('DISTINCT t.*')
->from('Tag t')
->join('TagDiscussion td', 't.TagID = td.TagID')
->orderBy('td.DateInserted', 'desc')


  • Options
    RiverRiver MVP
    edited June 2016

    here are a few examples that vanilla uses

    ->select('distinct c.InsertUserID', 'COUNT', 'Hits')


    SQL->select('m.Name')->Distinct()->from('UserMeta m')->like('m.Name', 'Profile_%')->get();

    ->join('Permission _p', '_p.JunctionID = '.$ForeignAlias.'.'.$ForeignColumn, 'inner')

    another possibility is build your own query.

    what is your error message?

    Pragmatism is all I have to offer. Avoiding the sidelines and providing centerline pro-tips.

  • Options
    R_JR_J Ex-Fanboy Munich Admin

    In order to get a little more insight by yourself, try using getSelect() instead of get(). Instead of sending the sql command and returning the result, getSelect() will only show you the sql that the query builder has created.

    $sql = Gdn::sql()->select('t.*')
        ->from('Tag t')
        ->join('TagDiscussion td', 't.TagID = td.TagID')
        ->orderBy('td.DateInserted', 'desc')

    You will see that your sql starts with "select DISTINCT as `t.*`" which explains why it throws an error.

    While there are more ways to do so (see the above post), to me the most readable way to avoid that would be to use

  • Options

    Thanks for help., try it and work perfect.

Sign In or Register to comment.