alexalexes

update table tb
      set tb.type_id = (select tp.id from types tp where tp.name = tb.type_name limit 1) -- выбираем подзапросом id из справочника по совпадению наименования поля в обновляемой таблице
 where tb.type_id is null -- страховка, что будем обновлять не установленные значения
     and exists(select 1 from types tp where tp.name = tb.type_name) -- будем ставить ключ, если есть наименование в справочнике types

SELECT p.*,
            case
               when exists(SELECT 1 from cart c where c.products_id = p.id)
               then 1
               else 0
            end is_exists_in_cart -- есть товар к корзине? 0 - нет, 1 - есть
FROM table_products p

SELECT p.*, c.*
FROM table_products p
left join cart c on c.products_id = p.id

$rows = $countryN->fetchAll();
var_dump($rows);

$row = $countryN->fetch();
var_dump($row);

select case
         when a.begin is null and a.end is null then 'нет данных'
         when a.begin is not null and a.end is not null then concat(a.end, '-', a.begin)
         when a.begin is null and a.end is not null then concat('ранее ', a.end + 1)
         when a.begin is not null and a.end is null then concat('от ', a.begin)
       end interval_str,
       cnt
from
(
select inters.begin, inters.end, count(prepod.name) cnt
from
(
  select null begin, 1969 end union all
  select 1970 begin, 1979 end union all
  select 1980 begin, 1989 end union all
  select 1990 begin, 1999 end union all
  select 2000 begin, null end union all
  select null begin, null end -- запись для тех, у кого нет данных др.
) inters -- таблица с интервалами
left join 
(
  select 'a' name, STR_TO_DATE('2013-02-11', '%Y-%m-%d') date_r union all
  select 'aa' name, STR_TO_DATE('2010-09-01', '%Y-%m-%d') date_r union all
  select 'b' name, STR_TO_DATE('1968-02-11', '%Y-%m-%d') date_r union all
  select 'bb' name, STR_TO_DATE('1969-01-21', '%Y-%m-%d') date_r union all
  select 'c' name, STR_TO_DATE('1980-02-11', '%Y-%m-%d') date_r union all
  select 'd' name, STR_TO_DATE('1989-02-11', '%Y-%m-%d') date_r union all
  select 'z' name,  null date_r -- препод, у которого нет данных др.
) prepod on inters.begin <= year(prepod.date_r) and inters.end >= year(prepod.date_r)
         or inters.begin is null and inters.end >= year(prepod.date_r)
         or inters.begin <= year(prepod.date_r) and inters.end is null
         or prepod.date_r is null and inters.begin is null and inters.end is null
group by inters.begin, inters.end
order by inters.begin desc, inters.end desc
) a

SELECT count(e.id) "кол-во записей example со статусом 1",
       (
           select count(type_id)
           from example e_1
           where type_id = 1
              and e_1.status = 3
       ) "кол-во для типа 1",
       (
           select count(type_id)
           from example e_3
           where type_id = 3
              and e_3.status = 3
       ) "кол-во для типа 3",
       (
           select count(type_id)
           from example e_4
           where type_id = 4 
            and e_4.status = 3
       ) "кол-во для типа 4"
FROM example e
WHERE e.status = 1
     and e.user_id = 53;

SELECT count(e.id) "кол-во записей example со статусом 1",
             count(case when e.type_id = 1
              and e.status = 3 then 1 end)  "кол-во для типа 1",
       count(case when e.type_id = 3
              and e.status = 3 then 1 end)  "кол-во для типа 3",
     count(case when e.type_id = 4
              and e.status = 3 then 1 end)  "кол-во для типа 4"
FROM example e
WHERE e.status = 1
     and e.user_id = 53;

SELECT count(case when e.status = 1 then 1 end) "кол-во записей example со статусом 1",
             count(case when e.type_id = 1
              and e.status = 3 then 1 end)  "кол-во для типа 1",
       count(case when e.type_id = 3
              and e.status = 3 then 1 end)  "кол-во для типа 3",
     count(case when e.type_id = 4
              and e.status = 3 then 1 end)  "кол-во для типа 4"
FROM example e
where e.user_id = 53

-- Считаем статус 1, игнорируем типы
SELECT 'with_status_1' type_query, null type_id, count(*) cnt
FROM example e
where e.status = 1
and e.user_id = 53
union all
-- Считаем остальные типы со статусом 3
SELECT 'with_another_types' type_query, e.type_id, count(*) cnt
FROM example e
where e.status = 3
and e.user_id = 53
group by e.type_id

SET @var = 4;

Select * from
(
-------------Ваш сложный подзапрос --------------------
SELECT *
FROM menu
WHERE FIND_IN_SET(ID,(SELECT GROUP_CONCAT(lv SEPARATOR ',') FROM (
SELECT @pv:=(SELECT GROUP_CONCAT(ID SEPARATOR ',')
FROM menu WHERE submenu IN (@pv)) AS lv FROM menu
JOIN (SELECT @pv:=@var)tmp
WHERE submenu IN (@pv)) a))

UNION ALL
SELECT *
FROM menu
WHERE ID = @var
ORDER BY ID
-------конец сложного подзапроса--------------
) complicated_menu
inner join ваша_таблица vt on complicated_menu.id = vt.id

Try this. Check /etc/php7/

Rename 20_mysqli.ini to 30_mysqli.ini, or delete 20_mysqli.ini if both exist. If you also have 20_openssl.ini there, rename that to 10_openssl.ini.
Above change is needed to load the modules in the correct order.
This should now be fixed in the latest builds, but you could be running older code, or suffering from the bug that was there earlier.