mysqli_sql_exception Object ( [message:protected] => 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 'by YEAR(pro.pro_year) desc' at line 3 [string:Exception:private] => [code:protected] => 1064 [file:protected] => /home/adminmigdal/migdal.sietemedia.com.mx/_migdal5/clases/consultas.class.php [line:protected] => 70 [trace:Exception:private] => Array ( [0] => Array ( [file] => /home/adminmigdal/migdal.sietemedia.com.mx/_migdal5/clases/consultas.class.php [line] => 70 [function] => prepare [class] => mysqli_stmt [type] => -> [args] => Array ( [0] => select pro.pro_id,pro.pro_titulo_es,YEAR(pro.pro_year),pro.pro_img_gal,img.img_url from proyectos as pro inner join imagenes as img on pro.pro_img_gal = img.img_idorder by YEAR(pro.pro_year) desc ) ) [1] => Array ( [file] => /home/adminmigdal/migdal.sietemedia.com.mx/_migdal5/modulos/proyectos.class.php [line] => 198 [function] => selectDatosProyectos [class] => consultas [type] => -> [args] => Array ( ) ) [2] => Array ( [file] => /home/adminmigdal/migdal.sietemedia.com.mx/_migdal5/modulos/proyectos.class.php [line] => 110 [function] => cargaGaleria [class] => proyectos [type] => -> [args] => Array ( ) ) [3] => Array ( [file] => /home/adminmigdal/migdal.sietemedia.com.mx/_migdal5/modulos/clases.php [line] => 27 [function] => proyectosRecientes [class] => proyectos [type] => -> [args] => Array ( [0] => cronologia ) ) ) [previous:Exception:private] => [sqlstate:protected] => 42000 )