Limit (cost=11.56..11.57 rows=1 width=3162) |
-> Sort (cost=11.56..11.57 rows=1 width=3162) |
Sort Key: index, current_join_count DESC |
-> Seq Scan on promotion (cost=0.00..11.55 rows=1 width=3162) |
Filter: (((start_date)::text <= '2025-04-23'::text) AND ((end_date)::text >= '2025-04-23'::text) AND ((start_time)::text <= '00:20'::text) AND ((end_time)::text >= '00:20'::text) AND (is_deleted = 0) AND (is_active = 1)) |