Contact

SELECT *, dc.id as id_good FROM circuits_category as dc left join circuits_category_lang dcl on dc.id=dcl.category_id where dcl.lang_id=2 AND dc.end_time>='2019-07-16' ORDER BY dc.start_time LIMIT 1