{"ok":true,"cached":true,"plan":{"sql":"SELECT full_name, title, total_users_30d, runs30_total, hard_failure_rate, months_since_modified, opportunity_score, CASE WHEN pricing_model = 'FREE' OR COALESCE(price_usd, 0) <= 0 THEN 0.0 WHEN pricing_model = 'FLAT_PRICE_PER_MONTH' THEN COALESCE(total_users_30d, 0) * 0.15 * COALESCE(price_usd, 0) WHEN pricing_model = 'PRICE_PER_DATASET_ITEM' THEN (COALESCE(runs30_total, 0) * (1 - LEAST(GREATEST(COALESCE(hard_failure_rate, 0), 0), 1))) * 50 * COALESCE(price_usd, 0) * 0.80 WHEN pricing_model = 'PAY_PER_EVENT' THEN CASE WHEN CASE WHEN COALESCE(price_usd, 0) >= 10 THEN COALESCE(total_users_30d, 0) * 1 * COALESCE(price_usd, 0) * 0.80 WHEN COALESCE(price_usd, 0) >= 1 THEN COALESCE(total_users_30d, 0) * 10 * COALESCE(price_usd, 0) * 0.80 ELSE NULL END IS NULL THEN ((COALESCE(runs30_total, 0) * (1 - LEAST(GREATEST(COALESCE(hard_failure_rate, 0), 0), 1))) * CASE WHEN COALESCE(price_usd, 0) >= 1 THEN 1 WHEN COALESCE(price_usd, 0) >= 0.1 THEN 2 WHEN COALESCE(price_usd, 0) >= 0.01 THEN 10 ELSE 50 END * COALESCE(price_usd, 0) * 0.80) ELSE LEAST(((COALESCE(runs30_total, 0) * (1 - LEAST(GREATEST(COALESCE(hard_failure_rate, 0), 0), 1))) * CASE WHEN COALESCE(price_usd, 0) >= 1 THEN 1 WHEN COALESCE(price_usd, 0) >= 0.1 THEN 2 WHEN COALESCE(price_usd, 0) >= 0.01 THEN 10 ELSE 50 END * COALESCE(price_usd, 0) * 0.80), CASE WHEN COALESCE(price_usd, 0) >= 10 THEN COALESCE(total_users_30d, 0) * 1 * COALESCE(price_usd, 0) * 0.80 WHEN COALESCE(price_usd, 0) >= 1 THEN COALESCE(total_users_30d, 0) * 10 * COALESCE(price_usd, 0) * 0.80 ELSE NULL END) END ELSE 0.0 END AS est_monthly_revenue, pricing_model, allows_agentic_users, categories, target_platform, volatility_risk, url, (detail_embedding <=> '<qvec>'::vector) AS distance FROM apify.actor WHERE detail_embedding IS NOT NULL ORDER BY detail_embedding <=> '<qvec>'::vector LIMIT 5","mode":"vector","notes":["sql path failed (DatabaseError: {'S': 'ERROR', 'V': 'ERROR', 'C': '42803', 'M': 'column \"actor.detail_embedding\" must appear in the GROUP BY clause or be used in an aggregate function', 'P': '415', 'F': 'parse_agg.c', 'L': '1439', 'R': 'check_ungrouped_columns_walker'}); fell back to vector"],"rationale":"pg vector path (Text-to-SQL / vector over pgvector)"},"results":[{"key":"https://apify.com/clearpath/leboncoin-acheteur","url":"https://apify.com/clearpath/leboncoin-acheteur","score":0.6122,"title":"clearpath/leboncoin-acheteur","runs_30d":5371,"users_30d":10,"categories":"[\"ECOMMERCE\", \"LEAD_GENERATION\", \"AUTOMATION\"]","pricing_model":"PAY_PER_EVENT","hard_failure_rate":0.487805,"opportunity_score":0.0396,"allowsAgenticUsers":true,"months_since_modified":0,"estimated_monthly_revenue":232},{"key":"https://apify.com/silentflow/leboncoin-scraper-ppr","url":"https://apify.com/silentflow/leboncoin-scraper-ppr","score":0.541,"title":"silentflow/leboncoin-scraper-ppr","runs_30d":1276,"users_30d":43,"categories":"[\"REAL_ESTATE\", \"ECOMMERCE\", \"LEAD_GENERATION\"]","pricing_model":"PAY_PER_EVENT","hard_failure_rate":0.0023511,"opportunity_score":0.0436,"allowsAgenticUsers":true,"months_since_modified":2.20105,"estimated_monthly_revenue":76.3800006726943},{"key":"https://apify.com/clearpath/leboncoin-api","url":"https://apify.com/clearpath/leboncoin-api","score":0.5389,"title":"clearpath/leboncoin-api","runs_30d":1944,"users_30d":19,"categories":"[\"ECOMMERCE\", \"AUTOMATION\", \"REAL_ESTATE\"]","pricing_model":"FLAT_PRICE_PER_MONTH","hard_failure_rate":0.0828189,"opportunity_score":0.0432,"allowsAgenticUsers":false,"months_since_modified":0,"estimated_monthly_revenue":111.15},{"key":"https://apify.com/consummate_joy/leboncoin-messenger","url":"https://apify.com/consummate_joy/leboncoin-messenger","score":0.5385,"title":"consummate_joy/leboncoin-messenger","runs_30d":6,"users_30d":4,"categories":"[\"AUTOMATION\", \"ECOMMERCE\", \"LEAD_GENERATION\"]","pricing_model":"PAY_PER_EVENT","hard_failure_rate":0.833333,"opportunity_score":0.0248,"allowsAgenticUsers":false,"months_since_modified":0.985545,"estimated_monthly_revenue":0.400000053644181},{"key":"https://apify.com/parseforge/leboncoin-scraper","url":"https://apify.com/parseforge/leboncoin-scraper","score":0.5258,"title":"parseforge/leboncoin-scraper","runs_30d":71,"users_30d":3,"categories":"[\"ECOMMERCE\", \"LEAD_GENERATION\", \"OTHER\"]","pricing_model":"PAY_PER_EVENT","hard_failure_rate":0.0985916,"opportunity_score":0.0292,"allowsAgenticUsers":true,"months_since_modified":1.0841,"estimated_monthly_revenue":12.7999996870756}],"answer":null,"meta":{"q":"clearpath/leboncoin-acheteur","mode":"query","view":"auto","page":1,"limit":10}}