SELECT
    COUNT(*) as total_count
FROM {table_name}
WHERE 1=1
    AND p_date = '{partition_date}' AND p_hour = {partition_hour}
