Symfony Profiler

SELECT
  p0_.id_employee AS id_employee_0,
  p0_.firstname AS firstname_1,
  p0_.lastname AS lastname_2,
  p0_.email AS email_3,
  p0_.passwd AS passwd_4,
  p0_.last_passwd_gen AS last_passwd_gen_5,
  p0_.reset_password_token AS reset_password_token_6,
  p0_.reset_password_validity AS reset_password_validity_7,
  p0_.default_tab AS default_tab_8,
  p0_.active AS active_9,
  p0_.last_connection_date AS last_connection_date_10,
  p0_.has_enabled_gravatar AS has_enabled_gravatar_11,
  p0_.stats_date_from AS stats_date_from_12,
  p0_.stats_date_to AS stats_date_to_13,
  p0_.stats_compare_from AS stats_compare_from_14,
  p0_.stats_compare_to AS stats_compare_to_15,
  p0_.stats_compare_option AS stats_compare_option_16,
  p0_.preselect_date_range AS preselect_date_range_17,
  p0_.bo_color AS bo_color_18,
  p0_.bo_theme AS bo_theme_19,
  p0_.bo_css AS bo_css_20,
  p0_.bo_width AS bo_width_21,
  p0_.bo_menu AS bo_menu_22,
  p0_.optin AS optin_23,
  p0_.id_last_order AS id_last_order_24,
  p0_.id_last_customer_message AS id_last_customer_message_25,
  p0_.id_last_customer AS id_last_customer_26,
  p0_.id_employee AS id_employee_27,
  p0_.firstname AS firstname_28,
  p0_.lastname AS lastname_29,
  p0_.email AS email_30,
  p0_.passwd AS passwd_31,
  p0_.last_passwd_gen AS last_passwd_gen_32,
  p0_.reset_password_token AS reset_password_token_33,
  p0_.reset_password_validity AS reset_password_validity_34,
  p0_.default_tab AS default_tab_35,
  p0_.active AS active_36,
  p0_.last_connection_date AS last_connection_date_37,
  p0_.has_enabled_gravatar AS has_enabled_gravatar_38,
  p0_.stats_date_from AS stats_date_from_39,
  p0_.stats_date_to AS stats_date_to_40,
  p0_.stats_compare_from AS stats_compare_from_41,
  p0_.stats_compare_to AS stats_compare_to_42,
  p0_.stats_compare_option AS stats_compare_option_43,
  p0_.preselect_date_range AS preselect_date_range_44,
  p0_.bo_color AS bo_color_45,
  p0_.bo_theme AS bo_theme_46,
  p0_.bo_css AS bo_css_47,
  p0_.bo_width AS bo_width_48,
  p0_.bo_menu AS bo_menu_49,
  p0_.optin AS optin_50,
  p0_.id_last_order AS id_last_order_51,
  p0_.id_last_customer_message AS id_last_customer_message_52,
  p0_.id_last_customer AS id_last_customer_53,
  p1_.id_profile AS id_profile_54,
  p2_.id_lang AS id_lang_55,
  p2_.name AS name_56,
  p2_.active AS active_57,
  p2_.iso_code AS iso_code_58,
  p2_.language_code AS language_code_59,
  p2_.locale AS locale_60,
  p2_.date_format_lite AS date_format_lite_61,
  p2_.date_format_full AS date_format_full_62,
  p2_.is_rtl AS is_rtl_63,
  p3_.id_employee_session AS id_employee_session_64,
  p3_.token AS token_65,
  p3_.date_add AS date_add_66,
  p3_.date_upd AS date_upd_67,
  p0_.id_profile AS id_profile_68,
  p0_.id_lang AS id_lang_69,
  p3_.id_employee AS id_employee_70
FROM
  ps_employee p0_
  LEFT JOIN ps_profile p1_ ON p0_.id_profile = p1_.id_profile
  LEFT JOIN ps_lang p2_ ON p0_.id_lang = p2_.id_lang
  LEFT JOIN ps_employee_session p3_ ON p0_.id_employee = p3_.id_employee
WHERE
  p0_.email = ?

SELECT p0_.id_employee AS id_employee_0, p0_.firstname AS firstname_1, p0_.lastname AS lastname_2, p0_.email AS email_3, p0_.passwd AS passwd_4, p0_.last_passwd_gen AS last_passwd_gen_5, p0_.reset_password_token AS reset_password_token_6, p0_.reset_password_validity AS reset_password_validity_7, p0_.default_tab AS default_tab_8, p0_.active AS active_9, p0_.last_connection_date AS last_connection_date_10, p0_.has_enabled_gravatar AS has_enabled_gravatar_11, p0_.stats_date_from AS stats_date_from_12, p0_.stats_date_to AS stats_date_to_13, p0_.stats_compare_from AS stats_compare_from_14, p0_.stats_compare_to AS stats_compare_to_15, p0_.stats_compare_option AS stats_compare_option_16, p0_.preselect_date_range AS preselect_date_range_17, p0_.bo_color AS bo_color_18, p0_.bo_theme AS bo_theme_19, p0_.bo_css AS bo_css_20, p0_.bo_width AS bo_width_21, p0_.bo_menu AS bo_menu_22, p0_.optin AS optin_23, p0_.id_last_order AS id_last_order_24, p0_.id_last_customer_message AS id_last_customer_message_25, p0_.id_last_customer AS id_last_customer_26, p0_.id_employee AS id_employee_27, p0_.firstname AS firstname_28, p0_.lastname AS lastname_29, p0_.email AS email_30, p0_.passwd AS passwd_31, p0_.last_passwd_gen AS last_passwd_gen_32, p0_.reset_password_token AS reset_password_token_33, p0_.reset_password_validity AS reset_password_validity_34, p0_.default_tab AS default_tab_35, p0_.active AS active_36, p0_.last_connection_date AS last_connection_date_37, p0_.has_enabled_gravatar AS has_enabled_gravatar_38, p0_.stats_date_from AS stats_date_from_39, p0_.stats_date_to AS stats_date_to_40, p0_.stats_compare_from AS stats_compare_from_41, p0_.stats_compare_to AS stats_compare_to_42, p0_.stats_compare_option AS stats_compare_option_43, p0_.preselect_date_range AS preselect_date_range_44, p0_.bo_color AS bo_color_45, p0_.bo_theme AS bo_theme_46, p0_.bo_css AS bo_css_47, p0_.bo_width AS bo_width_48, p0_.bo_menu AS bo_menu_49, p0_.optin AS optin_50, p0_.id_last_order AS id_last_order_51, p0_.id_last_customer_message AS id_last_customer_message_52, p0_.id_last_customer AS id_last_customer_53, p1_.id_profile AS id_profile_54, p2_.id_lang AS id_lang_55, p2_.name AS name_56, p2_.active AS active_57, p2_.iso_code AS iso_code_58, p2_.language_code AS language_code_59, p2_.locale AS locale_60, p2_.date_format_lite AS date_format_lite_61, p2_.date_format_full AS date_format_full_62, p2_.is_rtl AS is_rtl_63, p3_.id_employee_session AS id_employee_session_64, p3_.token AS token_65, p3_.date_add AS date_add_66, p3_.date_upd AS date_upd_67, p0_.id_profile AS id_profile_68, p0_.id_lang AS id_lang_69, p3_.id_employee AS id_employee_70 FROM ps_employee p0_ LEFT JOIN ps_profile p1_ ON p0_.id_profile = p1_.id_profile LEFT JOIN ps_lang p2_ ON p0_.id_lang = p2_.id_lang LEFT JOIN ps_employee_session p3_ ON p0_.id_employee = p3_.id_employee WHERE p0_.email = 'presta19@cfabf-ndrc.fr';

SELECT
  t0.id_employee AS id_employee_1,
  t0.firstname AS firstname_2,
  t0.lastname AS lastname_3,
  t0.email AS email_4,
  t0.passwd AS passwd_5,
  t0.last_passwd_gen AS last_passwd_gen_6,
  t0.reset_password_token AS reset_password_token_7,
  t0.reset_password_validity AS reset_password_validity_8,
  t0.default_tab AS default_tab_9,
  t0.active AS active_10,
  t0.last_connection_date AS last_connection_date_11,
  t0.has_enabled_gravatar AS has_enabled_gravatar_12,
  t0.stats_date_from AS stats_date_from_13,
  t0.stats_date_to AS stats_date_to_14,
  t0.stats_compare_from AS stats_compare_from_15,
  t0.stats_compare_to AS stats_compare_to_16,
  t0.stats_compare_option AS stats_compare_option_17,
  t0.preselect_date_range AS preselect_date_range_18,
  t0.bo_color AS bo_color_19,
  t0.bo_theme AS bo_theme_20,
  t0.bo_css AS bo_css_21,
  t0.bo_width AS bo_width_22,
  t0.bo_menu AS bo_menu_23,
  t0.optin AS optin_24,
  t0.id_last_order AS id_last_order_25,
  t0.id_last_customer_message AS id_last_customer_message_26,
  t0.id_last_customer AS id_last_customer_27,
  t0.id_profile AS id_profile_28,
  t0.id_lang AS id_lang_29
FROM
  ps_employee t0
WHERE
  t0.id_employee = ?

SELECT t0.id_employee AS id_employee_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.email AS email_4, t0.passwd AS passwd_5, t0.last_passwd_gen AS last_passwd_gen_6, t0.reset_password_token AS reset_password_token_7, t0.reset_password_validity AS reset_password_validity_8, t0.default_tab AS default_tab_9, t0.active AS active_10, t0.last_connection_date AS last_connection_date_11, t0.has_enabled_gravatar AS has_enabled_gravatar_12, t0.stats_date_from AS stats_date_from_13, t0.stats_date_to AS stats_date_to_14, t0.stats_compare_from AS stats_compare_from_15, t0.stats_compare_to AS stats_compare_to_16, t0.stats_compare_option AS stats_compare_option_17, t0.preselect_date_range AS preselect_date_range_18, t0.bo_color AS bo_color_19, t0.bo_theme AS bo_theme_20, t0.bo_css AS bo_css_21, t0.bo_width AS bo_width_22, t0.bo_menu AS bo_menu_23, t0.optin AS optin_24, t0.id_last_order AS id_last_order_25, t0.id_last_customer_message AS id_last_customer_message_26, t0.id_last_customer AS id_last_customer_27, t0.id_profile AS id_profile_28, t0.id_lang AS id_lang_29 FROM ps_employee t0 WHERE t0.id_employee = 1;

SELECT
  t0.id_employee_session AS id_employee_session_1,
  t0.token AS token_2,
  t0.date_add AS date_add_3,
  t0.date_upd AS date_upd_4,
  t0.id_employee AS id_employee_5
FROM
  ps_employee_session t0
WHERE
  t0.id_employee = ?

SELECT t0.id_employee_session AS id_employee_session_1, t0.token AS token_2, t0.date_add AS date_add_3, t0.date_upd AS date_upd_4, t0.id_employee AS id_employee_5 FROM ps_employee_session t0 WHERE t0.id_employee = 1;

SELECT
  s.id_shop
FROM
  ps_shop s

SELECT s.id_shop FROM ps_shop s;

SELECT
  p0_.id_tab AS id_tab_0,
  p0_.class_name AS class_name_1
FROM
  ps_tab p0_
WHERE
  p0_.class_name = BINARY(?)
  AND p0_.id_tab <> 0

SELECT p0_.id_tab AS id_tab_0, p0_.class_name AS class_name_1 FROM ps_tab p0_ WHERE p0_.class_name = BINARY('AdminProducts') AND p0_.id_tab <> 0;

SELECT
  t0.id AS id_1,
  t0.employee AS employee_2,
  t0.shop AS shop_3,
  t0.controller AS controller_4,
  t0.action AS action_5,
  t0.filter AS filter_6,
  t0.filter_id AS filter_id_7
FROM
  ps_admin_filter t0
WHERE
  t0.employee = ?
  AND t0.shop = ?
  AND t0.filter_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.employee AS employee_2, t0.shop AS shop_3, t0.controller AS controller_4, t0.action AS action_5, t0.filter AS filter_6, t0.filter_id AS filter_id_7 FROM ps_admin_filter t0 WHERE t0.employee = 1 AND t0.shop = 1 AND t0.filter_id = 'product' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.employee AS employee_2,
  t0.shop AS shop_3,
  t0.controller AS controller_4,
  t0.action AS action_5,
  t0.filter AS filter_6,
  t0.filter_id AS filter_id_7
FROM
  ps_admin_filter t0
WHERE
  t0.employee = ?
  AND t0.shop = ?
  AND t0.filter_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.employee AS employee_2, t0.shop AS shop_3, t0.controller AS controller_4, t0.action AS action_5, t0.filter AS filter_6, t0.filter_id AS filter_id_7 FROM ps_admin_filter t0 WHERE t0.employee = 1 AND t0.shop = 1 AND t0.filter_id = 'product' LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO ps_admin_filter (
  employee, shop, controller, action,
  filter, filter_id
)
VALUES
  (?, ?, ?, ?, ?, ?)

INSERT INTO ps_admin_filter (employee, shop, controller, action, filter, filter_id) VALUES (1, 1, '', '', '{\"limit\":20,\"orderBy\":\"id_product\",\"sortOrder\":\"desc\",\"filters\":[]}', 'product');

"COMMIT"

"COMMIT";

SELECT
  s.id_shop_group
FROM
  ps_shop s
WHERE
  s.id_shop = :shopId

SELECT s.id_shop_group FROM ps_shop s WHERE s.id_shop = 1;

SELECT
  s.id_shop_group
FROM
  ps_shop s
WHERE
  s.id_shop = :shopId

SELECT s.id_shop_group FROM ps_shop s WHERE s.id_shop = 1;

SELECT
  p.`id_product`,
  p.`reference`,
  p.`id_shop_default`,
  ps.`price` AS `price_tax_excluded`,
  ps.`ecotax` AS `ecotax_tax_excluded`,
  ps.`id_tax_rules_group`,
  ps.`active`,
  pl.`name`,
  pl.`link_rewrite`,
  cl.`name` AS `category`,
  img_shop.`id_image`,
  img_lang.legend,
  p.`id_tax_rules_group`,
  (ps.`price` + ps.`ecotax`) AS `final_price_tax_excluded`,
  IF(
    sa.`quantity` IS NULL
    OR sa.`quantity` = '',
    0,
    sa.`quantity`
  ) AS quantity
FROM
  ps_product p
  INNER JOIN ps_product_shop ps ON ps.`id_product` = p.`id_product`
  AND ps.`id_shop` = :shopId
  LEFT JOIN ps_shop s ON s.`id_shop` = ps.`id_shop`
  LEFT JOIN ps_product_lang pl ON pl.`id_product` = p.`id_product`
  AND pl.`id_lang` = :langId
  AND pl.`id_shop` = :shopId
  LEFT JOIN ps_stock_available sa ON sa.`id_product` = p.`id_product`
  AND sa.`id_product_attribute` = 0
  AND sa.`id_shop` = :shopId
  LEFT JOIN ps_category_lang cl ON cl.`id_category` = ps.`id_category_default`
  AND cl.`id_lang` = :langId
  AND cl.`id_shop` = :shopId
  LEFT JOIN ps_image_shop img_shop ON img_shop.`id_product` = ps.`id_product`
  AND img_shop.`cover` = 1
  AND img_shop.`id_shop` = :shopId
  LEFT JOIN ps_image_lang img_lang ON img_shop.`id_image` = img_lang.`id_image`
  AND img_lang.`id_lang` = :langId
WHERE
  p.`state` = 1
ORDER BY
  id_product desc
LIMIT
  20

SELECT p.`id_product`, p.`reference`, p.`id_shop_default`, ps.`price` AS `price_tax_excluded`, ps.`ecotax` AS `ecotax_tax_excluded`, ps.`id_tax_rules_group`, ps.`active`, pl.`name`, pl.`link_rewrite`, cl.`name` AS `category`, img_shop.`id_image`, img_lang.legend, p.`id_tax_rules_group`, (ps.`price` + ps.`ecotax`) AS `final_price_tax_excluded`, IF(sa.`quantity` IS NULL OR sa.`quantity` = '', 0, sa.`quantity`) AS quantity FROM ps_product p INNER JOIN ps_product_shop ps ON ps.`id_product` = p.`id_product` AND ps.`id_shop` = 1 LEFT JOIN ps_shop s ON s.`id_shop` = ps.`id_shop` LEFT JOIN ps_product_lang pl ON pl.`id_product` = p.`id_product` AND pl.`id_lang` = 1 AND pl.`id_shop` = 1 LEFT JOIN ps_stock_available sa ON sa.`id_product` = p.`id_product`
            AND sa.`id_product_attribute` = 0
         AND sa.`id_shop` = 1 LEFT JOIN ps_category_lang cl ON cl.`id_category` = ps.`id_category_default` AND cl.`id_lang` = 1 AND cl.`id_shop` = 1 LEFT JOIN ps_image_shop img_shop ON img_shop.`id_product` = ps.`id_product` AND img_shop.`cover` = 1 AND img_shop.`id_shop` = 1 LEFT JOIN ps_image_lang img_lang ON img_shop.`id_image` = img_lang.`id_image` AND img_lang.`id_lang` = 1 WHERE p.`state` = 1 ORDER BY id_product desc LIMIT 20;

SELECT
  COUNT(p.`id_product`)
FROM
  ps_product p
  INNER JOIN ps_product_shop ps ON ps.`id_product` = p.`id_product`
  AND ps.`id_shop` = :shopId
  LEFT JOIN ps_shop s ON s.`id_shop` = ps.`id_shop`
  LEFT JOIN ps_product_lang pl ON pl.`id_product` = p.`id_product`
  AND pl.`id_lang` = :langId
  AND pl.`id_shop` = :shopId
  LEFT JOIN ps_stock_available sa ON sa.`id_product` = p.`id_product`
  AND sa.`id_product_attribute` = 0
  AND sa.`id_shop` = :shopId
  LEFT JOIN ps_category_lang cl ON cl.`id_category` = ps.`id_category_default`
  AND cl.`id_lang` = :langId
  AND cl.`id_shop` = :shopId
  LEFT JOIN ps_image_shop img_shop ON img_shop.`id_product` = ps.`id_product`
  AND img_shop.`cover` = 1
  AND img_shop.`id_shop` = :shopId
  LEFT JOIN ps_image_lang img_lang ON img_shop.`id_image` = img_lang.`id_image`
  AND img_lang.`id_lang` = :langId
WHERE
  p.`state` = 1

SELECT COUNT(p.`id_product`) FROM ps_product p INNER JOIN ps_product_shop ps ON ps.`id_product` = p.`id_product` AND ps.`id_shop` = 1 LEFT JOIN ps_shop s ON s.`id_shop` = ps.`id_shop` LEFT JOIN ps_product_lang pl ON pl.`id_product` = p.`id_product` AND pl.`id_lang` = 1 AND pl.`id_shop` = 1 LEFT JOIN ps_stock_available sa ON sa.`id_product` = p.`id_product`
            AND sa.`id_product_attribute` = 0
         AND sa.`id_shop` = 1 LEFT JOIN ps_category_lang cl ON cl.`id_category` = ps.`id_category_default` AND cl.`id_lang` = 1 AND cl.`id_shop` = 1 LEFT JOIN ps_image_shop img_shop ON img_shop.`id_product` = ps.`id_product` AND img_shop.`cover` = 1 AND img_shop.`id_shop` = 1 LEFT JOIN ps_image_lang img_lang ON img_shop.`id_image` = img_lang.`id_image` AND img_lang.`id_lang` = 1 WHERE p.`state` = 1;

SELECT
  tr.id_state
FROM
  ps_tax_rules_group trg
  INNER JOIN ps_tax_rule tr ON tr.id_tax_rules_group = trg.id_tax_rules_group
  INNER JOIN ps_tax t ON t.id_tax = tr.id_tax
WHERE
  (
    trg.id_tax_rules_group = :taxRulesGroupId
  )
  AND (tr.id_country = :countryId)
  AND (trg.deleted = 0)

SELECT tr.id_state FROM ps_tax_rules_group trg INNER JOIN ps_tax_rule tr ON tr.id_tax_rules_group = trg.id_tax_rules_group INNER JOIN ps_tax t ON t.id_tax = tr.id_tax WHERE (trg.id_tax_rules_group = 1) AND (tr.id_country = 8) AND (trg.deleted = 0);

SELECT
  tr.id_state
FROM
  ps_tax_rules_group trg
  INNER JOIN ps_tax_rule tr ON tr.id_tax_rules_group = trg.id_tax_rules_group
  INNER JOIN ps_tax t ON t.id_tax = tr.id_tax
WHERE
  (
    trg.id_tax_rules_group = :taxRulesGroupId
  )
  AND (tr.id_country = :countryId)
  AND (trg.deleted = 0)

SELECT tr.id_state FROM ps_tax_rules_group trg INNER JOIN ps_tax_rule tr ON tr.id_tax_rules_group = trg.id_tax_rules_group INNER JOIN ps_tax t ON t.id_tax = tr.id_tax WHERE (trg.id_tax_rules_group = 0) AND (tr.id_country = 8) AND (trg.deleted = 0);

SELECT
  tr.id_state
FROM
  ps_tax_rules_group trg
  INNER JOIN ps_tax_rule tr ON tr.id_tax_rules_group = trg.id_tax_rules_group
  INNER JOIN ps_tax t ON t.id_tax = tr.id_tax
WHERE
  (
    trg.id_tax_rules_group = :taxRulesGroupId
  )
  AND (tr.id_country = :countryId)
  AND (trg.deleted = 0)

SELECT tr.id_state FROM ps_tax_rules_group trg INNER JOIN ps_tax_rule tr ON tr.id_tax_rules_group = trg.id_tax_rules_group INNER JOIN ps_tax t ON t.id_tax = tr.id_tax WHERE (trg.id_tax_rules_group = 1) AND (tr.id_country = 8) AND (trg.deleted = 0);

SELECT
  tr.id_state
FROM
  ps_tax_rules_group trg
  INNER JOIN ps_tax_rule tr ON tr.id_tax_rules_group = trg.id_tax_rules_group
  INNER JOIN ps_tax t ON t.id_tax = tr.id_tax
WHERE
  (
    trg.id_tax_rules_group = :taxRulesGroupId
  )
  AND (tr.id_country = :countryId)
  AND (trg.deleted = 0)

SELECT tr.id_state FROM ps_tax_rules_group trg INNER JOIN ps_tax_rule tr ON tr.id_tax_rules_group = trg.id_tax_rules_group INNER JOIN ps_tax t ON t.id_tax = tr.id_tax WHERE (trg.id_tax_rules_group = 0) AND (tr.id_country = 8) AND (trg.deleted = 0);

SELECT
  tr.id_state
FROM
  ps_tax_rules_group trg
  INNER JOIN ps_tax_rule tr ON tr.id_tax_rules_group = trg.id_tax_rules_group
  INNER JOIN ps_tax t ON t.id_tax = tr.id_tax
WHERE
  (
    trg.id_tax_rules_group = :taxRulesGroupId
  )
  AND (tr.id_country = :countryId)
  AND (trg.deleted = 0)

SELECT tr.id_state FROM ps_tax_rules_group trg INNER JOIN ps_tax_rule tr ON tr.id_tax_rules_group = trg.id_tax_rules_group INNER JOIN ps_tax t ON t.id_tax = tr.id_tax WHERE (trg.id_tax_rules_group = 1) AND (tr.id_country = 8) AND (trg.deleted = 0);

SELECT
  tr.id_state
FROM
  ps_tax_rules_group trg
  INNER JOIN ps_tax_rule tr ON tr.id_tax_rules_group = trg.id_tax_rules_group
  INNER JOIN ps_tax t ON t.id_tax = tr.id_tax
WHERE
  (
    trg.id_tax_rules_group = :taxRulesGroupId
  )
  AND (tr.id_country = :countryId)
  AND (trg.deleted = 0)

SELECT tr.id_state FROM ps_tax_rules_group trg INNER JOIN ps_tax_rule tr ON tr.id_tax_rules_group = trg.id_tax_rules_group INNER JOIN ps_tax t ON t.id_tax = tr.id_tax WHERE (trg.id_tax_rules_group = 0) AND (tr.id_country = 8) AND (trg.deleted = 0);

SELECT
  tr.id_state
FROM
  ps_tax_rules_group trg
  INNER JOIN ps_tax_rule tr ON tr.id_tax_rules_group = trg.id_tax_rules_group
  INNER JOIN ps_tax t ON t.id_tax = tr.id_tax
WHERE
  (
    trg.id_tax_rules_group = :taxRulesGroupId
  )
  AND (tr.id_country = :countryId)
  AND (trg.deleted = 0)

SELECT tr.id_state FROM ps_tax_rules_group trg INNER JOIN ps_tax_rule tr ON tr.id_tax_rules_group = trg.id_tax_rules_group INNER JOIN ps_tax t ON t.id_tax = tr.id_tax WHERE (trg.id_tax_rules_group = 1) AND (tr.id_country = 8) AND (trg.deleted = 0);

SELECT
  tr.id_state
FROM
  ps_tax_rules_group trg
  INNER JOIN ps_tax_rule tr ON tr.id_tax_rules_group = trg.id_tax_rules_group
  INNER JOIN ps_tax t ON t.id_tax = tr.id_tax
WHERE
  (
    trg.id_tax_rules_group = :taxRulesGroupId
  )
  AND (tr.id_country = :countryId)
  AND (trg.deleted = 0)

SELECT tr.id_state FROM ps_tax_rules_group trg INNER JOIN ps_tax_rule tr ON tr.id_tax_rules_group = trg.id_tax_rules_group INNER JOIN ps_tax t ON t.id_tax = tr.id_tax WHERE (trg.id_tax_rules_group = 0) AND (tr.id_country = 8) AND (trg.deleted = 0);

SELECT
  tr.id_state
FROM
  ps_tax_rules_group trg
  INNER JOIN ps_tax_rule tr ON tr.id_tax_rules_group = trg.id_tax_rules_group
  INNER JOIN ps_tax t ON t.id_tax = tr.id_tax
WHERE
  (
    trg.id_tax_rules_group = :taxRulesGroupId
  )
  AND (tr.id_country = :countryId)
  AND (trg.deleted = 0)

SELECT tr.id_state FROM ps_tax_rules_group trg INNER JOIN ps_tax_rule tr ON tr.id_tax_rules_group = trg.id_tax_rules_group INNER JOIN ps_tax t ON t.id_tax = tr.id_tax WHERE (trg.id_tax_rules_group = 1) AND (tr.id_country = 8) AND (trg.deleted = 0);

SELECT
  tr.id_state
FROM
  ps_tax_rules_group trg
  INNER JOIN ps_tax_rule tr ON tr.id_tax_rules_group = trg.id_tax_rules_group
  INNER JOIN ps_tax t ON t.id_tax = tr.id_tax
WHERE
  (
    trg.id_tax_rules_group = :taxRulesGroupId
  )
  AND (tr.id_country = :countryId)
  AND (trg.deleted = 0)

SELECT tr.id_state FROM ps_tax_rules_group trg INNER JOIN ps_tax_rule tr ON tr.id_tax_rules_group = trg.id_tax_rules_group INNER JOIN ps_tax t ON t.id_tax = tr.id_tax WHERE (trg.id_tax_rules_group = 0) AND (tr.id_country = 8) AND (trg.deleted = 0);

SELECT
  tr.id_state
FROM
  ps_tax_rules_group trg
  INNER JOIN ps_tax_rule tr ON tr.id_tax_rules_group = trg.id_tax_rules_group
  INNER JOIN ps_tax t ON t.id_tax = tr.id_tax
WHERE
  (
    trg.id_tax_rules_group = :taxRulesGroupId
  )
  AND (tr.id_country = :countryId)
  AND (trg.deleted = 0)

SELECT tr.id_state FROM ps_tax_rules_group trg INNER JOIN ps_tax_rule tr ON tr.id_tax_rules_group = trg.id_tax_rules_group INNER JOIN ps_tax t ON t.id_tax = tr.id_tax WHERE (trg.id_tax_rules_group = 1) AND (tr.id_country = 8) AND (trg.deleted = 0);

SELECT
  tr.id_state
FROM
  ps_tax_rules_group trg
  INNER JOIN ps_tax_rule tr ON tr.id_tax_rules_group = trg.id_tax_rules_group
  INNER JOIN ps_tax t ON t.id_tax = tr.id_tax
WHERE
  (
    trg.id_tax_rules_group = :taxRulesGroupId
  )
  AND (tr.id_country = :countryId)
  AND (trg.deleted = 0)

SELECT tr.id_state FROM ps_tax_rules_group trg INNER JOIN ps_tax_rule tr ON tr.id_tax_rules_group = trg.id_tax_rules_group INNER JOIN ps_tax t ON t.id_tax = tr.id_tax WHERE (trg.id_tax_rules_group = 0) AND (tr.id_country = 8) AND (trg.deleted = 0);

SELECT
  tr.id_state
FROM
  ps_tax_rules_group trg
  INNER JOIN ps_tax_rule tr ON tr.id_tax_rules_group = trg.id_tax_rules_group
  INNER JOIN ps_tax t ON t.id_tax = tr.id_tax
WHERE
  (
    trg.id_tax_rules_group = :taxRulesGroupId
  )
  AND (tr.id_country = :countryId)
  AND (trg.deleted = 0)

SELECT tr.id_state FROM ps_tax_rules_group trg INNER JOIN ps_tax_rule tr ON tr.id_tax_rules_group = trg.id_tax_rules_group INNER JOIN ps_tax t ON t.id_tax = tr.id_tax WHERE (trg.id_tax_rules_group = 1) AND (tr.id_country = 8) AND (trg.deleted = 0);

SELECT
  tr.id_state
FROM
  ps_tax_rules_group trg
  INNER JOIN ps_tax_rule tr ON tr.id_tax_rules_group = trg.id_tax_rules_group
  INNER JOIN ps_tax t ON t.id_tax = tr.id_tax
WHERE
  (
    trg.id_tax_rules_group = :taxRulesGroupId
  )
  AND (tr.id_country = :countryId)
  AND (trg.deleted = 0)

SELECT tr.id_state FROM ps_tax_rules_group trg INNER JOIN ps_tax_rule tr ON tr.id_tax_rules_group = trg.id_tax_rules_group INNER JOIN ps_tax t ON t.id_tax = tr.id_tax WHERE (trg.id_tax_rules_group = 0) AND (tr.id_country = 8) AND (trg.deleted = 0);

SELECT
  tr.id_state
FROM
  ps_tax_rules_group trg
  INNER JOIN ps_tax_rule tr ON tr.id_tax_rules_group = trg.id_tax_rules_group
  INNER JOIN ps_tax t ON t.id_tax = tr.id_tax
WHERE
  (
    trg.id_tax_rules_group = :taxRulesGroupId
  )
  AND (tr.id_country = :countryId)
  AND (trg.deleted = 0)

SELECT tr.id_state FROM ps_tax_rules_group trg INNER JOIN ps_tax_rule tr ON tr.id_tax_rules_group = trg.id_tax_rules_group INNER JOIN ps_tax t ON t.id_tax = tr.id_tax WHERE (trg.id_tax_rules_group = 1) AND (tr.id_country = 8) AND (trg.deleted = 0);

SELECT
  tr.id_state
FROM
  ps_tax_rules_group trg
  INNER JOIN ps_tax_rule tr ON tr.id_tax_rules_group = trg.id_tax_rules_group
  INNER JOIN ps_tax t ON t.id_tax = tr.id_tax
WHERE
  (
    trg.id_tax_rules_group = :taxRulesGroupId
  )
  AND (tr.id_country = :countryId)
  AND (trg.deleted = 0)

SELECT tr.id_state FROM ps_tax_rules_group trg INNER JOIN ps_tax_rule tr ON tr.id_tax_rules_group = trg.id_tax_rules_group INNER JOIN ps_tax t ON t.id_tax = tr.id_tax WHERE (trg.id_tax_rules_group = 0) AND (tr.id_country = 8) AND (trg.deleted = 0);

SELECT
  tr.id_state
FROM
  ps_tax_rules_group trg
  INNER JOIN ps_tax_rule tr ON tr.id_tax_rules_group = trg.id_tax_rules_group
  INNER JOIN ps_tax t ON t.id_tax = tr.id_tax
WHERE
  (
    trg.id_tax_rules_group = :taxRulesGroupId
  )
  AND (tr.id_country = :countryId)
  AND (trg.deleted = 0)

SELECT tr.id_state FROM ps_tax_rules_group trg INNER JOIN ps_tax_rule tr ON tr.id_tax_rules_group = trg.id_tax_rules_group INNER JOIN ps_tax t ON t.id_tax = tr.id_tax WHERE (trg.id_tax_rules_group = 1) AND (tr.id_country = 8) AND (trg.deleted = 0);

SELECT
  tr.id_state
FROM
  ps_tax_rules_group trg
  INNER JOIN ps_tax_rule tr ON tr.id_tax_rules_group = trg.id_tax_rules_group
  INNER JOIN ps_tax t ON t.id_tax = tr.id_tax
WHERE
  (
    trg.id_tax_rules_group = :taxRulesGroupId
  )
  AND (tr.id_country = :countryId)
  AND (trg.deleted = 0)

SELECT tr.id_state FROM ps_tax_rules_group trg INNER JOIN ps_tax_rule tr ON tr.id_tax_rules_group = trg.id_tax_rules_group INNER JOIN ps_tax t ON t.id_tax = tr.id_tax WHERE (trg.id_tax_rules_group = 0) AND (tr.id_country = 8) AND (trg.deleted = 0);

SELECT
  tr.id_state
FROM
  ps_tax_rules_group trg
  INNER JOIN ps_tax_rule tr ON tr.id_tax_rules_group = trg.id_tax_rules_group
  INNER JOIN ps_tax t ON t.id_tax = tr.id_tax
WHERE
  (
    trg.id_tax_rules_group = :taxRulesGroupId
  )
  AND (tr.id_country = :countryId)
  AND (trg.deleted = 0)

SELECT tr.id_state FROM ps_tax_rules_group trg INNER JOIN ps_tax_rule tr ON tr.id_tax_rules_group = trg.id_tax_rules_group INNER JOIN ps_tax t ON t.id_tax = tr.id_tax WHERE (trg.id_tax_rules_group = 1) AND (tr.id_country = 8) AND (trg.deleted = 0);

SELECT
  tr.id_state
FROM
  ps_tax_rules_group trg
  INNER JOIN ps_tax_rule tr ON tr.id_tax_rules_group = trg.id_tax_rules_group
  INNER JOIN ps_tax t ON t.id_tax = tr.id_tax
WHERE
  (
    trg.id_tax_rules_group = :taxRulesGroupId
  )
  AND (tr.id_country = :countryId)
  AND (trg.deleted = 0)

SELECT tr.id_state FROM ps_tax_rules_group trg INNER JOIN ps_tax_rule tr ON tr.id_tax_rules_group = trg.id_tax_rules_group INNER JOIN ps_tax t ON t.id_tax = tr.id_tax WHERE (trg.id_tax_rules_group = 0) AND (tr.id_country = 8) AND (trg.deleted = 0);