select count(*) as c from product as p where
        exists(select 1 from program where id=program_id and exists(select 1 from xml where id=xml_id and deleted=0)) and  
        ((exists(select 1 from category where category.id in (4, 5, 6, 7, 8, 9, 10, 11, 20, 264, 265, 266, 267, 268, 269, 270, 271, 272, 273, 274, 275, 276, 277, 278, 279, 280, 281, 282, 283, 284, 285, 286, 287, 288, 289, 290, 291, 292, 293, 294, 295, 296, 297, 298, 299, 300, 301, 302, 303, 307, 262) and 
        exists(select 1 from webe_catalog where p.webe_catalog_id=webe_catalog.id and 
        p.webe_catalog_id=webe_catalog.id and 
        EXISTS( select 1 from category_webe_catalog where category_webe_catalog.webe_catalog_id=webe_catalog.id and 
        category_webe_catalog.category_id=category.id)))) or (false or  exists(select 1 from product where name like '%XPERIA C%' and id=p.id)  or  exists(select 1 from product where name like '%XPERIA C3%' and id=p.id)  or  exists(select 1 from product where name like '%XPERIA C4%' and id=p.id)  or  exists(select 1 from product where name like '%XPERIA C5%' and id=p.id)  or  exists(select 1 from product where name like '%XPERIA C6%' and id=p.id)  or  exists(select 1 from product where name like '%XPERIA T2%' and id=p.id)  or  exists(select 1 from product where name like '%XPERIA X%' and id=p.id)  or  exists(select 1 from product where name like '%XPERIA XA%' and id=p.id)  or  exists(select 1 from product where name like '%XPERIA Z1 Compact%' and id=p.id)  or  exists(select 1 from product where name like '%XPERIA E%' and id=p.id)  or  exists(select 1 from product where name like '%XPERIA E1%' and id=p.id)  or  exists(select 1 from product where name like '%XPERIA E3%' and id=p.id)  or  exists(select 1 from product where name like '%XPERIA E4%' and id=p.id)  or  exists(select 1 from product where name like '%XPERIA J%' and id=p.id)  or  exists(select 1 from product where name like '%XPERIA L%' and id=p.id)  or  exists(select 1 from product where name like '%XPERIA M%' and id=p.id)  or  exists(select 1 from product where name like '%XPERIA M2%' and id=p.id)  or  exists(select 1 from product where name like '%XPERIA M4 Aqua%' and id=p.id)  or  exists(select 1 from product where name like '%XPERIA M5%' and id=p.id)  or  exists(select 1 from product where name like '%XPERIA P%' and id=p.id)  or  exists(select 1 from product where name like '%XPERIA SP%' and id=p.id)  or  exists(select 1 from product where name like '%XPERIA T%' and id=p.id)  or  exists(select 1 from product where name like '%XPERIA T3%' and id=p.id)  or  exists(select 1 from product where name like '%XPERIA Tipo%' and id=p.id)  or  exists(select 1 from product where name like '%XPERIA U%' and id=p.id)  or  exists(select 1 from product where name like '%XPERIA V%' and id=p.id)  or  exists(select 1 from product where name like '%XPERIA XA1%' and id=p.id)  or  exists(select 1 from product where name like '%XPERIA XA1 Plus%' and id=p.id)  or  exists(select 1 from product where name like '%XPERIA XA1 Ultra%' and id=p.id)  or  exists(select 1 from product where name like '%XPERIA XA2 Ultra%' and id=p.id)  or  exists(select 1 from product where name like '%XPERIA XZ%' and id=p.id)  or  exists(select 1 from product where name like '%XPERIA XZ Premium%' and id=p.id)  or  exists(select 1 from product where name like '%XPERIA XZ1%' and id=p.id)  or  exists(select 1 from product where name like '%XPERIA XZ1 Compact%' and id=p.id)  or  exists(select 1 from product where name like '%XPERIA XZ2%' and id=p.id)  or  exists(select 1 from product where name like '%XPERIA XZ2 Compact%' and id=p.id)  or  exists(select 1 from product where name like '%XPERIA XZ3%' and id=p.id)  or  exists(select 1 from product where name like '%XPERIA Z%' and id=p.id)  or  exists(select 1 from product where name like '%XPERIA Z1%' and id=p.id)  or  exists(select 1 from product where name like '%XPERIA Z2%' and id=p.id)  or  exists(select 1 from product where name like '%XPERIA Z3 Compact%' and id=p.id)  or  exists(select 1 from product where name like '%XPERIA Z4%' and id=p.id)  or  exists(select 1 from product where name like '%XPERIA Z4 Compact%' and id=p.id)  or  exists(select 1 from product where name like '%XPERIA Z5 Premium%' and id=p.id)  or  exists(select 1 from product where name like '%XPERIA Z5 Premium%' and id=p.id)  or  exists(select 1 from product where name like '%XPERIA Z5%' and id=p.id)  or  exists(select 1 from product where name like '%Z3%' and id=p.id)  or  exists(select 1 from product where name like '%xperia L1%' and id=p.id)  or  exists(select 1 from product where name like '%sony%' and id=p.id) ))SQLSTATE[HY000]: General error: 1290 The MariaDB server is running with the --max-session-mem-used=1073741824 option so it cannot execute this statement