Search failed: Failed query: select "listings"."id", "listings"."vendor_id", "listings"."title", "listings"."slug", "listings"."description", "listings"."external_sku", "listings"."design_file_url", "listings"."design_file_key", "listings"."thumbnail_url", "listings"."preview_url", "listings"."design_width_px", "listings"."design_height_px", "listings"."design_hash", "listings"."is_digital", "listings"."digital_file_key", "listings"."digital_file_format", "listings"."digital_file_size_mb", "listings"."category_id", "listings"."tags", "listings"."status", "listings"."rejection_reason", "listings"."feed_excluded", "listings"."meta_title", "listings"."meta_description", "listings"."sales_count", "listings"."view_count", "listings"."review_count", "listings"."average_rating", "listings"."created_at", "listings"."updated_at", "listings"."merchant_sync_updated_at", "listings_vendor"."data" as "vendor", "listings_products"."data" as "products", "listings_category"."data" as "category" from "listings" "listings" left join lateral (select json_build_array("listings_vendor"."id", "listings_vendor"."store_name", "listings_vendor"."store_slug") as "data" from (select * from "vendors" "listings_vendor" where "listings_vendor"."id" = "listings"."vendor_id" limit $1) "listings_vendor") "listings_vendor" on true left join lateral (select coalesce(json_agg(json_build_array("listings_products"."customer_price", "listings_products"."is_active", "listings_products"."product_id", "listings_products"."mockup_url", "listings_products_product"."data")), '[]'::json) as "data" from "listing_products" "listings_products" left join lateral (select json_build_array("listings_products_product"."id", "listings_products_product"."name", "listings_products_product"."size_pricing", "listings_products_product"."available_sizes", "listings_products_product"."available_colors", "listings_products_product"."external_sku", "listings_products_product"."is_active") as "data" from (select * from "product_catalog" "listings_products_product" where "listings_products_product"."id" = "listings_products"."product_id" limit $2) "listings_products_product") "listings_products_product" on true where ("listings_products"."listing_id" = "listings"."id" and "listings_products"."is_active" = $3)) "listings_products" on true left join lateral (select json_build_array("listings_category"."name", "listings_category"."slug") as "data" from (select * from "categories" "listings_category" where "listings_category"."id" = "listings"."category_id" limit $4) "listings_category") "listings_category" on true where ("listings"."status" = $5 and "listings"."thumbnail_url" <> '' AND "listings"."thumbnail_url" LIKE 'http%' and EXISTS (SELECT 1 FROM listing_products lp WHERE lp.listing_id = "listings"."id" AND lp.is_active = true) and ("listings"."title" ilike $6 or "listings"."description" ilike $7)) order by "listings"."view_count" + GREATEST(0, 50.0 * (1.0 - EXTRACT(EPOCH FROM (now() - "listings"."created_at")) / (30 * 86400))) desc limit $8 params: 1,1,true,1,active,%holiday-office-parties%,%holiday-office-parties%,100