500

select `n0`.*, `b1`.`ID` as `b1__ID`, `b1`.`CONTENT_TYPE` as `b1__CONTENT_TYPE`, `b1`.`TIMESTAMP_X` as `b1__TIMESTAMP_X`, `b1`.`MODULE_ID` as `b1__MODULE_ID`, `b1`.`HEIGHT` as `b1__HEIGHT`, `b1`.`WIDTH` as `b1__WIDTH`, `b1`.`FILE_SIZE` as `b1__FILE_SIZE`, `b1`.`FILE_NAME` as `b1__FILE_NAME`, `b1`.`ORIGINAL_NAME` as `b1__ORIGINAL_NAME`, `b1`.`DESCRIPTION` as `b1__DESCRIPTION`, `b1`.`SUBDIR` as `b1__SUBDIR`, `b2`.`ID` as `b2__ID`, `b2`.`CONTENT_TYPE` as `b2__CONTENT_TYPE`, `b2`.`TIMESTAMP_X` as `b2__TIMESTAMP_X`, `b2`.`MODULE_ID` as `b2__MODULE_ID`, `b2`.`HEIGHT` as `b2__HEIGHT`, `b2`.`WIDTH` as `b2__WIDTH`, `b2`.`FILE_SIZE` as `b2__FILE_SIZE`, `b2`.`FILE_NAME` as `b2__FILE_NAME`, `b2`.`ORIGINAL_NAME` as `b2__ORIGINAL_NAME`, `b2`.`DESCRIPTION` as `b2__DESCRIPTION`, `b2`.`SUBDIR` as `b2__SUBDIR`, `b3`.`ID` as `b3__ID`, `b3`.`CONTENT_TYPE` as `b3__CONTENT_TYPE`, `b3`.`TIMESTAMP_X` as `b3__TIMESTAMP_X`, `b3`.`MODULE_ID` as `b3__MODULE_ID`, `b3`.`HEIGHT` as `b3__HEIGHT`, `b3`.`WIDTH` as `b3__WIDTH`, `b3`.`FILE_SIZE` as `b3__FILE_SIZE`, `b3`.`FILE_NAME` as `b3__FILE_NAME`, `b3`.`ORIGINAL_NAME` as `b3__ORIGINAL_NAME`, `b3`.`DESCRIPTION` as `b3__DESCRIPTION`, `b3`.`SUBDIR` as `b3__SUBDIR`, `p4`.`ID` as `p4__ID`, `p4`.`VALUE` as `p4__VALUE`, `n0`.`UF_DESKTOP_LARGE` as `UF_DESKTOP_LARGE` from `new_site_banners` as `n0` left join `b_file` as `b1` on `n0`.`UF_BANNER` = `b1`.`ID` left join `b_file` as `b2` on `n0`.`UF_BANNER_MOBILE` = `b2`.`ID` left join `b_file` as `b3` on `n0`.`UF_DESKTOP_LARGE` = `b3`.`ID` left join `new_site_banners_uf_product_id` as `p4` on `n0`.`ID` = `p4`.`ID` left join `new_site_banners_uf_language` as `n5` on `n0`.`ID` = `n5`.`ID` left join `new_site_banners_uf_country` as `n6` on `n0`.`ID` = `n6`.`ID` left join `b_user_field_enum` as `n7` on `n0`.`UF_LOCATION` = `n7`.`ID` and `n7`.`user_field_id` = '3131' where `n0`.`UF_ACTIVE` = 1 and `n5`.`VALUE` = 1 and `n6`.`VALUE` = 134 and `n7`.`XML_ID` = 'catalog_detail:review_right' order by `n0`.`UF_SORT` asc - (conn:29884640, no: 1021, SQLState: HY000) Disk full (/tmp/#sql_827_6.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") sql: select `n0`.*, `b1`.`ID` as `b1__ID`, `b1`.`CONTENT_TYPE` as `b1__CONTENT_TYPE`, `b1`.`TIMESTAMP_X` as `b1__TIMESTAMP_X`, `b1`.`MODULE_ID` as `b1__MODULE_ID`, `b1`.`HEIGHT` as `b1__HEIGHT`, `b1`.`WIDTH` as `b1__WIDTH`, `b1`.`FILE_SIZE` as `b1__FILE_SIZE`, ....