SELECT * FROM mat_f2c f2c LEFT JOIN mat_procate procate ON f2c.cid = procate.id WHERE f2c.fac_id = AND procate.tag_end = 1