Check the log file at '/usr/local/flamenco/instances/Dietary-Data_-_19-09-05/log.txt' for more details. Here are the last few lines:
select id from item_facet_Z where item_facet_Z.item = "132" and leaf = 1
select Food_Code, Food_Pesticides, Food_Additives, Food_Ingredients, Food_Nutrients, Food_Illustration, Food_Description from items where item = "132"
select p1, p2, p3, p4, p5, p6, p7, p8, p9, p10, level from facet_B where id = 97
select p1, p2, p3, p4, p5, p6, p7, p8, level from facet_C where id = 45
select p1, p2, p3, p4, p5, p6, level from facet_E where id = 40
select p1, p2, p3, p4, p5, p6, p7, level from facet_S where id = 634
select child.id, count(*) as count, child.name as name from facet_A as child, item_facet_A as map, item_facet_B as item_facet_B_1, item_facet_C as item_facet_C_2, item_facet_E as item_facet_E_3, item_facet_M as item_facet_M_4, item_facet_S as item_facet_S_5 where child.parent = 0 and item_facet_B_1.id = 97 and item_facet_C_2.id = 45 and item_facet_C_2.item = item_facet_B_1.item and item_facet_E_3.id = 40 and item_facet_E_3.item = item_facet_B_1.item and item_facet_M_4.id = 8 and item_facet_M_4.item = item_facet_B_1.item and item_facet_S_5.id = 634 and item_facet_S_5.item = item_facet_B_1.item and map.id = child.id and map.item = item_facet_B_1.item group by child.id having count > 0 order by name limit 0,11
select name from facet_A where parent=800
select child.id, count(*) as count, child.name as name from facet_B as child, item_facet_B as item_facet_B_1, item_facet_B as map, item_facet_C as item_facet_C_2, item_facet_E as item_facet_E_3, item_facet_M as item_facet_M_4, item_facet_S as item_facet_S_5 where child.parent = 97 and item_facet_B_1.id = 97 and item_facet_C_2.id = 45 and item_facet_C_2.item = item_facet_B_1.item and item_facet_E_3.id = 40 and item_facet_E_3.item = item_facet_B_1.item and item_facet_M_4.id = 8 and item_facet_M_4.item = item_facet_B_1.item and item_facet_S_5.id = 634 and item_facet_S_5.item = item_facet_B_1.item and map.id = child.id and map.item = item_facet_B_1.item group by child.id having count > 0 order by name limit 0,11
select name from facet_B where parent=105
select child.id, count(*) as count, child.name as name from facet_C as child, item_facet_B as item_facet_B_1, item_facet_C as item_facet_C_2, item_facet_C as map, item_facet_E as item_facet_E_3, item_facet_M as item_facet_M_4, item_facet_S as item_facet_S_5 where child.parent = 45 and item_facet_B_1.id = 97 and item_facet_C_2.id = 45 and item_facet_C_2.item = item_facet_B_1.item and item_facet_E_3.id = 40 and item_facet_E_3.item = item_facet_B_1.item and item_facet_M_4.id = 8 and item_facet_M_4.item = item_facet_B_1.item and item_facet_S_5.id = 634 and item_facet_S_5.item = item_facet_B_1.item and map.id = child.id and map.item = item_facet_B_1.item group by child.id having count > 0 order by name limit 0,11
select name from facet_C where parent=91
select child.id, count(*) as count, child.name as name from facet_E as child, item_facet_B as item_facet_B_1, item_facet_C as item_facet_C_2, item_facet_E as item_facet_E_3, item_facet_E as map, item_facet_M as item_facet_M_4, item_facet_S as item_facet_S_5 where child.parent = 40 and item_facet_B_1.id = 97 and item_facet_C_2.id = 45 and item_facet_C_2.item = item_facet_B_1.item and item_facet_E_3.id = 40 and item_facet_E_3.item = item_facet_B_1.item and item_facet_M_4.id = 8 and item_facet_M_4.item = item_facet_B_1.item and item_facet_S_5.id = 634 and item_facet_S_5.item = item_facet_B_1.item and map.id = child.id and map.item = item_facet_B_1.item group by child.id having count > 0 order by name limit 0,11
select child.id, count(*) as count, child.name as name from facet_F as child, item_facet_B as item_facet_B_1, item_facet_C as item_facet_C_2, item_facet_E as item_facet_E_3, item_facet_F as map, item_facet_M as item_facet_M_4, item_facet_S as item_facet_S_5 where child.parent = 0 and item_facet_B_1.id = 97 and item_facet_C_2.id = 45 and item_facet_C_2.item = item_facet_B_1.item and item_facet_E_3.id = 40 and item_facet_E_3.item = item_facet_B_1.item and item_facet_M_4.id = 8 and item_facet_M_4.item = item_facet_B_1.item and item_facet_S_5.id = 634 and item_facet_S_5.item = item_facet_B_1.item and map.id = child.id and map.item = item_facet_B_1.item group by child.id having count > 0 order by name limit 0,11
select name from facet_F where parent=3
select child.id, count(*) as count, child.name as name from facet_G as child, item_facet_B as item_facet_B_1, item_facet_C as item_facet_C_2, item_facet_E as item_facet_E_3, item_facet_G as map, item_facet_M as item_facet_M_4, item_facet_S as item_facet_S_5 where child.parent = 0 and item_facet_B_1.id = 97 and item_facet_C_2.id = 45 and item_facet_C_2.item = item_facet_B_1.item and item_facet_E_3.id = 40 and item_facet_E_3.item = item_facet_B_1.item and item_facet_M_4.id = 8 and item_facet_M_4.item = item_facet_B_1.item and item_facet_S_5.id = 634 and item_facet_S_5.item = item_facet_B_1.item and map.id = child.id and map.item = item_facet_B_1.item group by child.id having count > 0 order by name limit 0,11
select name from facet_G where parent=36
select child.id, count(*) as count, child.name as name from facet_H as child, item_facet_B as item_facet_B_1, item_facet_C as item_facet_C_2, item_facet_E as item_facet_E_3, item_facet_H as map, item_facet_M as item_facet_M_4, item_facet_S as item_facet_S_5 where child.parent = 0 and item_facet_B_1.id = 97 and item_facet_C_2.id = 45 and item_facet_C_2.item = item_facet_B_1.item and item_facet_E_3.id = 40 and item_facet_E_3.item = item_facet_B_1.item and item_facet_M_4.id = 8 and item_facet_M_4.item = item_facet_B_1.item and item_facet_S_5.id = 634 and item_facet_S_5.item = item_facet_B_1.item and map.id = child.id and map.item = item_facet_B_1.item group by child.id having count > 0 order by name limit 0,11
select name from facet_H where parent=649
select child.id, count(*) as count, child.name as name from facet_J as child, item_facet_B as item_facet_B_1, item_facet_C as item_facet_C_2, item_facet_E as item_facet_E_3, item_facet_J as map, item_facet_M as item_facet_M_4, item_facet_S as item_facet_S_5 where child.parent = 0 and item_facet_B_1.id = 97 and item_facet_C_2.id = 45 and item_facet_C_2.item = item_facet_B_1.item and item_facet_E_3.id = 40 and item_facet_E_3.item = item_facet_B_1.item and item_facet_M_4.id = 8 and item_facet_M_4.item = item_facet_B_1.item and item_facet_S_5.id = 634 and item_facet_S_5.item = item_facet_B_1.item and map.id = child.id and map.item = item_facet_B_1.item group by child.id having count > 0 order by name limit 0,11
select name from facet_J where parent=27
select child.id, count(*) as count, child.name as name from facet_K as child, item_facet_B as item_facet_B_1, item_facet_C as item_facet_C_2, item_facet_E as item_facet_E_3, item_facet_K as map, item_facet_M as item_facet_M_4, item_facet_S as item_facet_S_5 where child.parent = 0 and item_facet_B_1.id = 97 and item_facet_C_2.id = 45 and item_facet_C_2.item = item_facet_B_1.item and item_facet_E_3.id = 40 and item_facet_E_3.item = item_facet_B_1.item and item_facet_M_4.id = 8 and item_facet_M_4.item = item_facet_B_1.item and item_facet_S_5.id = 634 and item_facet_S_5.item = item_facet_B_1.item and map.id = child.id and map.item = item_facet_B_1.item group by child.id having count > 0 order by name limit 0,11
5 2025-12-08 12:35:02 select name from facet_K where parent=3
/Dietary-Data_-_19-09-05/Wedge?group=facet_E&q=facet_A%3A952%2Ffacet_B%3A97%2Ffacet_E%3A39%2Ffacet_G%3A36%2Ffacet_K%3A8
select count(*) from item_facet_A as item_facet_A_1, item_facet_B as item_facet_B_2, item_facet_E as item_facet_E_3, item_facet_G as item_facet_G_4, item_facet_K as item_facet_K_5 where item_facet_A_1.id = 952 and item_facet_B_2.id = 97 and item_facet_B_2.item = item_facet_A_1.item and item_facet_E_3.id = 39 and item_facet_E_3.item = item_facet_A_1.item and item_facet_G_4.id = 36 and item_facet_G_4.item = item_facet_A_1.item and item_facet_K_5.id = 8 and item_facet_K_5.item = item_facet_A_1.item