lundi 10 janvier 2022

Convert SQL to eloquent query

i have the next query with subequery how can convert it to eloquent, i have some troubles with eloquent conversion :S. Thanks

select a.* from (
    select * 
    from "public"."tabla_procesados" 
    where "state" LIKE '%Failed%' 
    and id_execution = (select max(id_execution) from public.tabla_procesados)
    order by public.tabla_procesados.ts_start_processing desc limit 1
) a
where ts_start_processing < (now() - '10 minutes'::INTERVAL)


via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire