Hotel Superior

Seleccione el destino de su interés

SELECT d.ID, NombreDest FROM destinos_es as d LEFT JOIN producto_destino AS pd ON pd.ID_Destino = d.ID LEFT JOIN productos_es AS p ON p.ID = pd.ID_Producto 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 <= '2019-06-26' AND Vencimiento >= '2019-06-26')) AND h.ID = '1300' GROUP BY d.ID ORDER BY NombreDest

Error: Unknown column 'h.ID' in 'where clause'