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" =10
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" =10
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" =34755
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" =34757
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" =34759
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" =34761
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" =34765
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" =34766
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" =34767
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" =34768
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" =34769
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" =34770
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" =34771
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" =34772
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'