Prepare statement error
Out of memory; check if mysqld or some other process uses all available memory; if not, you may have to use 'ulimit' to allow mysqld to use more memory or you can add more swap space
SELECT * FROM (
SELECT 'page' `ELEMENT`, CONCAT_WS(' ', d.TRIGGER_TYPE, d.TRIGGER_EVENT) `TYPE`, d.TRIGGER_BL `BL`
FROM FLC_PAGE a, FLC_TRIGGER d
WHERE a.PAGEID = '37' AND d.TRIGGER_ITEM_TYPE = 'page' AND d.TRIGGER_ITEM_ID = a.PAGEID AND d.TRIGGER_STATUS = 1
UNION SELECT 'component', CONCAT_WS(' ', d.TRIGGER_TYPE, d.TRIGGER_EVENT), d.TRIGGER_BL
FROM FLC_PAGE a, FLC_PAGE_COMPONENT b, FLC_TRIGGER d
WHERE a.PAGEID = '37' AND a.PAGEID = b.PAGEID AND d.TRIGGER_ITEM_TYPE = 'component' AND d.TRIGGER_ITEM_ID = b.COMPONENTID AND d.TRIGGER_STATUS = 1
UNION SELECT 'item', CONCAT_WS(' ', d.TRIGGER_TYPE, d.TRIGGER_EVENT), d.TRIGGER_BL
FROM FLC_PAGE a, FLC_PAGE_COMPONENT b, FLC_PAGE_COMPONENT_ITEMS c, FLC_TRIGGER d
WHERE a.PAGEID = '37' AND a.PAGEID = b.PAGEID AND b.COMPONENTID = c.COMPONENTID AND d.TRIGGER_ITEM_TYPE = 'item' AND d.TRIGGER_ITEM_ID = c.ITEMID AND d.TRIGGER_STATUS = 1
UNION SELECT 'control', CONCAT_WS(' ', d.TRIGGER_TYPE, d.TRIGGER_EVENT), d.TRIGGER_BL
FROM FLC_PAGE a, FLC_TRIGGER d, FLC_PAGE_CONTROL c
WHERE a.PAGEID = '37' AND a.PAGEID = c.PAGEID AND d.TRIGGER_ITEM_TYPE = 'control' AND d.TRIGGER_ITEM_ID = c.CONTROLID AND d.TRIGGER_STATUS = 1
) ZZZ ORDER BY 2