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?