[
"sql" => "SELECT t0_.id AS id_0, t0_.key_name AS key_name_1, t0_.position AS position_2, t0_.filterable AS filterable_3, t0_.icon AS icon_4, t1_.id AS id_5, t1_.locale AS locale_6, t1_.label AS label_7, t2_.id AS id_8, t2_.slug AS slug_9, t2_.created_at AS created_at_10, t3_.id AS id_11, t3_.locale AS locale_12, t3_.label AS label_13, t3_.auto_translated AS auto_translated_14, t4_.id AS id_15, t4_.slug AS slug_16, t4_.created_at AS created_at_17, t5_.id AS id_18, t5_.locale AS locale_19, t5_.label AS label_20, t5_.auto_translated AS auto_translated_21, t1_.tag_category_id AS tag_category_id_22, t2_.tag_category_id AS tag_category_id_23, t2_.parent_id AS parent_id_24, t3_.tag_id AS tag_id_25, t4_.tag_category_id AS tag_category_id_26, t4_.parent_id AS parent_id_27, t5_.tag_id AS tag_id_28 FROM tag_category t0_ LEFT JOIN tag_category_translation t1_ ON t0_.id = t1_.tag_category_id LEFT JOIN tag t2_ ON t0_.id = t2_.tag_category_id LEFT JOIN tag_translation t3_ ON t2_.id = t3_.tag_id LEFT JOIN tag t4_ ON t2_.id = t4_.parent_id LEFT JOIN tag_translation t5_ ON t4_.id = t5_.tag_id WHERE t0_.filterable = 1 ORDER BY t0_.position ASC, t2_.slug ASC"
]