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" in (61129)
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" =61129orderby "issue_year_id" desc limit 1
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" =61129orderby "issue_year_id" asc limit 1
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'