Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.development_timeline AS development_timeline_2,
  t0.production_timeline AS production_timeline_3,
  t0.post_production_timeline AS post_production_timeline_4,
  t0.completion_timeline AS completion_timeline_5,
  t0.fundraising_campaign_start_date AS fundraising_campaign_start_date_6,
  t0.fundraising_campaign_end_date AS fundraising_campaign_end_date_7,
  t0.impact_campaign_start_date AS impact_campaign_start_date_8,
  t0.impact_campaign_end_date AS impact_campaign_end_date_9,
  t0.film_project_id AS film_project_id_10
FROM
  film_project_timeline t0
WHERE
  t0.film_project_id = ?

SELECT t0.id AS id_1, t0.development_timeline AS development_timeline_2, t0.production_timeline AS production_timeline_3, t0.post_production_timeline AS post_production_timeline_4, t0.completion_timeline AS completion_timeline_5, t0.fundraising_campaign_start_date AS fundraising_campaign_start_date_6, t0.fundraising_campaign_end_date AS fundraising_campaign_end_date_7, t0.impact_campaign_start_date AS impact_campaign_start_date_8, t0.impact_campaign_end_date AS impact_campaign_end_date_9, t0.film_project_id AS film_project_id_10 FROM film_project_timeline t0 WHERE t0.film_project_id = 45;

SELECT
  t0.id AS id_1,
  t0.development_budget AS development_budget_2,
  t0.production_budget AS production_budget_3,
  t0.post_production_budget AS post_production_budget_4,
  t0.outreach AS outreach_5,
  t0.screen_agencies AS screen_agencies_6,
  t0.government AS government_7,
  t0.corporate AS corporate_8,
  t0.philantrophy AS philantrophy_9,
  t0.crownfunding AS crownfunding_10,
  t0.other_budget AS other_budget_11,
  t0.total_budget AS total_budget_12,
  t0.funder_list AS funder_list_13,
  t0.is_confirmed_support_public AS is_confirmed_support_public_14,
  t0.fundraising_strategy AS fundraising_strategy_15,
  t0.fundraising_goal AS fundraising_goal_16,
  t0.campaign_end_method AS campaign_end_method_17,
  t0.heard_from AS heard_from_18,
  t0.approved_fiscal AS approved_fiscal_19,
  t0.fiscal_sponsorship_project AS fiscal_sponsorship_project_20,
  t0.is_previously_submitted AS is_previously_submitted_21,
  t0.previously_submitted_year AS previously_submitted_year_22,
  t0.film_project_id AS film_project_id_23
FROM
  film_project_funding t0
WHERE
  t0.film_project_id = ?

SELECT t0.id AS id_1, t0.development_budget AS development_budget_2, t0.production_budget AS production_budget_3, t0.post_production_budget AS post_production_budget_4, t0.outreach AS outreach_5, t0.screen_agencies AS screen_agencies_6, t0.government AS government_7, t0.corporate AS corporate_8, t0.philantrophy AS philantrophy_9, t0.crownfunding AS crownfunding_10, t0.other_budget AS other_budget_11, t0.total_budget AS total_budget_12, t0.funder_list AS funder_list_13, t0.is_confirmed_support_public AS is_confirmed_support_public_14, t0.fundraising_strategy AS fundraising_strategy_15, t0.fundraising_goal AS fundraising_goal_16, t0.campaign_end_method AS campaign_end_method_17, t0.heard_from AS heard_from_18, t0.approved_fiscal AS approved_fiscal_19, t0.fiscal_sponsorship_project AS fiscal_sponsorship_project_20, t0.is_previously_submitted AS is_previously_submitted_21, t0.previously_submitted_year AS previously_submitted_year_22, t0.film_project_id AS film_project_id_23 FROM film_project_funding t0 WHERE t0.film_project_id = 45;

SELECT
  t0.id AS id_1,
  t0.synopsis AS synopsis_2,
  t0.logline AS logline_3,
  t0.issue_addressed AS issue_addressed_4,
  t0.creative_treatment AS creative_treatment_5,
  t0.primary_impact_area AS primary_impact_area_6,
  t0.secondary_impact_area AS secondary_impact_area_7,
  t0.topic_covered AS topic_covered_8,
  t0.impact_vision_statement AS impact_vision_statement_9,
  t0.outcomes AS outcomes_10,
  t0.ourcome_information AS ourcome_information_11,
  t0.audiences AS audiences_12,
  t0.relationship_access AS relationship_access_13,
  t0.who_benefit AS who_benefit_14,
  t0.confirmed_role AS confirmed_role_15,
  t0.confirmed_role_name AS confirmed_role_name_16,
  t0.call_to_action AS call_to_action_17,
  t0.is_film_impact_partner AS is_film_impact_partner_18,
  t0.partner_name AS partner_name_19,
  t0.film_project_id AS film_project_id_20
FROM
  film_project_story_impact t0
WHERE
  t0.film_project_id = ?

SELECT t0.id AS id_1, t0.synopsis AS synopsis_2, t0.logline AS logline_3, t0.issue_addressed AS issue_addressed_4, t0.creative_treatment AS creative_treatment_5, t0.primary_impact_area AS primary_impact_area_6, t0.secondary_impact_area AS secondary_impact_area_7, t0.topic_covered AS topic_covered_8, t0.impact_vision_statement AS impact_vision_statement_9, t0.outcomes AS outcomes_10, t0.ourcome_information AS ourcome_information_11, t0.audiences AS audiences_12, t0.relationship_access AS relationship_access_13, t0.who_benefit AS who_benefit_14, t0.confirmed_role AS confirmed_role_15, t0.confirmed_role_name AS confirmed_role_name_16, t0.call_to_action AS call_to_action_17, t0.is_film_impact_partner AS is_film_impact_partner_18, t0.partner_name AS partner_name_19, t0.film_project_id AS film_project_id_20 FROM film_project_story_impact t0 WHERE t0.film_project_id = 45;

SELECT
  t0.id AS id_1,
  t0.is_episodes AS is_episodes_2,
  t0.episode_number AS episode_number_3,
  t0.is_short_film AS is_short_film_4,
  t0.short_film_length AS short_film_length_5,
  t0.production_length AS production_length_6,
  t0.project_hero_image AS project_hero_image_7,
  t0.project_trailer_link AS project_trailer_link_8,
  t0.project_trailer_password AS project_trailer_password_9,
  t0.is_completed AS is_completed_10,
  t0.project_complete_link AS project_complete_link_11,
  t0.screener_password AS screener_password_12,
  t0.twitter AS twitter_13,
  t0.instagram AS instagram_14,
  t0.facebook AS facebook_15,
  t0.youtube AS youtube_16,
  t0.vimeo AS vimeo_17,
  t0.website AS website_18,
  t0.is_display_donation AS is_display_donation_19,
  t0.film_project_id AS film_project_id_20
FROM
  film_project_details t0
WHERE
  t0.film_project_id = ?

SELECT t0.id AS id_1, t0.is_episodes AS is_episodes_2, t0.episode_number AS episode_number_3, t0.is_short_film AS is_short_film_4, t0.short_film_length AS short_film_length_5, t0.production_length AS production_length_6, t0.project_hero_image AS project_hero_image_7, t0.project_trailer_link AS project_trailer_link_8, t0.project_trailer_password AS project_trailer_password_9, t0.is_completed AS is_completed_10, t0.project_complete_link AS project_complete_link_11, t0.screener_password AS screener_password_12, t0.twitter AS twitter_13, t0.instagram AS instagram_14, t0.facebook AS facebook_15, t0.youtube AS youtube_16, t0.vimeo AS vimeo_17, t0.website AS website_18, t0.is_display_donation AS is_display_donation_19, t0.film_project_id AS film_project_id_20 FROM film_project_details t0 WHERE t0.film_project_id = 45;

"COMMIT"

"COMMIT";

SELECT
  t0.id AS id_1,
  t0.data AS data_2,
  t0.film_project_id AS film_project_id_3
FROM
  film_project_original t0
WHERE
  t0.film_project_id = ?

SELECT t0.id AS id_1, t0.data AS data_2, t0.film_project_id AS film_project_id_3 FROM film_project_original t0 WHERE t0.film_project_id = 45;

SELECT
  f0_.id AS id_0,
  f0_.is_uptodate AS is_uptodate_1,
  f0_.project_update AS project_update_2,
  f0_.is_still_fundraising AS is_still_fundraising_3,
  f0_.project_active_status AS project_active_status_4,
  f0_.complete_film_year AS complete_film_year_5,
  f0_.is_complete_film_release AS is_complete_film_release_6,
  f0_.complete_film_where_available AS complete_film_where_available_7,
  f0_.complete_film_type AS complete_film_type_8,
  f0_.complete_film_progress_details AS complete_film_progress_details_9,
  f0_.reach_response_details AS reach_response_details_10,
  f0_.reach_response_use AS reach_response_use_11,
  f0_.outcome_change AS outcome_change_12,
  f0_.is_outcome_measured_impact AS is_outcome_measured_impact_13,
  f0_.outcome_measured_impact_details AS outcome_measured_impact_details_14,
  f0_.outcome_contribute_extent AS outcome_contribute_extent_15,
  f0_.feedback_engagement AS feedback_engagement_16,
  f0_.feedback_engagement_details AS feedback_engagement_details_17,
  f0_.feedback_experience_agreement AS feedback_experience_agreement_18,
  f0_.feedback_doing_well AS feedback_doing_well_19,
  f0_.feedback_improvement AS feedback_improvement_20,
  f0_.feedback_involvement AS feedback_involvement_21,
  f0_.feedback_improvement_details AS feedback_improvement_details_22,
  f0_.created_at AS created_at_23,
  f0_.modified_at AS modified_at_24,
  f0_.feedback_benefit_agreement AS feedback_benefit_agreement_25,
  f0_.feedback_recommend_agreement AS feedback_recommend_agreement_26,
  f0_.feedback_critical_role_agreement AS feedback_critical_role_agreement_27,
  f0_.reach_response_use_details AS reach_response_use_details_28,
  f0_.feedback_comment AS feedback_comment_29,
  f0_.complete_film_type_details AS complete_film_type_details_30,
  f0_.outcome_awareness_extent AS outcome_awareness_extent_31,
  f0_.outcome_visibility_extent AS outcome_visibility_extent_32,
  f0_.outcome_connection_extent AS outcome_connection_extent_33,
  f0_.outcome_action_extent AS outcome_action_extent_34,
  f0_.outcome_organisation_extent AS outcome_organisation_extent_35,
  f0_.outcome_community_extent AS outcome_community_extent_36,
  f0_.outcome_system_extent AS outcome_system_extent_37,
  f0_.status AS status_38,
  f0_.project_update_category AS project_update_category_39,
  f0_.is_file_public AS is_file_public_40,
  f0_.project_update_tags AS project_update_tags_41,
  f0_.current_stage AS current_stage_42,
  f0_.screener_link AS screener_link_43,
  f0_.screen_password AS screen_password_44,
  f0_.trailer_link AS trailer_link_45,
  f0_.trailer_password AS trailer_password_46,
  f0_.digital_assets_link AS digital_assets_link_47,
  f0_.general_support_area AS general_support_area_48,
  f0_.general_support_area_details AS general_support_area_details_49,
  f0_.fundraising_status AS fundraising_status_50,
  f0_.outcome_additional_information AS outcome_additional_information_51,
  f0_.is_draft AS is_draft_52,
  f0_.film_website_url AS film_website_url_53,
  f0_.is_document AS is_document_54,
  f0_.online_document_link AS online_document_link_55,
  f0_.is_active AS is_active_56,
  f0_.film_project_id AS film_project_id_57,
  f0_.film_project_update_id AS film_project_update_id_58
FROM
  film_project_progress_report f0_
  LEFT JOIN film_project f1_ ON f0_.film_project_id = f1_.id
WHERE
  f0_.created_at >= ?
  AND f0_.created_at <= ?
  AND f1_.id = ?

SELECT f0_.id AS id_0, f0_.is_uptodate AS is_uptodate_1, f0_.project_update AS project_update_2, f0_.is_still_fundraising AS is_still_fundraising_3, f0_.project_active_status AS project_active_status_4, f0_.complete_film_year AS complete_film_year_5, f0_.is_complete_film_release AS is_complete_film_release_6, f0_.complete_film_where_available AS complete_film_where_available_7, f0_.complete_film_type AS complete_film_type_8, f0_.complete_film_progress_details AS complete_film_progress_details_9, f0_.reach_response_details AS reach_response_details_10, f0_.reach_response_use AS reach_response_use_11, f0_.outcome_change AS outcome_change_12, f0_.is_outcome_measured_impact AS is_outcome_measured_impact_13, f0_.outcome_measured_impact_details AS outcome_measured_impact_details_14, f0_.outcome_contribute_extent AS outcome_contribute_extent_15, f0_.feedback_engagement AS feedback_engagement_16, f0_.feedback_engagement_details AS feedback_engagement_details_17, f0_.feedback_experience_agreement AS feedback_experience_agreement_18, f0_.feedback_doing_well AS feedback_doing_well_19, f0_.feedback_improvement AS feedback_improvement_20, f0_.feedback_involvement AS feedback_involvement_21, f0_.feedback_improvement_details AS feedback_improvement_details_22, f0_.created_at AS created_at_23, f0_.modified_at AS modified_at_24, f0_.feedback_benefit_agreement AS feedback_benefit_agreement_25, f0_.feedback_recommend_agreement AS feedback_recommend_agreement_26, f0_.feedback_critical_role_agreement AS feedback_critical_role_agreement_27, f0_.reach_response_use_details AS reach_response_use_details_28, f0_.feedback_comment AS feedback_comment_29, f0_.complete_film_type_details AS complete_film_type_details_30, f0_.outcome_awareness_extent AS outcome_awareness_extent_31, f0_.outcome_visibility_extent AS outcome_visibility_extent_32, f0_.outcome_connection_extent AS outcome_connection_extent_33, f0_.outcome_action_extent AS outcome_action_extent_34, f0_.outcome_organisation_extent AS outcome_organisation_extent_35, f0_.outcome_community_extent AS outcome_community_extent_36, f0_.outcome_system_extent AS outcome_system_extent_37, f0_.status AS status_38, f0_.project_update_category AS project_update_category_39, f0_.is_file_public AS is_file_public_40, f0_.project_update_tags AS project_update_tags_41, f0_.current_stage AS current_stage_42, f0_.screener_link AS screener_link_43, f0_.screen_password AS screen_password_44, f0_.trailer_link AS trailer_link_45, f0_.trailer_password AS trailer_password_46, f0_.digital_assets_link AS digital_assets_link_47, f0_.general_support_area AS general_support_area_48, f0_.general_support_area_details AS general_support_area_details_49, f0_.fundraising_status AS fundraising_status_50, f0_.outcome_additional_information AS outcome_additional_information_51, f0_.is_draft AS is_draft_52, f0_.film_website_url AS film_website_url_53, f0_.is_document AS is_document_54, f0_.online_document_link AS online_document_link_55, f0_.is_active AS is_active_56, f0_.film_project_id AS film_project_id_57, f0_.film_project_update_id AS film_project_update_id_58 FROM film_project_progress_report f0_ LEFT JOIN film_project f1_ ON f0_.film_project_id = f1_.id WHERE f0_.created_at >= '2025-01-01 00:00:00' AND f0_.created_at <= '2025-12-31 23:59:59' AND f1_.id = 27;

UPDATE
  film_project_progress_report
SET
  is_active = ?
WHERE
  id = ?

UPDATE film_project_progress_report SET is_active = 1 WHERE id = 59;

UPDATE
  film_project
SET
  is_progress_report_active = ?
WHERE
  id = ?

UPDATE film_project SET is_progress_report_active = 1 WHERE id = 29;

SELECT
  t0.id AS id_1,
  t0.access_token AS access_token_2,
  t0.expires AS expires_3,
  t0.tenant_id AS tenant_id_4,
  t0.refresh_token AS refresh_token_5,
  t0.id_token AS id_token_6,
  t0.tag AS tag_7
FROM
  xero_storage t0
WHERE
  t0.tag = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.access_token AS access_token_2, t0.expires AS expires_3, t0.tenant_id AS tenant_id_4, t0.refresh_token AS refresh_token_5, t0.id_token AS id_token_6, t0.tag AS tag_7 FROM xero_storage t0 WHERE t0.tag = 'primary' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.option_name AS option_name_2,
  t0.option_value AS option_value_3
FROM
  setting t0
WHERE
  t0.option_name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.option_name AS option_name_2, t0.option_value AS option_value_3 FROM setting t0 WHERE t0.option_name = 'is_progress_report' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.first_name AS first_name_5,
  t0.last_name AS last_name_6,
  t0.phone AS phone_7,
  t0.gender AS gender_8,
  t0.is_diverse AS is_diverse_9,
  t0.organisation AS organisation_10,
  t0.area_interest AS area_interest_11,
  t0.account_salesforce_id AS account_salesforce_id_12,
  t0.is_aborigin AS is_aborigin_13,
  t0.is_success AS is_success_14,
  t0.is_guest AS is_guest_15,
  t16.id AS id_17,
  t16.description AS description_18,
  t16.short_description AS short_description_19,
  t16.long_description AS long_description_20,
  t16.profile_picture AS profile_picture_21,
  t16.user_roles AS user_roles_22,
  t16.reason_support_documentary AS reason_support_documentary_23,
  t16.user_id AS user_id_24,
  t25.id AS id_26,
  t25.street AS street_27,
  t25.city AS city_28,
  t25.state AS state_29,
  t25.postcode AS postcode_30,
  t25.country AS country_31,
  t25.user_id AS user_id_32,
  t33.id AS id_34,
  t33.website AS website_35,
  t33.facebook AS facebook_36,
  t33.twitter AS twitter_37,
  t33.xero_id AS xero_id_38,
  t33.salesforce_id AS salesforce_id_39,
  t33.wordpress_id AS wordpress_id_40,
  t33.user_id AS user_id_41
FROM
  user t0
  LEFT JOIN user_profile t16 ON t16.user_id = t0.id
  LEFT JOIN user_address t25 ON t25.user_id = t0.id
  LEFT JOIN user_information t33 ON t33.user_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.phone AS phone_7, t0.gender AS gender_8, t0.is_diverse AS is_diverse_9, t0.organisation AS organisation_10, t0.area_interest AS area_interest_11, t0.account_salesforce_id AS account_salesforce_id_12, t0.is_aborigin AS is_aborigin_13, t0.is_success AS is_success_14, t0.is_guest AS is_guest_15, t16.id AS id_17, t16.description AS description_18, t16.short_description AS short_description_19, t16.long_description AS long_description_20, t16.profile_picture AS profile_picture_21, t16.user_roles AS user_roles_22, t16.reason_support_documentary AS reason_support_documentary_23, t16.user_id AS user_id_24, t25.id AS id_26, t25.street AS street_27, t25.city AS city_28, t25.state AS state_29, t25.postcode AS postcode_30, t25.country AS country_31, t25.user_id AS user_id_32, t33.id AS id_34, t33.website AS website_35, t33.facebook AS facebook_36, t33.twitter AS twitter_37, t33.xero_id AS xero_id_38, t33.salesforce_id AS salesforce_id_39, t33.wordpress_id AS wordpress_id_40, t33.user_id AS user_id_41 FROM user t0 LEFT JOIN user_profile t16 ON t16.user_id = t0.id LEFT JOIN user_address t25 ON t25.user_id = t0.id LEFT JOIN user_information t33 ON t33.user_id = t0.id WHERE t0.id = 1;

UPDATE
  setting
SET
  option_value = ?
WHERE
  id = ?

UPDATE setting SET option_value = '1' WHERE id = 8;

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  xero_storage
SET
  access_token = ?,
  expires = ?,
  refresh_token = ?,
  id_token = ?
WHERE
  id = ?

UPDATE xero_storage SET access_token = 'eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3NTg1Mjc5NzIsImV4cCI6MTc1ODUyOTc3MiwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6Imh0dHBzOi8vaWRlbnRpdHkueGVyby5jb20vcmVzb3VyY2VzIiwiY2xpZW50X2lkIjoiOTQ5NjRGMDI5MDkxNDI0NUI1OTdDNkFDNEQ0MTU4MDIiLCJzdWIiOiIyYjZhN2M2YjJlZTE1M2Y1YTA0ODdkMGNmOGJjM2VlOSIsImF1dGhfdGltZSI6MTY5MTk5MjU5NywieGVyb191c2VyaWQiOiJhYjg4ZTU1My0yNDZlLTQ4ZDMtOTJkYy0wYTFmNmVmMzkxY2UiLCJnbG9iYWxfc2Vzc2lvbl9pZCI6IjY3NjYxMWEwZDM5MDRhZGVhMmIzMmVmNTA0ODU4YWExIiwic2lkIjoiNjc2NjExYTBkMzkwNGFkZWEyYjMyZWY1MDQ4NThhYTEiLCJqdGkiOiIwMzA2RDFBMkQ4QUY3Qzc3OThGNEI1REQxRjlCOTZBOCIsImF1dGhlbnRpY2F0aW9uX2V2ZW50X2lkIjoiYzk3YTI4ZTktNDU4YS00MzZjLWJkZTMtZDZjZWExNWI0ZDJmIiwic2NvcGUiOlsiZW1haWwiLCJwcm9maWxlIiwib3BlbmlkIiwiYWNjb3VudGluZy5yZXBvcnRzLnJlYWQiLCJhY2NvdW50aW5nLnNldHRpbmdzIiwiYWNjb3VudGluZy5hdHRhY2htZW50cyIsImFjY291bnRpbmcudHJhbnNhY3Rpb25zIiwiYWNjb3VudGluZy5qb3VybmFscy5yZWFkIiwiYWNjb3VudGluZy5jb250YWN0cyIsIm9mZmxpbmVfYWNjZXNzIl0sImFtciI6WyJwd2QiXX0.UjclqktNAjSvIoDW0_1wvaSd5GyfB1KxFmz3V3aSK84ilnOvI8OeyJk9cXUfH90RGJu-QWDJnUsJh3-45LXBZFN1I1t20sRivALc2K1DJxak-HJXxunXKBypFJ6rQxyQfBw2oR45DmIBXXfB9YTIjNDBaduGjiXIMsW7r05RYtgo3Dcf9ga_AB2e1HDWliVDbaMXBcdUmXyH9wa0PCj09JmgdLodPFEK4h7UNc7-qVTqqTGYRkM7kMBmU_H2mWqlwDRLyJaz-gKwY3j231pyQBUuymMwq5qbg5LRSAzkhoecsy9wAXsDAutx4AosJHRAgQTf6MwzbvKj60P2H7sRaw', expires = '1758529772', refresh_token = 'Fv8ht4ObSnXEWNveNeesXWsEme9y4liV5a4uWrtloSE', id_token = 'eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3NTg1Mjc5NzIsImV4cCI6MTc1ODUyODI3MiwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6Ijk0OTY0RjAyOTA5MTQyNDVCNTk3QzZBQzRENDE1ODAyIiwiaWF0IjoxNzU4NTI3OTcyLCJhdF9oYXNoIjoiNDUtODNCVERZVDdBR3Q5Xy1hVzF6USIsInN1YiI6IjJiNmE3YzZiMmVlMTUzZjVhMDQ4N2QwY2Y4YmMzZWU5IiwiYXV0aF90aW1lIjoxNjkxOTkyNTk3LCJ4ZXJvX3VzZXJpZCI6ImFiODhlNTUzLTI0NmUtNDhkMy05MmRjLTBhMWY2ZWYzOTFjZSIsImdsb2JhbF9zZXNzaW9uX2lkIjoiNjc2NjExYTBkMzkwNGFkZWEyYjMyZWY1MDQ4NThhYTEiLCJzaWQiOiI2NzY2MTFhMGQzOTA0YWRlYTJiMzJlZjUwNDg1OGFhMSIsInByZWZlcnJlZF91c2VybmFtZSI6ImtldmluQHdoaXRldG93ZXIuY29tLmF1IiwiZW1haWwiOiJrZXZpbkB3aGl0ZXRvd2VyLmNvbS5hdSIsImdpdmVuX25hbWUiOiJLZXZpbiIsImZhbWlseV9uYW1lIjoiS2V2aW4iLCJuYW1lIjoiS2V2aW4gS2V2aW4iLCJhbXIiOlsicHdkIl19.HkceLb23mL707od6LUpxOUOhJI2wVuTvYRPaQt_6Z-EpqjePMXXtvziDqmqd1jxya2MnQlAbA0On_ctELcRJnjSEEFCrP4ePJVzaVpNwxv9PWABjNGxgeZyU-5f1pcf4JxOozy8DwPd8Y5Dj4Hul5NivJ8S6h040REwkyV7kLN1Ceb_jHbuOk7xqE0ktTh68ijAgtDUwRHTtq5H4dVU77MiNQlbFm9GNQSDRUxslO775fU7eqa5Q6BtJyY744GOoxscNUo2jvqnDKe3FDTf66eZAcRPxj75PIpjCUV4Vks2qCTOLy6zJ3j1L5zjtFtHs_L_WoU5KsQ-m7CtwxMAdrw' WHERE id = 1;

SELECT
  f0_.id AS id_0,
  f0_.title AS title_1,
  f0_.production_stage AS production_stage_2,
  f0_.production_type AS production_type_3,
  f0_.status AS status_4,
  f0_.wordpress_id AS wordpress_id_5,
  f0_.wordpress_status AS wordpress_status_6,
  f0_.salesforce_id AS salesforce_id_7,
  f0_.note AS note_8,
  f0_.resubmit_count AS resubmit_count_9,
  f0_.created_at AS created_at_10,
  f0_.modified_at AS modified_at_11,
  f0_.total_donation AS total_donation_12,
  f0_.tracking_option_id AS tracking_option_id_13,
  f0_.tab_active AS tab_active_14,
  f0_.is_hide_donation_box AS is_hide_donation_box_15,
  f0_.wordpress_password AS wordpress_password_16,
  f0_.old_wordpress_id AS old_wordpress_id_17,
  f0_.is_daf_core AS is_daf_core_18,
  f0_.is_daf_program AS is_daf_program_19,
  f0_.xero_id AS xero_id_20,
  f0_.is_progress_report_active AS is_progress_report_active_21,
  f0_.progress_report_start_date AS progress_report_start_date_22,
  f0_.current_progress_report_year AS current_progress_report_year_23,
  f0_.owner_id AS owner_id_24,
  f0_.order_details_id AS order_details_id_25,
  f0_.film_project_admin_id AS film_project_admin_id_26,
  f0_.film_project_producer_id AS film_project_producer_id_27,
  f0_.film_project_director_id AS film_project_director_id_28,
  f0_.product_id AS product_id_29,
  f0_.recurring_product_id AS recurring_product_id_30
FROM
  film_project f0_
WHERE
  f0_.status = ?
  AND f0_.wordpress_status <> ?
ORDER BY
  f0_.id DESC

SELECT f0_.id AS id_0, f0_.title AS title_1, f0_.production_stage AS production_stage_2, f0_.production_type AS production_type_3, f0_.status AS status_4, f0_.wordpress_id AS wordpress_id_5, f0_.wordpress_status AS wordpress_status_6, f0_.salesforce_id AS salesforce_id_7, f0_.note AS note_8, f0_.resubmit_count AS resubmit_count_9, f0_.created_at AS created_at_10, f0_.modified_at AS modified_at_11, f0_.total_donation AS total_donation_12, f0_.tracking_option_id AS tracking_option_id_13, f0_.tab_active AS tab_active_14, f0_.is_hide_donation_box AS is_hide_donation_box_15, f0_.wordpress_password AS wordpress_password_16, f0_.old_wordpress_id AS old_wordpress_id_17, f0_.is_daf_core AS is_daf_core_18, f0_.is_daf_program AS is_daf_program_19, f0_.xero_id AS xero_id_20, f0_.is_progress_report_active AS is_progress_report_active_21, f0_.progress_report_start_date AS progress_report_start_date_22, f0_.current_progress_report_year AS current_progress_report_year_23, f0_.owner_id AS owner_id_24, f0_.order_details_id AS order_details_id_25, f0_.film_project_admin_id AS film_project_admin_id_26, f0_.film_project_producer_id AS film_project_producer_id_27, f0_.film_project_director_id AS film_project_director_id_28, f0_.product_id AS product_id_29, f0_.recurring_product_id AS recurring_product_id_30 FROM film_project f0_ WHERE f0_.status = 'approved' AND f0_.wordpress_status <> 'archived' ORDER BY f0_.id DESC;

SELECT
  f0_.id AS id_0,
  f0_.title AS title_1,
  f0_.production_stage AS production_stage_2,
  f0_.production_type AS production_type_3,
  f0_.status AS status_4,
  f0_.wordpress_id AS wordpress_id_5,
  f0_.wordpress_status AS wordpress_status_6,
  f0_.salesforce_id AS salesforce_id_7,
  f0_.note AS note_8,
  f0_.resubmit_count AS resubmit_count_9,
  f0_.created_at AS created_at_10,
  f0_.modified_at AS modified_at_11,
  f0_.total_donation AS total_donation_12,
  f0_.tracking_option_id AS tracking_option_id_13,
  f0_.tab_active AS tab_active_14,
  f0_.is_hide_donation_box AS is_hide_donation_box_15,
  f0_.wordpress_password AS wordpress_password_16,
  f0_.old_wordpress_id AS old_wordpress_id_17,
  f0_.is_daf_core AS is_daf_core_18,
  f0_.is_daf_program AS is_daf_program_19,
  f0_.xero_id AS xero_id_20,
  f0_.is_progress_report_active AS is_progress_report_active_21,
  f0_.progress_report_start_date AS progress_report_start_date_22,
  f0_.current_progress_report_year AS current_progress_report_year_23,
  f0_.owner_id AS owner_id_24,
  f0_.order_details_id AS order_details_id_25,
  f0_.film_project_admin_id AS film_project_admin_id_26,
  f0_.film_project_producer_id AS film_project_producer_id_27,
  f0_.film_project_director_id AS film_project_director_id_28,
  f0_.product_id AS product_id_29,
  f0_.recurring_product_id AS recurring_product_id_30
FROM
  film_project f0_
WHERE
  (
    f0_.created_at BETWEEN ?
    AND ?
  )
  AND f0_.status = ?
  AND f0_.wordpress_status <> ?
ORDER BY
  f0_.title ASC

SELECT f0_.id AS id_0, f0_.title AS title_1, f0_.production_stage AS production_stage_2, f0_.production_type AS production_type_3, f0_.status AS status_4, f0_.wordpress_id AS wordpress_id_5, f0_.wordpress_status AS wordpress_status_6, f0_.salesforce_id AS salesforce_id_7, f0_.note AS note_8, f0_.resubmit_count AS resubmit_count_9, f0_.created_at AS created_at_10, f0_.modified_at AS modified_at_11, f0_.total_donation AS total_donation_12, f0_.tracking_option_id AS tracking_option_id_13, f0_.tab_active AS tab_active_14, f0_.is_hide_donation_box AS is_hide_donation_box_15, f0_.wordpress_password AS wordpress_password_16, f0_.old_wordpress_id AS old_wordpress_id_17, f0_.is_daf_core AS is_daf_core_18, f0_.is_daf_program AS is_daf_program_19, f0_.xero_id AS xero_id_20, f0_.is_progress_report_active AS is_progress_report_active_21, f0_.progress_report_start_date AS progress_report_start_date_22, f0_.current_progress_report_year AS current_progress_report_year_23, f0_.owner_id AS owner_id_24, f0_.order_details_id AS order_details_id_25, f0_.film_project_admin_id AS film_project_admin_id_26, f0_.film_project_producer_id AS film_project_producer_id_27, f0_.film_project_director_id AS film_project_director_id_28, f0_.product_id AS product_id_29, f0_.recurring_product_id AS recurring_product_id_30 FROM film_project f0_ WHERE (f0_.created_at BETWEEN '2020-09-22 00:00:00' AND '2025-05-01 23:59:59') AND f0_.status = 'approved' AND f0_.wordpress_status <> 'archived' ORDER BY f0_.title ASC;