[
"sql" => "SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.slug AS slug_2, a0_.resume AS resume_3, a0_.conclusion AS conclusion_4, a0_.pmid AS pmid_5, a0_.url AS url_6, a0_.doi AS doi_7, a0_.publication_date AS publication_date_8, a0_.authors AS authors_9, a0_.journal AS journal_10, a0_.volume AS volume_11, a0_.issue AS issue_12, a0_.pages AS pages_13, a0_.hypotheses AS hypotheses_14, a0_.population AS population_15, a0_.variables AS variables_16, a0_.protocol AS protocol_17, a0_.measurement_tools AS measurement_tools_18, a0_.statistical_analyses AS statistical_analyses_19, a0_.statistical_results AS statistical_results_20, a0_.conclusions AS conclusions_21, a0_.limitations AS limitations_22, a0_.personal_interest AS personal_interest_23, a0_.other_comments AS other_comments_24, a0_.created_at AS created_at_25, a0_.updated_at AS updated_at_26, a1_.id AS id_27, a1_.is_read AS is_read_28, a1_.is_favorite AS is_favorite_29, a1_.in_progress AS in_progress_30, a1_.linked_at AS linked_at_31, a1_.unlinked_at AS unlinked_at_32 FROM article a0_ INNER JOIN article_project a1_ ON a0_.id = a1_.article_id AND (a1_.project_id = ?) WHERE a1_.unlinked_at IS NULL AND a1_.is_favorite = 1 ORDER BY a0_.publication_date DESC) dctrn_result) dctrn_table"
"params" => [
1 => 4
]
"types" => [
1 => Doctrine\DBAL\ParameterType {#743
+name: "INTEGER"
}
]
]