SELECT page.*,
    			CASE WHEN page.name = 'index' THEN
    			 0
     			ELSE
     			 1
    			END
     			 as flag
    			FROM page ORDER BY flag, node, orderby
SELECT
		     CASE WHEN type = 'node' THEN
		      1
		     ELSE
		      0
		     END
		      as flag, page.*
		     FROM page
		     WHERE node = 1 AND ( path = 'site' OR type = 'node')
		     ORDER BY flag, orderby
SELECT
		     CASE WHEN type = 'node' THEN
		      1
		     ELSE
		      0
		     END
		      as flag, page.*
		     FROM page
		     WHERE node = 40 AND ( path = 'site' OR type = 'node')
		     ORDER BY flag, orderby
SELECT
		     CASE WHEN type = 'node' THEN
		      1
		     ELSE
		      0
		     END
		      as flag, page.*
		     FROM page
		     WHERE node = 2 AND ( path = 'site' OR type = 'node')
		     ORDER BY flag, orderby
SELECT
		     CASE WHEN type = 'node' THEN
		      1
		     ELSE
		      0
		     END
		      as flag, page.*
		     FROM page
		     WHERE node =  AND ( path = 'aero.html' OR type = 'node')
		     ORDER BY flag, orderby

MySQL ERROR(1064): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND ( path = 'aero.html' OR type = 'node')
		     ORDER BY flag, orderby' at line 9
SELECT
		     CASE WHEN type = 'node' THEN
		      1
		     ELSE
		      0
		     END
		      as flag, page.*
		     FROM page
		     WHERE node =  AND ( path = 'aero.html' OR type = 'node')
		     ORDER BY flag, orderby