Perth's Award Winning Kitchen & Bedroom Specialists
SELECT SQL_CALC_FOUND_ROWS f.*, l2.position, l2.id AS nodeId FROM igf_list l JOIN igf_list_node l1 ON l1.item_id=l.id JOIN igf_list_node l2 ON l1.id=l2.parent_id JOIN igf_file f ON l2.item_id=f.id WHERE l.type = 'gallery' AND l1.id='53' LIMIT -8, 8