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 '))AS ORconVideo,

(SELECT COUNT(*) FROM ordenes WHERE fecha_create BETWEEN ' 00:' at line 3