Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.business_type AS business_type_2,
  t0.ranking AS ranking_3,
  t0.description AS description_4,
  t0.map_icon_id AS map_icon_id_5
FROM
  business_types t0
WHERE
  t0.business_type = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.business_type AS business_type_2, t0.ranking AS ranking_3, t0.description AS description_4, t0.map_icon_id AS map_icon_id_5 FROM business_types t0 WHERE t0.business_type = 'Veterinarians' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.first_name AS first_name_2,
  t0.last_name AS last_name_3,
  t0.email AS email_4,
  t0.mobile AS mobile_5,
  t0.landline AS landline_6,
  t0.company AS company_7,
  t0.address_street AS address_street_8,
  t0.address_city AS address_city_9,
  t0.address_post_code AS address_post_code_10,
  t0.address_country AS address_country_11,
  t0.business_or_person AS business_or_person_12,
  t0.website AS website_13,
  t0.status AS status_14,
  t0.location_latitude AS location_latitude_15,
  t0.location_longitude AS location_longitude_16,
  t0.photo AS photo_17,
  t0.files AS files_18,
  t0.notes AS notes_19,
  t0.address_county AS address_county_20,
  t0.business_type_id AS business_type_id_21
FROM
  business_contacts t0
WHERE
  t0.status = ?
  AND t0.business_type_id = ?

SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.email AS email_4, t0.mobile AS mobile_5, t0.landline AS landline_6, t0.company AS company_7, t0.address_street AS address_street_8, t0.address_city AS address_city_9, t0.address_post_code AS address_post_code_10, t0.address_country AS address_country_11, t0.business_or_person AS business_or_person_12, t0.website AS website_13, t0.status AS status_14, t0.location_latitude AS location_latitude_15, t0.location_longitude AS location_longitude_16, t0.photo AS photo_17, t0.files AS files_18, t0.notes AS notes_19, t0.address_county AS address_county_20, t0.business_type_id AS business_type_id_21 FROM business_contacts t0 WHERE t0.status = 'Approved' AND t0.business_type_id = 16;

SELECT
  t0.id AS id_1,
  t0.business_type AS business_type_2,
  t0.ranking AS ranking_3,
  t0.description AS description_4,
  t0.map_icon_id AS map_icon_id_5
FROM
  business_types t0
ORDER BY
  t0.ranking ASC

SELECT t0.id AS id_1, t0.business_type AS business_type_2, t0.ranking AS ranking_3, t0.description AS description_4, t0.map_icon_id AS map_icon_id_5 FROM business_types t0 ORDER BY t0.ranking ASC;

SELECT
  t0.id AS id_1,
  t0.company_name AS company_name_2,
  t0.company_email AS company_email_3,
  t0.company_tel AS company_tel_4,
  t0.company_mobile AS company_mobile_5,
  t0.company_address_street AS company_address_street_6,
  t0.company_address_town AS company_address_town_7,
  t0.company_address_city AS company_address_city_8,
  t0.company_address_postal_code AS company_address_postal_code_9,
  t0.company_address_country AS company_address_country_10,
  t0.facebook AS facebook_11,
  t0.linked_in AS linked_in_12,
  t0.instagram AS instagram_13,
  t0.twitter AS twitter_14,
  t0.favicon_live AS favicon_live_15,
  t0.favicon_dev AS favicon_dev_16,
  t0.currency AS currency_17,
  t0.company_email_password AS company_email_password_18,
  t0.company_email_import_directory AS company_email_import_directory_19,
  t0.company_email_import_processed_directory AS company_email_import_processed_directory_20,
  t0.weather_location AS weather_location_21,
  t0.company_website AS company_website_22,
  t0.company_address_longitude AS company_address_longitude_23,
  t0.company_address_latitude AS company_address_latitude_24,
  t0.company_time_zone AS company_time_zone_25,
  t0.company_skype AS company_skype_26,
  t0.company_qr_code AS company_qr_code_27,
  t0.footer_display_products AS footer_display_products_28,
  t0.footer_display_social_media AS footer_display_social_media_29,
  t0.footer_display_address AS footer_display_address_30,
  t0.footer_display_tel_numbers AS footer_display_tel_numbers_31,
  t0.footer_display_contact_details AS footer_display_contact_details_32,
  t0.header_display_login AS header_display_login_33,
  t0.contact_first_name AS contact_first_name_34,
  t0.contact_last_name AS contact_last_name_35,
  t0.home_page_photos_only AS home_page_photos_only_36,
  t0.database_password AS database_password_37,
  t0.sql_database AS sql_database_38,
  t0.header_display_tand_cs AS header_display_tand_cs_39,
  t0.header_display_products AS header_display_products_40,
  t0.header_display_sub_products AS header_display_sub_products_41,
  t0.footer_display_sub_products AS footer_display_sub_products_42,
  t0.include_contact_form_home_page AS include_contact_form_home_page_43,
  t0.multi_lingual AS multi_lingual_44,
  t0.enable_user_registration AS enable_user_registration_45,
  t0.include_qrcode_home_page AS include_qrcode_home_page_46,
  t0.header_display_contact_details AS header_display_contact_details_47,
  t0.header_display_business_contacts AS header_display_business_contacts_48,
  t0.header_display_weather AS header_display_weather_49,
  t0.header_display_facebook_pages AS header_display_facebook_pages_50,
  t0.header_display_competitors AS header_display_competitors_51,
  t0.facebook_reviews_history_show_months AS facebook_reviews_history_show_months_52,
  t0.title_useful_links AS title_useful_links_53,
  t0.header_display_photos AS header_display_photos_54,
  t0.title_products AS title_products_55,
  t0.title_sub_products AS title_sub_products_56,
  t0.company_address_map_link AS company_address_map_link_57,
  t0.company_address_instructions AS company_address_instructions_58,
  t0.registration_email AS registration_email_59,
  t0.user_include_home_address AS user_include_home_address_60,
  t0.user_include_business_address AS user_include_business_address_61,
  t0.user_include_personal_details AS user_include_personal_details_62,
  t0.user_include_job_details AS user_include_job_details_63,
  t0.website_contacts_email_alert AS website_contacts_email_alert_64,
  t0.website_contacts_auto_reply AS website_contacts_auto_reply_65,
  t0.contact_from_response AS contact_from_response_66,
  t0.default_user_password AS default_user_password_67,
  t0.contact_from_response_duplicate_verified AS contact_from_response_duplicate_verified_68,
  t0.contact_from_response_duplicate_unverified AS contact_from_response_duplicate_unverified_69,
  t0.header_display_tel_numbers AS header_display_tel_numbers_70,
  t0.header_display_address AS header_display_address_71
FROM
  company_details t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.company_name AS company_name_2, t0.company_email AS company_email_3, t0.company_tel AS company_tel_4, t0.company_mobile AS company_mobile_5, t0.company_address_street AS company_address_street_6, t0.company_address_town AS company_address_town_7, t0.company_address_city AS company_address_city_8, t0.company_address_postal_code AS company_address_postal_code_9, t0.company_address_country AS company_address_country_10, t0.facebook AS facebook_11, t0.linked_in AS linked_in_12, t0.instagram AS instagram_13, t0.twitter AS twitter_14, t0.favicon_live AS favicon_live_15, t0.favicon_dev AS favicon_dev_16, t0.currency AS currency_17, t0.company_email_password AS company_email_password_18, t0.company_email_import_directory AS company_email_import_directory_19, t0.company_email_import_processed_directory AS company_email_import_processed_directory_20, t0.weather_location AS weather_location_21, t0.company_website AS company_website_22, t0.company_address_longitude AS company_address_longitude_23, t0.company_address_latitude AS company_address_latitude_24, t0.company_time_zone AS company_time_zone_25, t0.company_skype AS company_skype_26, t0.company_qr_code AS company_qr_code_27, t0.footer_display_products AS footer_display_products_28, t0.footer_display_social_media AS footer_display_social_media_29, t0.footer_display_address AS footer_display_address_30, t0.footer_display_tel_numbers AS footer_display_tel_numbers_31, t0.footer_display_contact_details AS footer_display_contact_details_32, t0.header_display_login AS header_display_login_33, t0.contact_first_name AS contact_first_name_34, t0.contact_last_name AS contact_last_name_35, t0.home_page_photos_only AS home_page_photos_only_36, t0.database_password AS database_password_37, t0.sql_database AS sql_database_38, t0.header_display_tand_cs AS header_display_tand_cs_39, t0.header_display_products AS header_display_products_40, t0.header_display_sub_products AS header_display_sub_products_41, t0.footer_display_sub_products AS footer_display_sub_products_42, t0.include_contact_form_home_page AS include_contact_form_home_page_43, t0.multi_lingual AS multi_lingual_44, t0.enable_user_registration AS enable_user_registration_45, t0.include_qrcode_home_page AS include_qrcode_home_page_46, t0.header_display_contact_details AS header_display_contact_details_47, t0.header_display_business_contacts AS header_display_business_contacts_48, t0.header_display_weather AS header_display_weather_49, t0.header_display_facebook_pages AS header_display_facebook_pages_50, t0.header_display_competitors AS header_display_competitors_51, t0.facebook_reviews_history_show_months AS facebook_reviews_history_show_months_52, t0.title_useful_links AS title_useful_links_53, t0.header_display_photos AS header_display_photos_54, t0.title_products AS title_products_55, t0.title_sub_products AS title_sub_products_56, t0.company_address_map_link AS company_address_map_link_57, t0.company_address_instructions AS company_address_instructions_58, t0.registration_email AS registration_email_59, t0.user_include_home_address AS user_include_home_address_60, t0.user_include_business_address AS user_include_business_address_61, t0.user_include_personal_details AS user_include_personal_details_62, t0.user_include_job_details AS user_include_job_details_63, t0.website_contacts_email_alert AS website_contacts_email_alert_64, t0.website_contacts_auto_reply AS website_contacts_auto_reply_65, t0.contact_from_response AS contact_from_response_66, t0.default_user_password AS default_user_password_67, t0.contact_from_response_duplicate_verified AS contact_from_response_duplicate_verified_68, t0.contact_from_response_duplicate_unverified AS contact_from_response_duplicate_unverified_69, t0.header_display_tel_numbers AS header_display_tel_numbers_70, t0.header_display_address AS header_display_address_71 FROM company_details t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.product AS product_2,
  t0.ranking AS ranking_3,
  t0.is_active AS is_active_4,
  t0.include_in_footer AS include_in_footer_5,
  t0.category AS category_6,
  t0.include_in_contact_form AS include_in_contact_form_7,
  t0.notes AS notes_8,
  t0.new_client_email AS new_client_email_9
FROM
  product t0
WHERE
  t0.category = ?
  AND t0.is_active = ?
ORDER BY
  t0.ranking ASC

SELECT t0.id AS id_1, t0.product AS product_2, t0.ranking AS ranking_3, t0.is_active AS is_active_4, t0.include_in_footer AS include_in_footer_5, t0.category AS category_6, t0.include_in_contact_form AS include_in_contact_form_7, t0.notes AS notes_8, t0.new_client_email AS new_client_email_9 FROM product t0 WHERE t0.category = 'Main' AND t0.is_active = 1 ORDER BY t0.ranking ASC;

SELECT
  COUNT(*)
FROM
  photo_locations t0

SELECT COUNT(*) FROM photo_locations t0;

SELECT
  t0.id AS id_1,
  t0.language AS language_2,
  t0.abbreviation AS abbreviation_3,
  t0.icon AS icon_4,
  t0.is_active AS is_active_5,
  t0.linked_in_other AS linked_in_other_6,
  t0.ranking AS ranking_7
FROM
  languages t0
WHERE
  t0.is_active = ?

SELECT t0.id AS id_1, t0.language AS language_2, t0.abbreviation AS abbreviation_3, t0.icon AS icon_4, t0.is_active AS is_active_5, t0.linked_in_other AS linked_in_other_6, t0.ranking AS ranking_7 FROM languages t0 WHERE t0.is_active = 1;

SELECT
  t0.id AS id_1,
  t0.language AS language_2,
  t0.abbreviation AS abbreviation_3,
  t0.icon AS icon_4,
  t0.is_active AS is_active_5,
  t0.linked_in_other AS linked_in_other_6,
  t0.ranking AS ranking_7
FROM
  languages t0
WHERE
  t0.language = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.language AS language_2, t0.abbreviation AS abbreviation_3, t0.icon AS icon_4, t0.is_active AS is_active_5, t0.linked_in_other AS linked_in_other_6, t0.ranking AS ranking_7 FROM languages t0 WHERE t0.language = 'English' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.language AS language_2,
  t0.abbreviation AS abbreviation_3,
  t0.icon AS icon_4,
  t0.is_active AS is_active_5,
  t0.linked_in_other AS linked_in_other_6,
  t0.ranking AS ranking_7
FROM
  languages t0
WHERE
  t0.language = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.language AS language_2, t0.abbreviation AS abbreviation_3, t0.icon AS icon_4, t0.is_active AS is_active_5, t0.linked_in_other AS linked_in_other_6, t0.ranking AS ranking_7 FROM languages t0 WHERE t0.language = 'English' LIMIT 1;

SELECT
  l0_.id AS id_0,
  l0_.language AS language_1,
  l0_.abbreviation AS abbreviation_2,
  l0_.icon AS icon_3,
  l0_.is_active AS is_active_4,
  l0_.linked_in_other AS linked_in_other_5,
  l0_.ranking AS ranking_6
FROM
  languages l0_
WHERE
  l0_.is_active = 1
ORDER BY
  l0_.ranking ASC

SELECT l0_.id AS id_0, l0_.language AS language_1, l0_.abbreviation AS abbreviation_2, l0_.icon AS icon_3, l0_.is_active AS is_active_4, l0_.linked_in_other AS linked_in_other_5, l0_.ranking AS ranking_6 FROM languages l0_ WHERE l0_.is_active = 1 ORDER BY l0_.ranking ASC;

SELECT
  t0.id AS id_1,
  t0.language AS language_2,
  t0.abbreviation AS abbreviation_3,
  t0.icon AS icon_4,
  t0.is_active AS is_active_5,
  t0.linked_in_other AS linked_in_other_6,
  t0.ranking AS ranking_7
FROM
  languages t0
WHERE
  t0.language = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.language AS language_2, t0.abbreviation AS abbreviation_3, t0.icon AS icon_4, t0.is_active AS is_active_5, t0.linked_in_other AS linked_in_other_6, t0.ranking AS ranking_7 FROM languages t0 WHERE t0.language = 'English' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.language AS language_2,
  t0.abbreviation AS abbreviation_3,
  t0.icon AS icon_4,
  t0.is_active AS is_active_5,
  t0.linked_in_other AS linked_in_other_6,
  t0.ranking AS ranking_7
FROM
  languages t0
WHERE
  t0.language = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.language AS language_2, t0.abbreviation AS abbreviation_3, t0.icon AS icon_4, t0.is_active AS is_active_5, t0.linked_in_other AS linked_in_other_6, t0.ranking AS ranking_7 FROM languages t0 WHERE t0.language = 'English' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.language AS language_2,
  t0.abbreviation AS abbreviation_3,
  t0.icon AS icon_4,
  t0.is_active AS is_active_5,
  t0.linked_in_other AS linked_in_other_6,
  t0.ranking AS ranking_7
FROM
  languages t0
WHERE
  t0.language = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.language AS language_2, t0.abbreviation AS abbreviation_3, t0.icon AS icon_4, t0.is_active AS is_active_5, t0.linked_in_other AS linked_in_other_6, t0.ranking AS ranking_7 FROM languages t0 WHERE t0.language = 'English' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.language AS language_2,
  t0.abbreviation AS abbreviation_3,
  t0.icon AS icon_4,
  t0.is_active AS is_active_5,
  t0.linked_in_other AS linked_in_other_6,
  t0.ranking AS ranking_7
FROM
  languages t0
WHERE
  t0.language = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.language AS language_2, t0.abbreviation AS abbreviation_3, t0.icon AS icon_4, t0.is_active AS is_active_5, t0.linked_in_other AS linked_in_other_6, t0.ranking AS ranking_7 FROM languages t0 WHERE t0.language = 'English' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.language AS language_2,
  t0.abbreviation AS abbreviation_3,
  t0.icon AS icon_4,
  t0.is_active AS is_active_5,
  t0.linked_in_other AS linked_in_other_6,
  t0.ranking AS ranking_7
FROM
  languages t0
WHERE
  t0.language = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.language AS language_2, t0.abbreviation AS abbreviation_3, t0.icon AS icon_4, t0.is_active AS is_active_5, t0.linked_in_other AS linked_in_other_6, t0.ranking AS ranking_7 FROM languages t0 WHERE t0.language = 'English' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.language AS language_2,
  t0.abbreviation AS abbreviation_3,
  t0.icon AS icon_4,
  t0.is_active AS is_active_5,
  t0.linked_in_other AS linked_in_other_6,
  t0.ranking AS ranking_7
FROM
  languages t0
WHERE
  t0.language = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.language AS language_2, t0.abbreviation AS abbreviation_3, t0.icon AS icon_4, t0.is_active AS is_active_5, t0.linked_in_other AS linked_in_other_6, t0.ranking AS ranking_7 FROM languages t0 WHERE t0.language = 'English' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.language AS language_2,
  t0.abbreviation AS abbreviation_3,
  t0.icon AS icon_4,
  t0.is_active AS is_active_5,
  t0.linked_in_other AS linked_in_other_6,
  t0.ranking AS ranking_7
FROM
  languages t0
WHERE
  t0.language = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.language AS language_2, t0.abbreviation AS abbreviation_3, t0.icon AS icon_4, t0.is_active AS is_active_5, t0.linked_in_other AS linked_in_other_6, t0.ranking AS ranking_7 FROM languages t0 WHERE t0.language = 'English' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.language AS language_2,
  t0.abbreviation AS abbreviation_3,
  t0.icon AS icon_4,
  t0.is_active AS is_active_5,
  t0.linked_in_other AS linked_in_other_6,
  t0.ranking AS ranking_7
FROM
  languages t0
WHERE
  t0.language = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.language AS language_2, t0.abbreviation AS abbreviation_3, t0.icon AS icon_4, t0.is_active AS is_active_5, t0.linked_in_other AS linked_in_other_6, t0.ranking AS ranking_7 FROM languages t0 WHERE t0.language = 'English' LIMIT 1;

SELECT
  COUNT(b0_.id) AS sclr_0
FROM
  business_contacts b0_
WHERE
  b0_.business_type_id = ?
  AND b0_.status = ?
  AND b0_.location_latitude <> 0

SELECT COUNT(b0_.id) AS sclr_0 FROM business_contacts b0_ WHERE b0_.business_type_id = 3 AND b0_.status = 'Approved' AND b0_.location_latitude <> 0;

SELECT
  COUNT(b0_.id) AS sclr_0
FROM
  business_contacts b0_
WHERE
  b0_.business_type_id = ?
  AND b0_.status = ?
  AND b0_.location_latitude <> 0

SELECT COUNT(b0_.id) AS sclr_0 FROM business_contacts b0_ WHERE b0_.business_type_id = 16 AND b0_.status = 'Approved' AND b0_.location_latitude <> 0;

SELECT
  COUNT(b0_.id) AS sclr_0
FROM
  business_contacts b0_
WHERE
  b0_.business_type_id = ?

SELECT COUNT(b0_.id) AS sclr_0 FROM business_contacts b0_ WHERE b0_.business_type_id = 16;

SELECT
  COUNT(b0_.id) AS sclr_0
FROM
  business_contacts b0_
WHERE
  b0_.business_type_id = ?
  AND b0_.status = ?
  AND b0_.location_latitude <> 0

SELECT COUNT(b0_.id) AS sclr_0 FROM business_contacts b0_ WHERE b0_.business_type_id = 2 AND b0_.status = 'Approved' AND b0_.location_latitude <> 0;

SELECT
  COUNT(b0_.id) AS sclr_0
FROM
  business_contacts b0_
WHERE
  b0_.business_type_id = ?

SELECT COUNT(b0_.id) AS sclr_0 FROM business_contacts b0_ WHERE b0_.business_type_id = 2;

SELECT
  COUNT(b0_.id) AS sclr_0
FROM
  business_contacts b0_
WHERE
  b0_.business_type_id = ?
  AND b0_.status = ?
  AND b0_.location_latitude <> 0

SELECT COUNT(b0_.id) AS sclr_0 FROM business_contacts b0_ WHERE b0_.business_type_id = 4 AND b0_.status = 'Approved' AND b0_.location_latitude <> 0;

SELECT
  COUNT(b0_.id) AS sclr_0
FROM
  business_contacts b0_
WHERE
  b0_.business_type_id = ?

SELECT COUNT(b0_.id) AS sclr_0 FROM business_contacts b0_ WHERE b0_.business_type_id = 4;

SELECT
  COUNT(b0_.id) AS sclr_0
FROM
  business_contacts b0_
WHERE
  b0_.business_type_id = ?
  AND b0_.status = ?
  AND b0_.location_latitude <> 0

SELECT COUNT(b0_.id) AS sclr_0 FROM business_contacts b0_ WHERE b0_.business_type_id = 5 AND b0_.status = 'Approved' AND b0_.location_latitude <> 0;

SELECT
  COUNT(b0_.id) AS sclr_0
FROM
  business_contacts b0_
WHERE
  b0_.business_type_id = ?
  AND b0_.status = ?
  AND b0_.location_latitude <> 0

SELECT COUNT(b0_.id) AS sclr_0 FROM business_contacts b0_ WHERE b0_.business_type_id = 6 AND b0_.status = 'Approved' AND b0_.location_latitude <> 0;

SELECT
  COUNT(b0_.id) AS sclr_0
FROM
  business_contacts b0_
WHERE
  b0_.business_type_id = ?
  AND b0_.status = ?
  AND b0_.location_latitude <> 0

SELECT COUNT(b0_.id) AS sclr_0 FROM business_contacts b0_ WHERE b0_.business_type_id = 7 AND b0_.status = 'Approved' AND b0_.location_latitude <> 0;

SELECT
  COUNT(b0_.id) AS sclr_0
FROM
  business_contacts b0_
WHERE
  b0_.business_type_id = ?
  AND b0_.status = ?
  AND b0_.location_latitude <> 0

SELECT COUNT(b0_.id) AS sclr_0 FROM business_contacts b0_ WHERE b0_.business_type_id = 8 AND b0_.status = 'Approved' AND b0_.location_latitude <> 0;

SELECT
  COUNT(b0_.id) AS sclr_0
FROM
  business_contacts b0_
WHERE
  b0_.business_type_id = ?
  AND b0_.status = ?
  AND b0_.location_latitude <> 0

SELECT COUNT(b0_.id) AS sclr_0 FROM business_contacts b0_ WHERE b0_.business_type_id = 1 AND b0_.status = 'Approved' AND b0_.location_latitude <> 0;

SELECT
  COUNT(b0_.id) AS sclr_0
FROM
  business_contacts b0_
WHERE
  b0_.business_type_id = ?
  AND b0_.status = ?
  AND b0_.location_latitude <> 0

SELECT COUNT(b0_.id) AS sclr_0 FROM business_contacts b0_ WHERE b0_.business_type_id = 9 AND b0_.status = 'Approved' AND b0_.location_latitude <> 0;

SELECT
  COUNT(b0_.id) AS sclr_0
FROM
  business_contacts b0_
WHERE
  b0_.business_type_id = ?
  AND b0_.status = ?
  AND b0_.location_latitude <> 0

SELECT COUNT(b0_.id) AS sclr_0 FROM business_contacts b0_ WHERE b0_.business_type_id = 10 AND b0_.status = 'Approved' AND b0_.location_latitude <> 0;

SELECT
  COUNT(b0_.id) AS sclr_0
FROM
  business_contacts b0_
WHERE
  b0_.business_type_id = ?

SELECT COUNT(b0_.id) AS sclr_0 FROM business_contacts b0_ WHERE b0_.business_type_id = 10;

SELECT
  COUNT(b0_.id) AS sclr_0
FROM
  business_contacts b0_
WHERE
  b0_.business_type_id = ?
  AND b0_.status = ?
  AND b0_.location_latitude <> 0

SELECT COUNT(b0_.id) AS sclr_0 FROM business_contacts b0_ WHERE b0_.business_type_id = 11 AND b0_.status = 'Approved' AND b0_.location_latitude <> 0;

SELECT
  COUNT(b0_.id) AS sclr_0
FROM
  business_contacts b0_
WHERE
  b0_.business_type_id = ?
  AND b0_.status = ?
  AND b0_.location_latitude <> 0

SELECT COUNT(b0_.id) AS sclr_0 FROM business_contacts b0_ WHERE b0_.business_type_id = 12 AND b0_.status = 'Approved' AND b0_.location_latitude <> 0;

SELECT
  COUNT(b0_.id) AS sclr_0
FROM
  business_contacts b0_
WHERE
  b0_.business_type_id = ?
  AND b0_.status = ?
  AND b0_.location_latitude <> 0

SELECT COUNT(b0_.id) AS sclr_0 FROM business_contacts b0_ WHERE b0_.business_type_id = 13 AND b0_.status = 'Approved' AND b0_.location_latitude <> 0;

SELECT
  COUNT(b0_.id) AS sclr_0
FROM
  business_contacts b0_
WHERE
  b0_.business_type_id = ?
  AND b0_.status = ?
  AND b0_.location_latitude <> 0

SELECT COUNT(b0_.id) AS sclr_0 FROM business_contacts b0_ WHERE b0_.business_type_id = 14 AND b0_.status = 'Approved' AND b0_.location_latitude <> 0;

SELECT
  COUNT(b0_.id) AS sclr_0
FROM
  business_contacts b0_
WHERE
  b0_.business_type_id = ?
  AND b0_.status = ?
  AND b0_.location_latitude <> 0

SELECT COUNT(b0_.id) AS sclr_0 FROM business_contacts b0_ WHERE b0_.business_type_id = 15 AND b0_.status = 'Approved' AND b0_.location_latitude <> 0;

SELECT
  COUNT(b0_.id) AS sclr_0
FROM
  business_contacts b0_
WHERE
  b0_.business_type_id = ?
  AND b0_.status = ?
  AND b0_.location_latitude <> 0

SELECT COUNT(b0_.id) AS sclr_0 FROM business_contacts b0_ WHERE b0_.business_type_id = 17 AND b0_.status = 'Approved' AND b0_.location_latitude <> 0;