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_B where item_facet_B.item = "180" and leaf = 1
select id from item_facet_A where item_facet_A.item = "180" and leaf = 1
select id from item_facet_N where item_facet_N.item = "180" and leaf = 1
select id from item_facet_M where item_facet_M.item = "180" and leaf = 1
select id from item_facet_K where item_facet_K.item = "180" and leaf = 1
select id from item_facet_J where item_facet_J.item = "180" and leaf = 1
select id from item_facet_H where item_facet_H.item = "180" and leaf = 1
select id from item_facet_S where item_facet_S.item = "180" and leaf = 1
select id from item_facet_R where item_facet_R.item = "180" and leaf = 1
select id from item_facet_P where item_facet_P.item = "180" and leaf = 1
select id from item_facet_Z where item_facet_Z.item = "180" and leaf = 1
select Food_Code, Food_Pesticides, Food_Additives, Food_Ingredients, Food_Nutrients, Food_Illustration, Food_Description from items where item = "180"
select p1, p2, p3, p4, p5, p6, p7, p8, p9, p10, level from facet_B where id = 1969
select p1, p2, p3, p4, p5, p6, p7, p8, level from facet_C where id = 153
select p1, p2, p3, p4, p5, p6, level from facet_E where id = 39
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_P as item_facet_P_4 where child.parent = 0 and item_facet_B_1.id = 1969 and item_facet_C_2.id = 153 and item_facet_C_2.item = item_facet_B_1.item and item_facet_E_3.id = 39 and item_facet_E_3.item = item_facet_B_1.item and item_facet_P_4.id = 2 and item_facet_P_4.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_P as item_facet_P_4 where child.parent = 1969 and item_facet_B_1.id = 1969 and item_facet_C_2.id = 153 and item_facet_C_2.item = item_facet_B_1.item and item_facet_E_3.id = 39 and item_facet_E_3.item = item_facet_B_1.item and item_facet_P_4.id = 2 and item_facet_P_4.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_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_P as item_facet_P_4 where child.parent = 153 and item_facet_B_1.id = 1969 and item_facet_C_2.id = 153 and item_facet_C_2.item = item_facet_B_1.item and item_facet_E_3.id = 39 and item_facet_E_3.item = item_facet_B_1.item and item_facet_P_4.id = 2 and item_facet_P_4.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=175
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_P as item_facet_P_4 where child.parent = 39 and item_facet_B_1.id = 1969 and item_facet_C_2.id = 153 and item_facet_C_2.item = item_facet_B_1.item and item_facet_E_3.id = 39 and item_facet_E_3.item = item_facet_B_1.item and item_facet_P_4.id = 2 and item_facet_P_4.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_E where parent=40
8 2025-12-18 21:45:52 /Dietary-Data_-_19-09-05/Wedge?group=facet_K&q=facet_A%3A826%2Ffacet_B%3A1949%2Ffacet_E%3A41%2Ffacet_F%3A3%2Ffacet_P%3A20
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_P as item_facet_P_4 where child.parent = 0 and item_facet_B_1.id = 1969 and item_facet_C_2.id = 153 and item_facet_C_2.item = item_facet_B_1.item and item_facet_E_3.id = 39 and item_facet_E_3.item = item_facet_B_1.item and item_facet_P_4.id = 2 and item_facet_P_4.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 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_F as item_facet_F_4, item_facet_P as item_facet_P_5 where item_facet_A_1.id = 826 and item_facet_B_2.id = 1949 and item_facet_B_2.item = item_facet_A_1.item and item_facet_E_3.id = 41 and item_facet_E_3.item = item_facet_A_1.item and item_facet_F_4.id = 3 and item_facet_F_4.item = item_facet_A_1.item and item_facet_P_5.id = 20 and item_facet_P_5.item = item_facet_A_1.item