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_F where item_facet_F.item = "133" and leaf = 1
select id from item_facet_E where item_facet_E.item = "133" and leaf = 1
select id from item_facet_C where item_facet_C.item = "133" and leaf = 1
select id from item_facet_B where item_facet_B.item = "133" and leaf = 1
select id from item_facet_A where item_facet_A.item = "133" and leaf = 1
select id from item_facet_N where item_facet_N.item = "133" and leaf = 1
select id from item_facet_M where item_facet_M.item = "133" and leaf = 1
select id from item_facet_K where item_facet_K.item = "133" and leaf = 1
select id from item_facet_J where item_facet_J.item = "133" and leaf = 1
select id from item_facet_H where item_facet_H.item = "133" and leaf = 1
select id from item_facet_S where item_facet_S.item = "133" and leaf = 1
select id from item_facet_R where item_facet_R.item = "133" and leaf = 1
select id from item_facet_P where item_facet_P.item = "133" and leaf = 1
select id from item_facet_Z where item_facet_Z.item = "133" and leaf = 1
select Food_Code, Food_Pesticides, Food_Additives, Food_Ingredients, Food_Nutrients, Food_Illustration, Food_Description from items where item = "133"
select p1, p2, p3, p4, p5, p6, p7, level from facet_S where id = 315
select p1, p2, p3, p4, p5, p6, level from facet_Z where id = 2
select child.id, count(*) as count, child.name as name from facet_A as child, item_facet_A as map, item_facet_E as item_facet_E_1, item_facet_M as item_facet_M_2, item_facet_S as item_facet_S_3, item_facet_Z as item_facet_Z_4 where child.parent = 0 and item_facet_E_1.id = 41 and item_facet_M_2.id = 249 and item_facet_M_2.item = item_facet_E_1.item and item_facet_S_3.id = 315 and item_facet_S_3.item = item_facet_E_1.item and item_facet_Z_4.id = 2 and item_facet_Z_4.item = item_facet_E_1.item and map.id = child.id and map.item = item_facet_E_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 map, item_facet_E as item_facet_E_1, item_facet_M as item_facet_M_2, item_facet_S as item_facet_S_3, item_facet_Z as item_facet_Z_4 where child.parent = 0 and item_facet_E_1.id = 41 and item_facet_M_2.id = 249 and item_facet_M_2.item = item_facet_E_1.item and item_facet_S_3.id = 315 and item_facet_S_3.item = item_facet_E_1.item and item_facet_Z_4.id = 2 and item_facet_Z_4.item = item_facet_E_1.item and map.id = child.id and map.item = item_facet_E_1.item group by child.id having count > 0 order by name limit 0,11
select name from facet_B where parent=73
select child.id, count(*) as count, child.name as name from facet_C as child, item_facet_C as map, item_facet_E as item_facet_E_1, item_facet_M as item_facet_M_2, item_facet_S as item_facet_S_3, item_facet_Z as item_facet_Z_4 where child.parent = 0 and item_facet_E_1.id = 41 and item_facet_M_2.id = 249 and item_facet_M_2.item = item_facet_E_1.item and item_facet_S_3.id = 315 and item_facet_S_3.item = item_facet_E_1.item and item_facet_Z_4.id = 2 and item_facet_Z_4.item = item_facet_E_1.item and map.id = child.id and map.item = item_facet_E_1.item group by child.id having count > 0 order by name limit 0,11
9 2025-12-07 18:31:22 select name from facet_C where parent=44
/Dietary-Data_-_19-09-05/Wedge?group=facet_C&q=facet_A%3A826%2Ffacet_E%3A39%2Ffacet_J%3A2%2Ffacet_M%3A249%2Ffacet_S%3A15
select count(*) from item_facet_A as item_facet_A_1, item_facet_E as item_facet_E_2, item_facet_J as item_facet_J_3, item_facet_M as item_facet_M_4, item_facet_S as item_facet_S_5 where item_facet_A_1.id = 826 and item_facet_E_2.id = 39 and item_facet_E_2.item = item_facet_A_1.item and item_facet_J_3.id = 2 and item_facet_J_3.item = item_facet_A_1.item and item_facet_M_4.id = 249 and item_facet_M_4.item = item_facet_A_1.item and item_facet_S_5.id = 15 and item_facet_S_5.item = item_facet_A_1.item