mini-panel-content.sql

drop temporary table if exists published_content, published_panelizer_nodes, panel_info, minis;

/* Get the current published version of the workbench moderated content */
create temporary table if not exists published_content (
select nh.nid, nh.vid from workbench_moderation_node_history as nh
where nh.published = 1);

/* Get the current published version of nodes that use panelizer */
create temporary table if not exists published_panelizer_nodes (
select pe.entity_id, pe.did from panelizer_entity as pe
left join published_content as pc on (pc.nid=pe.entity_id and pc.vid=pe.revision_id)
where pc.nid is not null);

/* Get the panes in the panelizer content */
create temporary table if not exists panel_info ( 
select ppn.*, pp.panel, pp.type, pp.subtype, pp.shown from panels_pane as pp 
left join published_panelizer_nodes as ppn on ppn.did=pp.did
where ppn.entity_id is not null
and pp.type='panels_mini'
);

/* Get all the panes with mini-panels */
create temporary table if not exists minis ( 
select pi.entity_id, pm.name, pm.did, pm.admin_title from panel_info as pi
left join panels_mini as pm on pm.name=pi.subtype
where pm.name is not null
order by pi.entity_id
);

/* Get the contents of the mini-panels in published panelizer pages */
select distinct m.name, m.did, pp.type, pp.subtype from panels_pane as pp
left join minis as m on m.did=pp.did
where name is not null
order by did asc;