SELECT p.ID, p.Titulo, p.Subtitulo, p.Noches, p.Plan, p.Moneda, p.Shortdesc, p.Fecha, p.Transporte, p.Origen, p.Oferta, p.Descuento, p.Vendidos, p.Orden, GROUP_CONCAT(DISTINCT d.NombreDest ORDER BY d.NombreDest DESC SEPARATOR ',') as Destinos, MIN(pi.URL) as Imagen, GROUP_CONCAT(DISTINCT d2.NombreDest ORDER BY d2.NombreDest DESC SEPARATOR ',') as Origenes
FROM productos_es as p 
LEFT JOIN producto_destino as pd ON pd.ID_Producto = p.ID AND pd.Tipo_Producto = 'Paquete'
LEFT JOIN destinos_es as d ON pd.ID_Destino = d.ID 
LEFT JOIN producto_images AS pi ON pi.ID_Producto = p.ID AND pi.Tipo_Producto = 'Paquete' AND pi.Orden < 2
LEFT JOIN producto_origen AS po ON po.ID_Producto = p.ID
LEFT JOIN destinos_es AS d2 ON po.ID_Destino = d2.ID

LEFT JOIN producto_tematica AS pt ON pt.ID_Producto = p.ID
WHERE  Archivado!='1'  AND p.Visible='1' AND (Vencimiento='0000-00-00' OR (Alta <= '2025-03-01' AND Vencimiento >= '2025-03-01'))    AND pt.ID_Tematica = 
GROUP BY p.ID ORDER BY p.Orden  
<br><br>Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'GROUP BY p.ID ORDER BY p.Orden' at line 11