1
0.32 ms
SELECT e0_ . id AS id_0 , e0_ . post_code AS post_code_1 , e0_ . facebook_link AS facebook_link_2 , e0_ . instagram_link AS instagram_link_3 , e0_ . pinterest_link AS pinterest_link_4 , e0_ . linkedin_link AS linkedin_link_5 , e0_ . tiktok_link AS tiktok_link_6 , e0_ . youtube_link AS youtube_link_7 , e0_ . vimeo_link AS vimeo_link_8 , e0_ . email_link AS email_link_9 , e0_ . phone_link AS phone_link_10 , e0_ . email_order AS email_order_11 , e0_ . mollie_api_key AS mollie_api_key_12 , e0_ . image AS image_13 , e0_ . is_active AS is_active_14 , e0_ . sort AS sort_15 , e1_ . id AS id_16 , e1_ . title AS title_17 , e1_ . slug AS slug_18 , e1_ . short_title AS short_title_19 , e1_ . sub_title AS sub_title_20 , e1_ . address AS address_21 , e1_ . city AS city_22 , e1_ . country AS country_23 , e1_ . schedule AS schedule_24 , e1_ . additional_information AS additional_information_25 , e1_ . seo_title AS seo_title_26 , e1_ . seo_description AS seo_description_27 , e1_ . seo_image AS seo_image_28 , e1_ . locale AS locale_29 , e1_ . translatable_id AS translatable_id_30 FROM establishment e0_ LEFT JOIN establishment_translation e1_ ON e0_ . id = e1_ . translatable_id AND (e1_ . locale = ? ) ORDER BY e0_ . sort ASC
SELECT e0_ . id AS id_0 , e0_ . post_code AS post_code_1 , e0_ . facebook_link AS facebook_link_2 , e0_ . instagram_link AS instagram_link_3 , e0_ . pinterest_link AS pinterest_link_4 , e0_ . linkedin_link AS linkedin_link_5 , e0_ . tiktok_link AS tiktok_link_6 , e0_ . youtube_link AS youtube_link_7 , e0_ . vimeo_link AS vimeo_link_8 , e0_ . email_link AS email_link_9 , e0_ . phone_link AS phone_link_10 , e0_ . email_order AS email_order_11 , e0_ . mollie_api_key AS mollie_api_key_12 , e0_ . image AS image_13 , e0_ . is_active AS is_active_14 , e0_ . sort AS sort_15 , e1_ . id AS id_16 , e1_ . title AS title_17 , e1_ . slug AS slug_18 , e1_ . short_title AS short_title_19 , e1_ . sub_title AS sub_title_20 , e1_ . address AS address_21 , e1_ . city AS city_22 , e1_ . country AS country_23 , e1_ . schedule AS schedule_24 , e1_ . additional_information AS additional_information_25 , e1_ . seo_title AS seo_title_26 , e1_ . seo_description AS seo_description_27 , e1_ . seo_image AS seo_image_28 , e1_ . locale AS locale_29 , e1_ . translatable_id AS translatable_id_30 FROM establishment e0_ LEFT JOIN establishment_translation e1_ ON e0_ . id = e1_ . translatable_id AND (e1_ . locale = 'en' ) ORDER BY e0_ . sort ASC ;
Copy
2
1.13 ms
SELECT c0_ . id AS id_0 , c0_ . name AS name_1 , c0_ . field AS field_2 , c0_ . controller AS controller_3 , c0_ . action AS action_4 , c0_ . is_sitemap AS is_sitemap_5 , c0_ . is_contain_default_content_generator AS is_contain_default_content_generator_6 , c0_ . sort AS sort_7 , c1_ . id AS id_8 , c1_ . path AS path_9 , c1_ . seo_title AS seo_title_10 , c1_ . seo_description AS seo_description_11 , c1_ . seo_image AS seo_image_12 , c1_ . locale AS locale_13 , c2_ . id AS id_14 , c2_ . is_deletable AS is_deletable_15 , c2_ . sort AS sort_16 , c3_ . id AS id_17 , c3_ . name AS name_18 , c3_ . field AS field_19 , c3_ . type AS type_20 , c4_ . id AS id_21 , c4_ . name AS name_22 , c4_ . field AS field_23 , c4_ . type AS type_24 , c4_ . description AS description_25 , c4_ . options AS options_26 , c4_ . is_translation AS is_translation_27 , c4_ . is_required AS is_required_28 , c4_ . sort AS sort_29 , c5_ . id AS id_30 , c5_ . value AS value_31 , c6_ . id AS id_32 , c6_ . translation AS translation_33 , c6_ . locale AS locale_34 , c7_ . id AS id_35 , c7_ . name AS name_36 , c7_ . field AS field_37 , c7_ . type AS type_38 , c7_ . description AS description_39 , c7_ . options AS options_40 , c7_ . is_translation AS is_translation_41 , c7_ . is_required AS is_required_42 , c7_ . sort AS sort_43 , c1_ . translatable_id AS translatable_id_44 , c2_ . cms_generator_id AS cms_generator_id_45 , c2_ . cms_page_id AS cms_page_id_46 , c4_ . cms_generator_id AS cms_generator_id_47 , c5_ . cms_generator_page_id AS cms_generator_page_id_48 , c5_ . cms_generator_content_id AS cms_generator_content_id_49 , c6_ . translatable_id AS translatable_id_50 , c7_ . cms_generator_id AS cms_generator_id_51 FROM cms_page c0_ LEFT JOIN cms_page_translation c1_ ON c0_ . id = c1_ . translatable_id AND (c1_ . locale = ? ) LEFT JOIN cms_generator_page c2_ ON c0_ . id = c2_ . cms_page_id LEFT JOIN cms_generator c3_ ON c2_ . cms_generator_id = c3_ . id LEFT JOIN cms_generator_content c4_ ON c3_ . id = c4_ . cms_generator_id LEFT JOIN cms_page_content c5_ ON c2_ . id = c5_ . cms_generator_page_id LEFT JOIN cms_page_content_translation c6_ ON c5_ . id = c6_ . translatable_id AND (c6_ . locale = ? ) LEFT JOIN cms_generator_content c7_ ON c5_ . cms_generator_content_id = c7_ . id WHERE c0_ . field = ? ORDER BY c2_ . sort ASC , c4_ . sort ASC
Parameters :
[
"en "
"en "
"business_index "
]
SELECT
c0_ . id AS id_0 ,
c0_ . name AS name_1 ,
c0_ . field AS field_2 ,
c0_ . controller AS controller_3 ,
c0_ . action AS action_4 ,
c0_ . is_sitemap AS is_sitemap_5 ,
c0_ . is_contain_default_content_generator AS is_contain_default_content_generator_6 ,
c0_ . sort AS sort_7 ,
c1_ . id AS id_8 ,
c1_ . path AS path_9 ,
c1_ . seo_title AS seo_title_10 ,
c1_ . seo_description AS seo_description_11 ,
c1_ . seo_image AS seo_image_12 ,
c1_ . locale AS locale_13 ,
c2_ . id AS id_14 ,
c2_ . is_deletable AS is_deletable_15 ,
c2_ . sort AS sort_16 ,
c3_ . id AS id_17 ,
c3_ . name AS name_18 ,
c3_ . field AS field_19 ,
c3_ . type AS type_20 ,
c4_ . id AS id_21 ,
c4_ . name AS name_22 ,
c4_ . field AS field_23 ,
c4_ . type AS type_24 ,
c4_ . description AS description_25 ,
c4_ . options AS options_26 ,
c4_ . is_translation AS is_translation_27 ,
c4_ . is_required AS is_required_28 ,
c4_ . sort AS sort_29 ,
c5_ . id AS id_30 ,
c5_ . value AS value_31 ,
c6_ . id AS id_32 ,
c6_ . translation AS translation_33 ,
c6_ . locale AS locale_34 ,
c7_ . id AS id_35 ,
c7_ . name AS name_36 ,
c7_ . field AS field_37 ,
c7_ . type AS type_38 ,
c7_ . description AS description_39 ,
c7_ . options AS options_40 ,
c7_ . is_translation AS is_translation_41 ,
c7_ . is_required AS is_required_42 ,
c7_ . sort AS sort_43 ,
c1_ . translatable_id AS translatable_id_44 ,
c2_ . cms_generator_id AS cms_generator_id_45 ,
c2_ . cms_page_id AS cms_page_id_46 ,
c4_ . cms_generator_id AS cms_generator_id_47 ,
c5_ . cms_generator_page_id AS cms_generator_page_id_48 ,
c5_ . cms_generator_content_id AS cms_generator_content_id_49 ,
c6_ . translatable_id AS translatable_id_50 ,
c7_ . cms_generator_id AS cms_generator_id_51
FROM
cms_page c0_
LEFT JOIN cms_page_translation c1_ ON c0_ . id = c1_ . translatable_id
AND (c1_ . locale = ? )
LEFT JOIN cms_generator_page c2_ ON c0_ . id = c2_ . cms_page_id
LEFT JOIN cms_generator c3_ ON c2_ . cms_generator_id = c3_ . id
LEFT JOIN cms_generator_content c4_ ON c3_ . id = c4_ . cms_generator_id
LEFT JOIN cms_page_content c5_ ON c2_ . id = c5_ . cms_generator_page_id
LEFT JOIN cms_page_content_translation c6_ ON c5_ . id = c6_ . translatable_id
AND (c6_ . locale = ? )
LEFT JOIN cms_generator_content c7_ ON c5_ . cms_generator_content_id = c7_ . id
WHERE
c0_ . field = ?
ORDER BY
c2_ . sort ASC ,
c4_ . sort ASC
Copy
SELECT c0_ . id AS id_0 , c0_ . name AS name_1 , c0_ . field AS field_2 , c0_ . controller AS controller_3 , c0_ . action AS action_4 , c0_ . is_sitemap AS is_sitemap_5 , c0_ . is_contain_default_content_generator AS is_contain_default_content_generator_6 , c0_ . sort AS sort_7 , c1_ . id AS id_8 , c1_ . path AS path_9 , c1_ . seo_title AS seo_title_10 , c1_ . seo_description AS seo_description_11 , c1_ . seo_image AS seo_image_12 , c1_ . locale AS locale_13 , c2_ . id AS id_14 , c2_ . is_deletable AS is_deletable_15 , c2_ . sort AS sort_16 , c3_ . id AS id_17 , c3_ . name AS name_18 , c3_ . field AS field_19 , c3_ . type AS type_20 , c4_ . id AS id_21 , c4_ . name AS name_22 , c4_ . field AS field_23 , c4_ . type AS type_24 , c4_ . description AS description_25 , c4_ . options AS options_26 , c4_ . is_translation AS is_translation_27 , c4_ . is_required AS is_required_28 , c4_ . sort AS sort_29 , c5_ . id AS id_30 , c5_ . value AS value_31 , c6_ . id AS id_32 , c6_ . translation AS translation_33 , c6_ . locale AS locale_34 , c7_ . id AS id_35 , c7_ . name AS name_36 , c7_ . field AS field_37 , c7_ . type AS type_38 , c7_ . description AS description_39 , c7_ . options AS options_40 , c7_ . is_translation AS is_translation_41 , c7_ . is_required AS is_required_42 , c7_ . sort AS sort_43 , c1_ . translatable_id AS translatable_id_44 , c2_ . cms_generator_id AS cms_generator_id_45 , c2_ . cms_page_id AS cms_page_id_46 , c4_ . cms_generator_id AS cms_generator_id_47 , c5_ . cms_generator_page_id AS cms_generator_page_id_48 , c5_ . cms_generator_content_id AS cms_generator_content_id_49 , c6_ . translatable_id AS translatable_id_50 , c7_ . cms_generator_id AS cms_generator_id_51 FROM cms_page c0_ LEFT JOIN cms_page_translation c1_ ON c0_ . id = c1_ . translatable_id AND (c1_ . locale = 'en' ) LEFT JOIN cms_generator_page c2_ ON c0_ . id = c2_ . cms_page_id LEFT JOIN cms_generator c3_ ON c2_ . cms_generator_id = c3_ . id LEFT JOIN cms_generator_content c4_ ON c3_ . id = c4_ . cms_generator_id LEFT JOIN cms_page_content c5_ ON c2_ . id = c5_ . cms_generator_page_id LEFT JOIN cms_page_content_translation c6_ ON c5_ . id = c6_ . translatable_id AND (c6_ . locale = 'en' ) LEFT JOIN cms_generator_content c7_ ON c5_ . cms_generator_content_id = c7_ . id WHERE c0_ . field = 'business_index' ORDER BY c2_ . sort ASC , c4_ . sort ASC ;
Copy
3
0.32 ms
SELECT t0 . id AS id_1 , t0 . is_deletable AS is_deletable_2 , t0 . sort AS sort_3 , t0 . cms_generator_id AS cms_generator_id_4 , t5 . id AS id_6 , t5 . name AS name_7 , t5 . field AS field_8 , t5 . type AS type_9 , t0 . cms_page_id AS cms_page_id_10 , t11 . id AS id_12 , t11 . name AS name_13 , t11 . field AS field_14 , t11 . controller AS controller_15 , t11 . action AS action_16 , t11 . is_sitemap AS is_sitemap_17 , t11 . is_contain_default_content_generator AS is_contain_default_content_generator_18 , t11 . sort AS sort_19 FROM cms_generator_page t0 INNER JOIN cms_generator t5 ON t0 . cms_generator_id = t5 . id INNER JOIN cms_page t11 ON t0 . cms_page_id = t11 . id WHERE t0 . cms_generator_id IN (? , ? , ? , ? , ? ) ORDER BY t0 . sort ASC
Parameters :
[
20
9
19
21
17
]
SELECT t0 . id AS id_1 , t0 . is_deletable AS is_deletable_2 , t0 . sort AS sort_3 , t0 . cms_generator_id AS cms_generator_id_4 , t5 . id AS id_6 , t5 . name AS name_7 , t5 . field AS field_8 , t5 . type AS type_9 , t0 . cms_page_id AS cms_page_id_10 , t11 . id AS id_12 , t11 . name AS name_13 , t11 . field AS field_14 , t11 . controller AS controller_15 , t11 . action AS action_16 , t11 . is_sitemap AS is_sitemap_17 , t11 . is_contain_default_content_generator AS is_contain_default_content_generator_18 , t11 . sort AS sort_19 FROM cms_generator_page t0 INNER JOIN cms_generator t5 ON t0 . cms_generator_id = t5 . id INNER JOIN cms_page t11 ON t0 . cms_page_id = t11 . id WHERE t0 . cms_generator_id IN (20 , 9 , 19 , 21 , 17 ) ORDER BY t0 . sort ASC ;
Copy
4
0.20 ms
SELECT t0 . id AS id_1 , t0 . value AS value_2 , t0 . cms_generator_page_id AS cms_generator_page_id_3 , t0 . cms_generator_content_id AS cms_generator_content_id_4 FROM cms_page_content t0 WHERE t0 . cms_generator_page_id IN (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? )
Parameters :
[
33
44
43
42
41
40
39
31
38
34
64
65
58
59
15
52
54
17
]
SELECT t0 . id AS id_1 , t0 . value AS value_2 , t0 . cms_generator_page_id AS cms_generator_page_id_3 , t0 . cms_generator_content_id AS cms_generator_content_id_4 FROM cms_page_content t0 WHERE t0 . cms_generator_page_id IN (33 , 44 , 43 , 42 , 41 , 40 , 39 , 31 , 38 , 34 , 64 , 65 , 58 , 59 , 15 , 52 , 54 , 17 );
Copy
5
0.23 ms
SELECT t0 . id AS id_1 , t0 . is_deletable AS is_deletable_2 , t0 . sort AS sort_3 , t0 . cms_generator_id AS cms_generator_id_4 , t5 . id AS id_6 , t5 . name AS name_7 , t5 . field AS field_8 , t5 . type AS type_9 , t0 . cms_page_id AS cms_page_id_10 , t11 . id AS id_12 , t11 . name AS name_13 , t11 . field AS field_14 , t11 . controller AS controller_15 , t11 . action AS action_16 , t11 . is_sitemap AS is_sitemap_17 , t11 . is_contain_default_content_generator AS is_contain_default_content_generator_18 , t11 . sort AS sort_19 FROM cms_generator_page t0 INNER JOIN cms_generator t5 ON t0 . cms_generator_id = t5 . id INNER JOIN cms_page t11 ON t0 . cms_page_id = t11 . id WHERE t0 . cms_page_id IN (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ) ORDER BY t0 . sort ASC
Parameters :
[
10
17
16
15
14
13
12
2
6
7
1
18
19
]
SELECT t0 . id AS id_1 , t0 . is_deletable AS is_deletable_2 , t0 . sort AS sort_3 , t0 . cms_generator_id AS cms_generator_id_4 , t5 . id AS id_6 , t5 . name AS name_7 , t5 . field AS field_8 , t5 . type AS type_9 , t0 . cms_page_id AS cms_page_id_10 , t11 . id AS id_12 , t11 . name AS name_13 , t11 . field AS field_14 , t11 . controller AS controller_15 , t11 . action AS action_16 , t11 . is_sitemap AS is_sitemap_17 , t11 . is_contain_default_content_generator AS is_contain_default_content_generator_18 , t11 . sort AS sort_19 FROM cms_generator_page t0 INNER JOIN cms_generator t5 ON t0 . cms_generator_id = t5 . id INNER JOIN cms_page t11 ON t0 . cms_page_id = t11 . id WHERE t0 . cms_page_id IN (10 , 17 , 16 , 15 , 14 , 13 , 12 , 2 , 6 , 7 , 1 , 18 , 19 ) ORDER BY t0 . sort ASC ;
Copy
6
0.18 ms
SELECT t0 . id AS id_1 , t0 . value AS value_2 , t0 . cms_generator_page_id AS cms_generator_page_id_3 , t0 . cms_generator_content_id AS cms_generator_content_id_4 FROM cms_page_content t0 WHERE t0 . cms_generator_page_id IN (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? )
Parameters :
[
51
1
46
63
56
36
57
48
37
60
13
49
50
14
61
62
16
18
45
19
25
55
53
]
SELECT t0 . id AS id_1 , t0 . value AS value_2 , t0 . cms_generator_page_id AS cms_generator_page_id_3 , t0 . cms_generator_content_id AS cms_generator_content_id_4 FROM cms_page_content t0 WHERE t0 . cms_generator_page_id IN (51 , 1 , 46 , 63 , 56 , 36 , 57 , 48 , 37 , 60 , 13 , 49 , 50 , 14 , 61 , 62 , 16 , 18 , 45 , 19 , 25 , 55 , 53 );
Copy
7
0.16 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . field AS field_3 , t0 . type AS type_4 , t0 . description AS description_5 , t0 . options AS options_6 , t0 . is_translation AS is_translation_7 , t0 . is_required AS is_required_8 , t0 . sort AS sort_9 , t0 . cms_generator_id AS cms_generator_id_10 FROM cms_generator_content t0 WHERE t0 . cms_generator_id IN (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ) ORDER BY t0 . sort ASC
Parameters :
[
25
3
24
2
22
11
23
6
4
7
15
26
]
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . field AS field_3 , t0 . type AS type_4 , t0 . description AS description_5 , t0 . options AS options_6 , t0 . is_translation AS is_translation_7 , t0 . is_required AS is_required_8 , t0 . sort AS sort_9 , t0 . cms_generator_id AS cms_generator_id_10 FROM cms_generator_content t0 WHERE t0 . cms_generator_id IN (25 , 3 , 24 , 2 , 22 , 11 , 23 , 6 , 4 , 7 , 15 , 26 ) ORDER BY t0 . sort ASC ;
Copy
8
0.23 ms
SELECT t0 . id AS id_1 , t0 . is_deletable AS is_deletable_2 , t0 . sort AS sort_3 , t0 . cms_generator_id AS cms_generator_id_4 , t5 . id AS id_6 , t5 . name AS name_7 , t5 . field AS field_8 , t5 . type AS type_9 , t0 . cms_page_id AS cms_page_id_10 , t11 . id AS id_12 , t11 . name AS name_13 , t11 . field AS field_14 , t11 . controller AS controller_15 , t11 . action AS action_16 , t11 . is_sitemap AS is_sitemap_17 , t11 . is_contain_default_content_generator AS is_contain_default_content_generator_18 , t11 . sort AS sort_19 FROM cms_generator_page t0 INNER JOIN cms_generator t5 ON t0 . cms_generator_id = t5 . id INNER JOIN cms_page t11 ON t0 . cms_page_id = t11 . id WHERE t0 . cms_generator_id IN (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ) ORDER BY t0 . sort ASC
Parameters :
[
25
3
24
2
22
11
23
6
4
7
15
26
]
SELECT t0 . id AS id_1 , t0 . is_deletable AS is_deletable_2 , t0 . sort AS sort_3 , t0 . cms_generator_id AS cms_generator_id_4 , t5 . id AS id_6 , t5 . name AS name_7 , t5 . field AS field_8 , t5 . type AS type_9 , t0 . cms_page_id AS cms_page_id_10 , t11 . id AS id_12 , t11 . name AS name_13 , t11 . field AS field_14 , t11 . controller AS controller_15 , t11 . action AS action_16 , t11 . is_sitemap AS is_sitemap_17 , t11 . is_contain_default_content_generator AS is_contain_default_content_generator_18 , t11 . sort AS sort_19 FROM cms_generator_page t0 INNER JOIN cms_generator t5 ON t0 . cms_generator_id = t5 . id INNER JOIN cms_page t11 ON t0 . cms_page_id = t11 . id WHERE t0 . cms_generator_id IN (25 , 3 , 24 , 2 , 22 , 11 , 23 , 6 , 4 , 7 , 15 , 26 ) ORDER BY t0 . sort ASC ;
Copy
9
0.20 ms
SELECT e0_ . id AS id_0 , e0_ . post_code AS post_code_1 , e0_ . facebook_link AS facebook_link_2 , e0_ . instagram_link AS instagram_link_3 , e0_ . pinterest_link AS pinterest_link_4 , e0_ . linkedin_link AS linkedin_link_5 , e0_ . tiktok_link AS tiktok_link_6 , e0_ . youtube_link AS youtube_link_7 , e0_ . vimeo_link AS vimeo_link_8 , e0_ . email_link AS email_link_9 , e0_ . phone_link AS phone_link_10 , e0_ . email_order AS email_order_11 , e0_ . mollie_api_key AS mollie_api_key_12 , e0_ . image AS image_13 , e0_ . is_active AS is_active_14 , e0_ . sort AS sort_15 , e1_ . id AS id_16 , e1_ . title AS title_17 , e1_ . slug AS slug_18 , e1_ . short_title AS short_title_19 , e1_ . sub_title AS sub_title_20 , e1_ . address AS address_21 , e1_ . city AS city_22 , e1_ . country AS country_23 , e1_ . schedule AS schedule_24 , e1_ . additional_information AS additional_information_25 , e1_ . seo_title AS seo_title_26 , e1_ . seo_description AS seo_description_27 , e1_ . seo_image AS seo_image_28 , e1_ . locale AS locale_29 , e1_ . translatable_id AS translatable_id_30 FROM establishment e0_ LEFT JOIN establishment_translation e1_ ON e0_ . id = e1_ . translatable_id AND (e1_ . locale = ? ) WHERE e0_ . is_active = ? ORDER BY e0_ . sort ASC
SELECT e0_ . id AS id_0 , e0_ . post_code AS post_code_1 , e0_ . facebook_link AS facebook_link_2 , e0_ . instagram_link AS instagram_link_3 , e0_ . pinterest_link AS pinterest_link_4 , e0_ . linkedin_link AS linkedin_link_5 , e0_ . tiktok_link AS tiktok_link_6 , e0_ . youtube_link AS youtube_link_7 , e0_ . vimeo_link AS vimeo_link_8 , e0_ . email_link AS email_link_9 , e0_ . phone_link AS phone_link_10 , e0_ . email_order AS email_order_11 , e0_ . mollie_api_key AS mollie_api_key_12 , e0_ . image AS image_13 , e0_ . is_active AS is_active_14 , e0_ . sort AS sort_15 , e1_ . id AS id_16 , e1_ . title AS title_17 , e1_ . slug AS slug_18 , e1_ . short_title AS short_title_19 , e1_ . sub_title AS sub_title_20 , e1_ . address AS address_21 , e1_ . city AS city_22 , e1_ . country AS country_23 , e1_ . schedule AS schedule_24 , e1_ . additional_information AS additional_information_25 , e1_ . seo_title AS seo_title_26 , e1_ . seo_description AS seo_description_27 , e1_ . seo_image AS seo_image_28 , e1_ . locale AS locale_29 , e1_ . translatable_id AS translatable_id_30 FROM establishment e0_ LEFT JOIN establishment_translation e1_ ON e0_ . id = e1_ . translatable_id AND (e1_ . locale = 'en' ) WHERE e0_ . is_active = 1 ORDER BY e0_ . sort ASC ;
Copy