In case you need it, the query file is below:
{
"name": "que_q_pages_breadcrumbs",
"module": "dbconnector",
"action": "single",
"options": {
"connection": "db",
"sql": {
"type": "SELECT",
"columns": [
{
"table": "root",
"column": "title",
"alias": "roottitle"
},
{
"table": "root",
"column": "slug",
"alias": "rootslug"
},
{
"table": "sub1",
"column": "title",
"alias": "sub1title"
},
{
"table": "sub1",
"column": "slug",
"alias": "sub1slug"
},
{
"table": "sub2",
"column": "title",
"alias": "sub2title"
},
{
"table": "sub2",
"column": "slug",
"alias": "sub2slug"
},
{
"table": "sub3",
"column": "title",
"alias": "sub3title"
},
{
"table": "sub3",
"column": "slug",
"alias": "sub3slug"
},
{
"table": "sub4",
"column": "title",
"alias": "sub4title"
},
{
"table": "sub4",
"column": "slug",
"alias": "sub4slug"
},
{
"table": "sub5",
"column": "title",
"alias": "sub5title"
},
{
"table": "sub5",
"column": "slug",
"alias": "sub5slug"
},
{
"table": "sub6",
"column": "title",
"alias": "sub6title"
},
{
"table": "sub6",
"column": "slug",
"alias": "sub6slug"
},
{
"table": "sub7",
"column": "title",
"alias": "sub7title"
},
{
"table": "sub7",
"column": "slug",
"alias": "sub7slug"
}
],
"table": {
"name": "pages",
"alias": "root"
},
"joins": [
{
"table": "pages",
"column": "*",
"alias": "sub1",
"type": "LEFT",
"clauses": {
"condition": "AND",
"rules": [
{
"table": "sub1",
"column": "id_pages",
"operator": "equal",
"value": {
"table": "root",
"column": "up_pages_categories"
},
"operation": "="
}
]
}
},
{
"table": "pages",
"column": "*",
"alias": "sub2",
"type": "LEFT",
"clauses": {
"condition": "AND",
"rules": [
{
"table": "sub2",
"column": "id_pages",
"operator": "equal",
"value": {
"table": "sub1",
"column": "up_pages_categories"
},
"operation": "="
}
]
}
},
{
"table": "pages",
"column": "*",
"alias": "sub3",
"type": "LEFT",
"clauses": {
"condition": "AND",
"rules": [
{
"table": "sub3",
"column": "id_pages",
"operator": "equal",
"value": {
"table": "sub2",
"column": "up_pages_categories"
},
"operation": "="
}
]
}
},
{
"table": "pages",
"column": "*",
"alias": "sub4",
"type": "LEFT",
"clauses": {
"condition": "AND",
"rules": [
{
"table": "sub4",
"column": "id_pages",
"operator": "equal",
"value": {
"table": "sub3",
"column": "up_pages_categories"
},
"operation": "="
}
]
}
},
{
"table": "pages",
"column": "*",
"alias": "sub5",
"type": "LEFT",
"clauses": {
"condition": "AND",
"rules": [
{
"table": "sub5",
"column": "id_pages",
"operator": "equal",
"value": {
"table": "sub4",
"column": "up_pages_categories"
},
"operation": "="
}
]
}
},
{
"table": "pages",
"column": "*",
"alias": "sub6",
"type": "LEFT",
"clauses": {
"condition": "AND",
"rules": [
{
"table": "sub6",
"column": "id_pages",
"operator": "equal",
"value": {
"table": "sub5",
"column": "up_pages_categories"
},
"operation": "="
}
]
}
},
{
"table": "pages",
"column": "*",
"alias": "sub7",
"type": "LEFT",
"clauses": {
"condition": "AND",
"rules": [
{
"table": "sub7",
"column": "id_pages",
"operator": "equal",
"value": {
"table": "sub6",
"column": "up_pages_categories"
},
"operation": "="
}
]
}
}
],
"query": "SELECT root.title AS roottitle, root.slug AS rootslug, sub1.title AS sub1title, sub1.slug AS sub1slug, sub2.title AS sub2title, sub2.slug AS sub2slug, sub3.title AS sub3title, sub3.slug AS sub3slug, sub4.title AS sub4title, sub4.slug AS sub4slug, sub5.title AS sub5title, sub5.slug AS sub5slug, sub6.title AS sub6title, sub6.slug AS sub6slug, sub7.title AS sub7title, sub7.slug AS sub7slug\nFROM pages AS root\nLEFT JOIN pages AS sub1 ON (sub1.id_pages = root.up_pages_categories) LEFT JOIN pages AS sub2 ON (sub2.id_pages = sub1.up_pages_categories) LEFT JOIN pages AS sub3 ON (sub3.id_pages = sub2.up_pages_categories) LEFT JOIN pages AS sub4 ON (sub4.id_pages = sub3.up_pages_categories) LEFT JOIN pages AS sub5 ON (sub5.id_pages = sub4.up_pages_categories) LEFT JOIN pages AS sub6 ON (sub6.id_pages = sub5.up_pages_categories) LEFT JOIN pages AS sub7 ON (sub7.id_pages = sub6.up_pages_categories)\nWHERE root.title = 'Enable'",
"params": [],
"orders": [],
"wheres": {
"condition": "AND",
"rules": [
{
"id": "root.title",
"field": "root.title",
"type": "string",
"operator": "equal",
"value": "Enable",
"data": {
"table": "root",
"column": "title",
"type": "text"
},
"operation": "="
}
],
"conditional": null,
"valid": true
}
}
},
"output": true,
"meta": [
{
"name": "roottitle",
"type": "text"
},
{
"name": "rootslug",
"type": "text"
},
{
"name": "sub1title",
"type": "text"
},
{
"name": "sub1slug",
"type": "text"
},
{
"name": "sub2title",
"type": "text"
},
{
"name": "sub2slug",
"type": "text"
},
{
"name": "sub3title",
"type": "text"
},
{
"name": "sub3slug",
"type": "text"
},
{
"name": "sub4title",
"type": "text"
},
{
"name": "sub4slug",
"type": "text"
},
{
"name": "sub5title",
"type": "text"
},
{
"name": "sub5slug",
"type": "text"
},
{
"name": "sub6title",
"type": "text"
},
{
"name": "sub6slug",
"type": "text"
},
{
"name": "sub7title",
"type": "text"
},
{
"name": "sub7slug",
"type": "text"
}
],
"outputType": "object",
"settings": {
"options": {}
},
"type": "dbconnector_single"
}
