delayed_jobs - extract jobs with specifics error on celebrities ( B&C)

readme.md

List all errors about Twitter page does not exist

select * from celebrities where id in
(
  select distinct SUBSTRING_INDEX(SUBSTRING_INDEX(SUBSTRING_INDEX(handler, '\n', 4), '\n', -1), ' ', -1) as celebrity_id 
    from delayed_jobs 
  where last_error like '{Sorry, that page%'
)

List One facebook error ( deleted )

select * from celebrities where id in
(
  select distinct SUBSTRING_INDEX(SUBSTRING_INDEX(SUBSTRING_INDEX(handler, '\n', 4), '\n', -1), ' ', -1) as celebrity_id  
  from delayed_jobs 
    where last_error like'{399: unexpected token at%'
)

List user suspended

select * from celebrities where id in
(
  select distinct SUBSTRING_INDEX(SUBSTRING_INDEX(SUBSTRING_INDEX(handler, '\n', 4), '\n', -1), ' ', -1) as celebrity_id 
  from delayed_jobs 
    where last_error like '{User has been suspended%'
)
````