Selcet if Anweisung

[petro_0]

Hallo,

bekomme folgendes Select Statement nicht gebacken.

Wer kann mir einen Tip geben?

SELECT ID_SMTOOLS, ID_NUMBER, TYPE, NETZELEMENT, GIS_ABFRAGE, DATUM_CC, STATUS_CC, X_SA_BEGIN, X_REQUESTED_BEGIN, NAS_LOG,  

    IF (
        TYPE LIKE '%Geplante Arbeiten%' 
            
            and 
                X_SA_BEGIN != '' 
            and 
                X_REQUESTED_BEGIN != '' 
            and (
                TIMESTAMPDIFF(SECOND, X_ST_BEGIN, NOW()) < 86400 
            or 
                TIMESTAMPDIFF(SECOND, X_REQUESTED_BEGIN, NOW()) < 86400 
            )
    )

            FROM nas_ticket 
            WHERE STATUS_CC<2 
            AND TYPE != 'invalid' 
        
            ORDER BY TYPE DESC, NETZELEMENT 

[asp2php]

http://dev.mysql.com/doc/refman/5.1/...statement.html