How to make sampling on the fields?

Good afternoon. There is such a request
$sql = "SELECT * FROM" . DB_PREFIX . "information i LEFT JOIN" . DB_PREFIX . "information_description id ON (i.information_id = id.information_id) WHERE id.language_id = '" . (int)$this->config->get('config_language_id') . "'";

Can't understand how to add another condition that would output the data where the table oc_information_to_store in the field store_id = 1. in the same table there are information_id
ie we need some kind of subquery or something. that would first get information_id table oc_information_to_store with the condition that store_id = 1 and then it to add here that if i.information_id = id.information_id = oc_information_to_store.information_id ?
Tell me how to do things right?
March 19th 20 at 09:17
1 answer
March 19th 20 at 09:19
left join oc_information_to_store its on its.information_id = i.information_id

And the condition in where clause
and its.store_id = 1

Find more questions by tags MySQL