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" =62447
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" =2203
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" =80739
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" =2204
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" =2205
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" =2206
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" =2207
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" =2208
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" =27974
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" =1155
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" =1156
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" =1157
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'