-
SELECT sections.*,
imageTitle.content as Image_Title,
imageCaption.content as Image_Description,
imagePath.content as ImageAsset
FROM sections
left join pageContent as imagePath on sections.id = imagePath.pageID and imagePath.fieldName = "ImageAsset"
left join pageContent as imageTitle on sections.id = imageTitle.pageID and imageTitle.fieldName = "Image_Title"
left join pageContent as imageCaption on sections.id = imageCaption.pageID and imageCaption.fieldName = "Image_Description"
WHERE
sections.module="gallery"
AND imagePath.content != "" AND imagePath.content IS NOT NULL AND sections.status != 3
-
/assets/DSC00903.JPG
-
/assets/DSC00715.JPG
-
/assets/General Park.JPG
Gallery
Images In an around the park
Crook O'Lune's unique position means that you are ideally situated to explore the beauty of the Lune Valley. The majestic River Lune winds its way through the Valley and you will find the area is famous for its trout and salmon fishing with a variety of wildlifein abundance.
Click on the images in the scroller below to view in the larger window above
-
Crook O'Lune
