get_panelizer_panel_info.sql

drop temporary table if exists published_content, published_panelizer_nodes;

/* 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 */
select ppn.*, pp.pid, 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