SELECT name, id, link, css, ident, sss, winner, start,
                 date_format(start,'%a %D %b \'%y') as nicedate,
                 date_format(start,'%Y-%m-%d') as date_code, signup, type,
                 signupstart, signupend, abandoned, numperteam,
                 courseid, mintee,
                 signuptimestart, signuptimeend, signuptimestartv2, signuptimeendv2, entrants, limitsignup,
                 limitsignupnum, enablereservelist, categories, fiveday, reqpayment, use_gc, directpay,
                 date_format(payment_deadline,'%d-%m-%Y') as nicedeadline, start, open, extbookingref, entrygroup,
                 signdelayhours, signdelayminutes, visitor_signup, round, parentcomp, name as origname, start as date
          FROM sm_competitions
          WHERE ((multiday = 0) OR (parentcomp != id)) AND numrounds = 0  AND ((start >= CURDATE() AND status !=3) OR (type = 8 AND signupend >= CURDATE())) AND id NOT IN (SELECT DISTINCT competition_id FROM sm_compgroups_competitions)   AND open = 1 
          AND imported !=2 AND mixedchild != 1 AND open != 2
          AND event_id = 0
           AND type !=12
          AND type != 14
          ORDER BY start ASC, round ASC  LIMIT 20<br>Table 'contacttickets.sm_competitions' doesn't exist<pre><pre>Array
(
    [0] => Array
        (
            [file] => /data/compinclude.php
            [line] => 6930
            [function] => execute
            [class] => Query
            [type] => ->
            [args] => Array
                (
                )

        )

    [1] => Array
        (
            [file] => /data/competition.php
            [line] => 155
            [function] => getNormalComps
            [args] => Array
                (
                    [0] => 1
                    [1] => 1
                    [2] => 
                    [3] => ASC
                    [4] =>  AND ((start >= CURDATE() AND status !=3) OR (type = 8 AND signupend >= CURDATE())) AND id NOT IN (SELECT DISTINCT competition_id FROM sm_compgroups_competitions)
                    [5] => 
                )

        )

)