SELECT node__field_work_sort_order.field_work_sort_order_value AS node__field_work_sort_order_field_work_sort_order_value, node_field_data.nid AS nid
FROM
{node_field_data} node_field_data
LEFT JOIN {node__field_work_sort_order} node__field_work_sort_order ON node_field_data.nid = node__field_work_sort_order.entity_id AND (node__field_work_sort_order.deleted = '0' AND node__field_work_sort_order.langcode = node_field_data.langcode)
WHERE (( (node_field_data.status = '1') AND (node_field_data.type IN  ('', '', '', 'work')) AND (node_field_data.langcode IN  ('en')) ))
ORDER BY node__field_work_sort_order_field_work_sort_order_value ASC
LIMIT 11 OFFSET 0