ColoredCow / ColoredCow/campaigns
No way to see the valid or invalid subscribers in a list
- Dominant language
- PHP
- Stars
- 6
- Forks
- 0
- PR merge metrics
- No merged PRs in 30d
Description
The numbers can be clickable that takes the user to the list of valid/invalid subscribers.

I used the following sql query to get the list of invalid subscribers for a list
```sql
SELECT b.email
FROM list_subscriber a
LEFT JOIN subscribers b ON a.subscriber_id = b.id
WHERE a.list_id =
AND b.has_verified_email = 0;
```
Contributor guide
No contributing guide indexed for this repository
Research direction
Start by locating the list view that displays the valid and invalid subscriber counts, then review the provided SQL query and the linked screenshot. The work is done when each count links to the corresponding subscriber list and the results distinguish valid from invalid subscribers for the selected list.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- laravel, php, sql
- Domain
- databases, frontend
- Issue type
- Feature
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 35/100