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)


from Newest questions tagged laravel-5 - Stack Overflow https://ift.tt/3q9lH46
via IFTTT

Aucun commentaire:

Enregistrer un commentaire