selectcount(*) as aggregate from "products" leftjoin "issue_years" on "issue_years"."id" = "products"."issue_year_id" where "products"."is_active" ='Y'
selectcount(*) as aggregate from "products" leftjoin "issue_years" on "issue_years"."id" = "products"."issue_year_id" where "products"."is_active" ='Y'
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" =68041
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" =28202
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" =28204
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" =41901
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" =41902
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" =67659
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" =67660
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" =28208
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" =41903
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" =41904
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" =1482
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" =1483
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'