SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-24' at line 22: SELECT "base_table"."vid" AS "vid", "base_table"."nid" AS "nid", min(taxonomy_term_field_data.name) AS "expression", min(taxonomy_term_field_data_2.name) AS "expression_2", min(node_field_data_2.title) AS "expression_3", min(node_field_data_3.title) AS "expression_4"
FROM
"drupal_node" "base_table"
INNER JOIN "drupal_node_field_data" "node_field_data" ON "node_field_data"."nid" = "base_table"."nid"
INNER JOIN "drupal_node__field_country_reference" "node__field_country_reference" ON "node__field_country_reference"."entity_id" = "base_table"."nid"
INNER JOIN "drupal_node__field_region_reference" "node__field_region_reference" ON "node__field_region_reference"."entity_id" = "base_table"."nid"
INNER JOIN "drupal_node__field_supplier_reference" "node__field_supplier_reference" ON "node__field_supplier_reference"."entity_id" = "base_table"."nid"
INNER JOIN "drupal_node__field_is_new" "node__field_is_new" ON "node__field_is_new"."entity_id" = "base_table"."nid"
LEFT JOIN "drupal_node__field_country_reference" "node__field_country_reference_2" ON "node__field_country_reference_2"."entity_id" = "base_table"."nid"
LEFT OUTER JOIN "drupal_taxonomy_term_data" "taxonomy_term_data" ON "taxonomy_term_data"."tid" = "node__field_country_reference_2"."field_country_reference_target_id"
LEFT JOIN "drupal_taxonomy_term_field_data" "taxonomy_term_field_data" ON "taxonomy_term_field_data"."tid" = "taxonomy_term_data"."tid"
LEFT JOIN "drupal_node__field_region_reference" "node__field_region_reference_2" ON "node__field_region_reference_2"."entity_id" = "base_table"."nid"
LEFT OUTER JOIN "drupal_taxonomy_term_data" "taxonomy_term_data_2" ON "taxonomy_term_data_2"."tid" = "node__field_region_reference_2"."field_region_reference_target_id"
LEFT JOIN "drupal_taxonomy_term_field_data" "taxonomy_term_field_data_2" ON "taxonomy_term_field_data_2"."tid" = "taxonomy_term_data_2"."tid"
LEFT JOIN "drupal_node__field_supplier_reference" "node__field_supplier_reference_2" ON "node__field_supplier_reference_2"."entity_id" = "base_table"."nid"
LEFT OUTER JOIN "drupal_node" "node" ON "node"."nid" = "node__field_supplier_reference_2"."field_supplier_reference_target_id"
LEFT JOIN "drupal_node_field_data" "node_field_data_2" ON "node_field_data_2"."nid" = "node"."nid"
LEFT JOIN "drupal_node_field_data" "node_field_data_3" ON "node_field_data_3"."nid" = "base_table"."nid"
WHERE ("node_field_data"."type" = :db_condition_placeholder_0) AND ("node_field_data"."status" = :db_condition_placeholder_1) AND ("node__field_country_reference"."field_country_reference_target_id" IS NOT NULL) AND ("node__field_region_reference"."field_region_reference_target_id" IS NOT NULL) AND ("node__field_supplier_reference"."field_supplier_reference_target_id" IS NOT NULL) AND ("node__field_is_new"."field_is_new_value" = :db_condition_placeholder_2)
GROUP BY "base_table"."vid", "base_table"."nid"
ORDER BY "expression" ASC, "expression_2" ASC, "expression_3" ASC, "expression_4" ASC
LIMIT 24 OFFSET -24; Array
(
[:db_condition_placeholder_0] => product
[:db_condition_placeholder_1] => 1
[:db_condition_placeholder_2] => 1
)