Produits

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 )