selectcount(*) as aggregate from "products" leftjoin "issue_years" on "issue_years"."id" = "products"."issue_year_id" where "products"."is_active" ='Y'and "products"."sub_category_id" =16
selectcount(*) as aggregate from "products" leftjoin "issue_years" on "issue_years"."id" = "products"."issue_year_id" where "products"."is_active" ='Y'and "products"."sub_category_id" =16
select "issue_years".*, "product_to_issue_years"."product_id" as "pivot_product_id", "product_to_issue_years"."issue_year_id" as "pivot_issue_year_id" from "issue_years" innerjoin "product_to_issue_years" on "issue_years"."id" = "product_to_issue_years"."issue_year_id" where "product_to_issue_years"."product_id" =35017
select "issue_years".*, "product_to_issue_years"."product_id" as "pivot_product_id", "product_to_issue_years"."issue_year_id" as "pivot_issue_year_id" from "issue_years" innerjoin "product_to_issue_years" on "issue_years"."id" = "product_to_issue_years"."issue_year_id" where "product_to_issue_years"."product_id" =35019
select "issue_years".*, "product_to_issue_years"."product_id" as "pivot_product_id", "product_to_issue_years"."issue_year_id" as "pivot_issue_year_id" from "issue_years" innerjoin "product_to_issue_years" on "issue_years"."id" = "product_to_issue_years"."issue_year_id" where "product_to_issue_years"."product_id" =35021
select "issue_years".*, "product_to_issue_years"."product_id" as "pivot_product_id", "product_to_issue_years"."issue_year_id" as "pivot_issue_year_id" from "issue_years" innerjoin "product_to_issue_years" on "issue_years"."id" = "product_to_issue_years"."issue_year_id" where "product_to_issue_years"."product_id" =35023
select "issue_years".*, "product_to_issue_years"."product_id" as "pivot_product_id", "product_to_issue_years"."issue_year_id" as "pivot_issue_year_id" from "issue_years" innerjoin "product_to_issue_years" on "issue_years"."id" = "product_to_issue_years"."issue_year_id" where "product_to_issue_years"."product_id" =35024
select "issue_years".*, "product_to_issue_years"."product_id" as "pivot_product_id", "product_to_issue_years"."issue_year_id" as "pivot_issue_year_id" from "issue_years" innerjoin "product_to_issue_years" on "issue_years"."id" = "product_to_issue_years"."issue_year_id" where "product_to_issue_years"."product_id" =35026
select "issue_years".*, "product_to_issue_years"."product_id" as "pivot_product_id", "product_to_issue_years"."issue_year_id" as "pivot_issue_year_id" from "issue_years" innerjoin "product_to_issue_years" on "issue_years"."id" = "product_to_issue_years"."issue_year_id" where "product_to_issue_years"."product_id" =35027
select "issue_years".*, "product_to_issue_years"."product_id" as "pivot_product_id", "product_to_issue_years"."issue_year_id" as "pivot_issue_year_id" from "issue_years" innerjoin "product_to_issue_years" on "issue_years"."id" = "product_to_issue_years"."issue_year_id" where "product_to_issue_years"."product_id" =35028
select "issue_years".*, "product_to_issue_years"."product_id" as "pivot_product_id", "product_to_issue_years"."issue_year_id" as "pivot_issue_year_id" from "issue_years" innerjoin "product_to_issue_years" on "issue_years"."id" = "product_to_issue_years"."issue_year_id" where "product_to_issue_years"."product_id" =24337
select "issue_years".*, "product_to_issue_years"."product_id" as "pivot_product_id", "product_to_issue_years"."issue_year_id" as "pivot_issue_year_id" from "issue_years" innerjoin "product_to_issue_years" on "issue_years"."id" = "product_to_issue_years"."issue_year_id" where "product_to_issue_years"."product_id" =24338
select "issue_years".*, "product_to_issue_years"."product_id" as "pivot_product_id", "product_to_issue_years"."issue_year_id" as "pivot_issue_year_id" from "issue_years" innerjoin "product_to_issue_years" on "issue_years"."id" = "product_to_issue_years"."issue_year_id" where "product_to_issue_years"."product_id" =35485
select "issue_years".*, "product_to_issue_years"."product_id" as "pivot_product_id", "product_to_issue_years"."issue_year_id" as "pivot_issue_year_id" from "issue_years" innerjoin "product_to_issue_years" on "issue_years"."id" = "product_to_issue_years"."issue_year_id" where "product_to_issue_years"."product_id" =35486
select "sub_categories".*, "category_to_subcategory"."category_id" as "pivot_category_id", "category_to_subcategory"."sub_category_id" as "pivot_sub_category_id" from "sub_categories" innerjoin "category_to_subcategory" on "sub_categories"."id" = "category_to_subcategory"."sub_category_id" where "category_to_subcategory"."category_id" in (1, 2, 3, 4, 5, 6, 7, 9) and "is_active" ='Y'