SELECT SQL_CALC_FOUND_ROWS DISTINCT g.* ,catalog.`anons`,catalog.`text`,catalog.`key_price`,catalog.`price_mont`,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`,topas.`price_topas_s`,topas.`price_key_topas_s`,articles.`short_description`,articles.`full_description`,gallery.`in_topas`,gallery.`in_astra`,gallery.`in_kanalization`,gallery.`gallery_address`,gallery.`gallery_equipment`,gallery.`gallery_object`,gallery.`gallery_date`,gallery.`gallery_pererab`,gallery.`gallery_users`,gallery.`gallery_images`,gallery.`gallery_equipment_id`,gallery.`gallery_work`,gallery.`gallery_distance`,gallery.`gallery_addressspb`,gallery.`gallery_obj_spb`,gallery.`gallery_distance_moscow`,gallery.`gallery_review_id`,gallery.`show_in_cat`,gallery.`gallery_no_equipment`,gallery.`gallery_addresskrasnodar`,ceptik.`modifications_noindex`,ceptik.`ceptik_avtonomny`,ceptik.`ceptik_energonezavisimy`,ceptik.`descr_after_price_montazh`,ceptik.`popularity_for_giving`,ceptik.`rating_of_the_best_septic`,ceptik.`rating_price_quality`,ceptik.`build_quality`,ceptik.`rating_best_house_septic`,reviews.`review`,reviews.`id_septik`,news.`news_short_description`,news.`news_text`,news.`news_date_format`,video.`video_equipment_id`,video.`video_description`,video.`video_date`,video.`video_works`,video.`video_video`,video.`video_address`,video.`video_equipment`,kesson.`kesson_casing_diameter`,kesson.`kesson_material`,kesson.`kesson_neck_shape`,kesson.`kesson_shape`,kesson.`kesson_tank_volume`,kesson.`kesson_top_height`,kesson.`kesson_top_type`,kesson.`working_chamber_diameter`,kesson.`working_chamber_height`,kesson.`stairs`,cellar.`manhole_width`,cellar.`manhole_length`,cellar.`manhole_height`,cellar.`entrance`,cellar.`shape`,cellar.`shelf_width`,cellar.`ventilation`,cellar.`lighting`,cellar.`warming`,cellar.`temp_hum_control`,cellar.`operating_temperature`,cellar.`shelves_number`,cellar.`vent_pipe_diameter`,cellar.`working_area`,cellar.`chamber_length`,cellar.`chamber_width`,cellar.`optional_equipment`,cellar.`bottom_thickness`,cellar.`cellar_chamber_height`,cellar.`cellar_visota_vhod`,cellar.`cellar_length_vhod`,cellar.`cellar_shirina_vhod`,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` , `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_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, if (terp.price_s>0,terp.price_s,price_topas_s) as price_topas_s FROM `tbl_ecommerce_goods` g LEFT JOIN `tbl_currencies` ON (`tbl_currencies`.good_id=g.`id`) LEFT JOIN `region_price` terp ON (terp.good_id=g.`base_id` AND region='') LEFT JOIN `tbl_catalog_ecommerce_fields` as catalog ON catalog.good_id = g.id LEFT JOIN `tbl_topas_ecommerce_fields` as topas ON topas.good_id = g.id LEFT JOIN `tbl_articles_ecommerce_fields` as articles ON articles.good_id = g.id LEFT JOIN `tbl_gallery_ecommerce_fields` as gallery ON gallery.good_id = g.id LEFT JOIN `tbl_ceptik_ecommerce_fields` as ceptik ON ceptik.good_id = g.id LEFT JOIN `tbl_reviews_ecommerce_fields` as reviews ON reviews.good_id = g.id LEFT JOIN `tbl_news_ecommerce_fields` as news ON news.good_id = g.id LEFT JOIN `tbl_video_ecommerce_fields` as video ON video.good_id = g.id LEFT JOIN `tbl_kesson_ecommerce_fields` as kesson ON kesson.good_id = g.id LEFT JOIN `tbl_cellar_ecommerce_fields` as cellar ON cellar.good_id = g.id LEFT JOIN `tbl_tank_ecommerce_fields` as tank ON tank.good_id = g.id WHERE `status` = 'enable' AND `good_off`=0 AND `id` in (1167) AND g.parent_id IS NULL AND g.main_parent_id IS NULL Установка септика в Лосино-Петровском

+7 (800) 350-05-34

Контакты

Ваш регион:

Карта районов обслуживания

+7 (800) 350-05-34

Заказать обратный звонок

text@septik-rus.ru

SELECT SQL_CALC_FOUND_ROWS DISTINCT g.* ,gallery.`gallery_address`,gallery.`gallery_addresskrasnodar`,gallery.`gallery_addressspb`,gallery.`gallery_date`,gallery.`gallery_distance`,gallery.`gallery_distance_moscow`,gallery.`gallery_equipment`,gallery.`gallery_equipment_id`,gallery.`gallery_images`,gallery.`gallery_no_equipment`,gallery.`gallery_object`,gallery.`gallery_obj_spb`,gallery.`gallery_pererab`,gallery.`gallery_review_id`,gallery.`gallery_users`,gallery.`gallery_work`,gallery.`in_astra`,gallery.`in_kanalization`,gallery.`in_topas`,gallery.`show_in_cat` , `tbl_currencies`.price_rub_fields, `tbl_currencies`.price_rub, `tbl_currencies`.price_old_rub FROM `tbl_ecommerce_goods` g LEFT JOIN `tbl_currencies` ON (`tbl_currencies`.good_id=g.`id`) LEFT JOIN `tbl_gallery_ecommerce_fields` as gallery ON gallery.good_id = g.id WHERE `status` = 'enable' AND `good_off`=0 AND 1=1 AND g.parent_id IS NULL AND g.main_parent_id IS NULL SELECT SQL_CALC_FOUND_ROWS DISTINCT g.* ,gallery.`gallery_address`,gallery.`gallery_addresskrasnodar`,gallery.`gallery_addressspb`,gallery.`gallery_date`,gallery.`gallery_distance`,gallery.`gallery_distance_moscow`,gallery.`gallery_equipment`,gallery.`gallery_equipment_id`,gallery.`gallery_images`,gallery.`gallery_no_equipment`,gallery.`gallery_object`,gallery.`gallery_obj_spb`,gallery.`gallery_pererab`,gallery.`gallery_review_id`,gallery.`gallery_users`,gallery.`gallery_work`,gallery.`in_astra`,gallery.`in_kanalization`,gallery.`in_topas`,gallery.`show_in_cat` , `tbl_currencies`.price_rub_fields, `tbl_currencies`.price_rub, `tbl_currencies`.price_old_rub FROM `tbl_ecommerce_goods` g LEFT JOIN `tbl_currencies` ON (`tbl_currencies`.good_id=g.`id`) LEFT JOIN `tbl_gallery_ecommerce_fields` as gallery ON gallery.good_id = g.id WHERE `id` in (1167) AND g.parent_id IS NULL AND g.main_parent_id IS NULL SELECT SQL_CALC_FOUND_ROWS g.id , `tbl_currencies`.price_rub_fields, `tbl_currencies`.price_rub, `tbl_currencies`.price_old_rub 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_gallery_ecommerce_fields` as gallery ON gallery.good_id = g.id WHERE s.`cat` IN (42) AND (`status` = 'enable' AND `good_off`=0 AND 1=1 AND g.parent_id IS NULL AND g.main_parent_id IS NULL )

Подбор септика за 3 минуты!

Подберите септик за 3 минуты и получите:


Подобрать >>

Подбор септика + скидка