500

select `a1`.*, `a1`.`ID` as `ID` from `b_iblock_element` as `a1` left join `b_bit_catalog_element_country_uf_perfectly_match` as `c1` on `a1`.`ID` = `c1`.`VALUE` left join `b_bit_catalog_element_country` as `c2` on `c1`.`ID` = `c2`.`ID` where `a1`.`ID` in (select `a0`.`ID` from `b_iblock_element` as `a0` left join `b_bit_catalog_element_country` as `ec` on `a0`.`XML_ID` = `ec`.`UF_XML_ID` left join `b_bit_catalog_element_country_uf_marketing_label` as `ecm` on `ec`.`ID` = `ecm`.`ID` left join `b_iblock_section_element` as `es` on `a0`.`ID` = `es`.`IBLOCK_ELEMENT_ID` left join `b_iblock_element_prop_s27` as `c1` on a0.`ID` = `c1`.`IBLOCK_ELEMENT_ID` left join (select * from (select `VALUE_ID` as `SECTION_ID`, `UF_ACTION_TYPE` as `ACTION_TYPE` from `b_uts_iblock_27_section`) as `s1` union select * from (select `VALUE_ID` as `SECTION_ID`, `VALUE_INT` as `ACTION_TYPE` from `b_utm_iblock_27_section` where `FIELD_ID` = 889) as `s2`) as `sm` on `sm`.`SECTION_ID` = `es`.`IBLOCK_SECTION_ID` where `a0`.`ACTIVE` = 'Y' and `a0`.`IBLOCK_ID` = 27 and `ec`.`UF_COUNTRY` = 134 and `es`.`ID` in (select `es`.`ID` from `catalog_element_promo` as `cep` inner join `b_iblock_section_element` as `es` on `es`.`IBLOCK_ELEMENT_ID` = `cep`.`UF_ID` inner join `b_uts_iblock_27_section` as `p` on `p`.`VALUE_ID` = `es`.`IBLOCK_SECTION_ID` where `p`.`UF_PROMO_DE` = 1 and `cep`.`UF_COUNTRY` = 134 union select `es`.`ID` from `b_iblock_section_element` as `es` inner join `b_uts_iblock_27_section` as `p` on `p`.`VALUE_ID` = `es`.`IBLOCK_SECTION_ID` where (`p`.`UF_PROMO_DE` is null or `p`.`UF_PROMO_DE` = 0)) and `c1`.`PROPERTY_557` is null and `a0`.`iblock_id` = '27' and (`sm`.`ACTION_TYPE` is null or `sm`.`ACTION_TYPE` = ecm.VALUE)) and `c2`.`UF_COUNTRY` = 134 and `c2`.`UF_XML_ID` = '893c8485-4a31-11ef-9bc7-be12916aae5b' and `a1`.`IBLOCK_SECTION_ID` != 9872 and `a1`.`iblock_id` = '27' group by `a1`.`ID` limit 99 - (conn:29821727, no: 1021, SQLState: HY000) Disk full (/tmp/#sql_827_10.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") sql: select `a1`.*, `a1`.`ID` as `ID` from `b_iblock_element` as `a1` left join `b_bit_catalog_element_country_uf_perfectly_match` as `c1` on `a1`.`ID` = `c1`.`VALUE` left join `b_bit_catalog_element_country` as `c2` on `c1`.`ID` = `c2`.`ID` where `a1`.`ID` in ....