SELECT vov_taxonomy_index.weight AS vov_taxonomy_index_weight, node_field_data.published_date AS node_field_data_published_date, node_field_data.nid AS nid, node_field_data.langcode AS node_field_data_langcode
FROM
{node_field_data} node_field_data
LEFT JOIN {node__field_publish_categories} node__field_publish_categories ON node_field_data.nid = node__field_publish_categories.entity_id AND node__field_publish_categories.deleted = :views_join_condition_0 AND (node__field_publish_categories.langcode = node_field_data.langcode OR node__field_publish_categories.bundle = :views_join_condition_2)
LEFT JOIN {vov_taxonomy_index} vov_taxonomy_index ON node_field_data.nid = vov_taxonomy_index.nid
WHERE (((node__field_publish_categories.field_publish_categories_target_id = :node__field_publish_categories_field_publish_categories_target_id)) AND ((node_field_data.nid != :node_field_data_nid OR node_field_data.nid IS NULL))) AND ((node_field_data.langcode IN (:db_condition_placeholder_3)) AND (node_field_data.type IN (:db_condition_placeholder_4)) AND (node_field_data.status = :db_condition_placeholder_5))
ORDER BY vov_taxonomy_index_weight DESC NULLS LAST, node_field_data_published_date DESC NULLS LAST
