Announcement

Announcement Module
Collapse
No announcement yet.

Help-a-Newb with query ...

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • Help-a-Newb with query ...

    select distinct
    threads.id,
    threads.name,
    threads.readonly,
    threads.active,
    threads.forumidfk,
    threads.useridfk,
    threads.author,
    threads.datecreated,
    forums.name as forum,
    threads.author as username,
    threads.sticky,
    threads.views,
    conferences.name as conference,
    conferences.id as conferenceid,
    threads.lastpost,
    threads.msgcount as messagecount

    from
    (threads inner join forums on threads.forumidfk = forums.id)
    inner join conferences on forums.conferenceidfk = conferences.id

    where 1=1

    and threads.active = 1


    and threads.forumidfk =



    ======================================

    ... as it is now it works fine but I need to add the following condition :


    and users.testOnly =


    please help with the [select] and [from] (inner join?). Thank you very much.

    =====================================


    order by threads.sticky desc, threads.lastpost desc
Working...
X