nozzy

SELECT A.*,
B.mobile
FROM users as A 
left join phones as B on B.login = A.login
WHERE ( A.cash BETWEEN 0 AND 79.99) AND A.tariff = '15';

select 
t1.email as parent_email,
t2.email as email,
t2.password as password
from my_table t1
left join (
	select
	parrent_id, 
	email,
	password
	from my_table
	where parrent_id is not null
) t2 on t2.parrent_id = t1.parrent_id
where t1.parrent_id is null
order by t1.email

curl_setopt($ch, CURLOPT_HTTPHEADER, array(
   "Accept-Language: ru-RU,ru;q=0.8,en-US;q=0.5,en;q=0.3",
   "Referer: https://site.ru/index",
   .....
    ));

public function getCategoryNames($product_id) {     
        $query = $this->db->query("SELECT *, dac.top
        FROM " . DB_PREFIX . "category_description cd
        LEFT JOIN " . DB_PREFIX . "product_to_category p2c ON (p2c.category_id = cd.category_id)
LEFT JOIN " . DB_PREFIX . "de_av_category as dac ON (p2c.category_id = dac.category_id)
        WHERE p2c.product_id = '" . (int)$product_id . "'AND cd.language_id = '" . (int)$this->config->get('config_language_id') . "'");     
        return $query->rows;
    }