SELECT SQL_CALC_FOUND_ROWS DISTINCT g.* ,catalog.`anons`,catalog.`text`,catalog.`key_price`,catalog.`price_mont`,catalog.`accommodation`,catalog.`price_mont_pes`,catalog.`price_mont_sug`,catalog.`price_mont_gl`,catalog.`price_mont_pl`,catalog.`price_dost`,catalog.`price2`,catalog.`show_pict`,catalog.`no_install`,catalog.`col_user`,catalog.`sbros`,catalog.`glub`,catalog.`long_sys`,catalog.`pr`,catalog.`ob_pererab`,catalog.`el_energy`,catalog.`ves`,catalog.`round`,catalog.`diametr`,catalog.`dlina`,catalog.`shirina`,catalog.`visota`,catalog.`seoslogan`,catalog.`anons_calc`,catalog.`look_like`,catalog.`skidka`,catalog.`menustatus`,catalog.`show_on_main`,catalog.`rank_on_main`,catalog.`volume_l`,catalog.`size_mm`,catalog.`diameter_mm`,catalog.`m_load_kg`,catalog.`color`,catalog.`diameter_neck`,catalog.`wall_thick`,catalog.`op_temp`,catalog.`link_bottom`,catalog.`series`,catalog.`section`,catalog.`seo_dlya_dachi`,catalog.`seo_dlya_doma`,catalog.`bestceller`,catalog.`month_product`,catalog.`best_price`,catalog.`montazh_shcemes`,catalog.`glub_int`,catalog.`kanaliz_na_dache`,catalog.`kanaliz_v_dome`,catalog.`kanaliz_avtonom`,catalog.`nakopitelniy_septik`,catalog.`group_models`,catalog.`modification_description`,catalog.`tehpasport`,catalog.`select_buyers`,catalog.`dost_present`,catalog.`yml_model`,catalog.`tit_min_price`,catalog.`cran`,catalog.`toilet`,catalog.`showers`,catalog.`machines`,catalog.`images`,catalog.`midi`,catalog.`order_bower`,catalog.`days_dost`,catalog.`catalog_cleaning_type`,catalog.`availability`,catalog.`spb_days_dost`,catalog.`catalog_location`,catalog.`catalog_osnovnoi`,catalog.`catalog_spb_vivod`,catalog.`size_bottom`,catalog.`position_v_dacha`,catalog.`catalog_no_pump`,catalog.`pos_v_pump`,catalog.`table_modif`,catalog.`septic_type`,catalog.`good_cat`,catalog.`catalog_distance_delivery`,catalog.`spec_ves`,catalog.`kanaliz_avtonom_spb`,catalog.`kanaliz_na_dache_spb`,catalog.`kanaliz_doma_spb`,catalog.`catalog_video_id`,catalog.`catalog_from_top_to_pipe`,catalog.`catalog_height_without_neck`,catalog.`catalog_top_height`,catalog.`catalog_diam_pipe`,catalog.`catalog_desc_top`,catalog.`catalog_drainage_methods`,catalog.`catalog_mscheme_desc`,catalog.`septik_for_permanent_residence`,catalog.`septik_for_nonpermanent_residence`,catalog.`catalog_garantee`,catalog.`catalog_lifetime`,catalog.`catalog_model`,catalog.`catalog_brand_category`,catalog.`catalog_yml_desc`,catalog.`septik_for_vysokih_grunt_vod`,catalog.`septik_for_promyshl`,catalog.`septik_for_gostinic`,catalog.`septik_for_prinudit`,catalog.`ceptik_for_samotachnyj`,catalog.`septik_for_kottedzh`,catalog.`preimuschestvya_charact`,catalog.`catalog_desc_before_top`,catalog.`catalog_seriya`,catalog.`catalog_text`,catalog.`artikul`,catalog.`barcode`,catalog.`name_other_case`,catalog.`display_on_catalog`,catalog.`productivity`,catalog.`portfolio_block`,catalog.`catalog_main_good`,catalog.`accessories`,catalog.`catalog_ai_review`,catalog.`catalog_rating_value`,catalog.`catalog_review_count`,catalog.`catalog_best_rating`,catalog.`catalog_worst_rating`,tank.`tank_material`,tank.`tank_head_height`,tank.`tank_installation`,tank.`tank_installation_stairs`,tank.`tank_cap`,tank.`tank_op_temp`,tank.`tank_not_list_in_directory`,tank.`tank_sleeve_diameter_internal`,tank.`tank_material_thickness_bottom`,tank.`tank_material_thickness_sleeve`,tank.`tank_material_thickness_partitions`,tank.`tank_number_in_name`,tank.`tank_optional_equipment`,tank.`tank_wall_thick` , `tbl_currencies`.price_rub_fields, `tbl_currencies`.price_rub, `tbl_currencies`.price_old_rub, if (terp.price>0,terp.price,g.price) as price, if (terp.price>0,terp.price,g.price) as order_price, if (terp.price_shef>0,terp.price_shef,price_mont) as price_mont, if (terp.price_pes>0,terp.price_pes,price_mont_pes) as price_mont_pes, if (terp.price_dost>0,terp.price_dost,catalog.price_dost) as price_dost, if (terp.price_pl>0,terp.price_pl,price_mont_pl) as price_mont_pl, if (terp.price_gl>0,terp.price_gl,price_mont_gl) as price_mont_gl, if (terp.price_sug>0,terp.price_sug,price_mont_sug) as price_mont_sug, if (terp.price_modern>0,terp.price_modern,g.price_modern) as price_modern, if (terp.price_classic>0,terp.price_classic,g.price_classic) as price_classic, pr.priority as good_priority
FROM `tbl_ecommerce_cat_setting` s
JOIN `tbl_ecommerce_goods` g ON g.`id` = s.`good`
LEFT JOIN `tbl_currencies` ON (`tbl_currencies`.good_id=g.`id`)
LEFT JOIN `tbl_good_cat_priority` pr ON (pr.good_id=g.id and pr.cat_id='20')
LEFT JOIN `region_price` terp ON (terp.good_id=g.`base_id` AND region='ekaterinburg')
LEFT JOIN `tbl_catalog_ecommerce_fields` as catalog ON catalog.good_id = g.id LEFT JOIN `tbl_tank_ecommerce_fields` as tank ON tank.good_id = g.id
WHERE s.`cat` IN (20,224,225,233,234,235,236,293,294,237,238) AND (`status` = 'enable' AND `good_off`=0 AND 1=1 AND g.parent_id IS NULL AND g.main_parent_id IS NULL ) ORDER BY (if (terp.price IS NULL OR terp.price = '0' OR terp.price = '',0,1)) desc, good_priority desc LIMIT 120,24
