Светодиодные светильники для кухни в Новосибирске

Каталог led-светильников для кухни

SELECT SQL_CALC_FOUND_ROWS * FROM (SELECT DISTINCT g.* ,catalog.`product_1s`,catalog.`catalog_brand`,catalog.`catalog_description`,catalog.`catalog_short_description`,catalog.`catalog_pluses`,catalog.`catalog_name_cat`,catalog.`group_1s`,catalog.`catalog_sizes`,catalog.`catalog_efficiency`,catalog.`catalog_description_top`,catalog.`catalog_additional_title`,catalog.`catalog_additional_title2`,catalog.`catalog_relink`,catalog.`catalog_life_time`,catalog.`catalog_diffuser`,catalog.`catalog_color`,catalog.`catalog_new`,catalog.`catalog_sale`,catalog.`catalog_power`,catalog.`catalog_powers_int`,catalog.`catalog_button_order`,catalog.`catalog_hit`,catalog.`catalog_kratnost_rezki`,catalog.`catalog_amount_m_buhta`,catalog.`catalog_height`,catalog.`catalog_montage_type`,catalog.`catalog_ip`,catalog.`catalog_desc_autofill`,catalog.`catalog_model`,catalog.`catalog_code`,catalog.`catalog_descr_bottom`,catalog.`catalog_name_for_category`,catalog.`catalog_shape_lamps`,catalog.`catalog_str_enter`,catalog.`catalog_colour_svech`,catalog.`catalog_light_bright`,catalog.`catalog_colortemperature_podbor`,catalog.`catalog_type_diod`,catalog.`catalog_led`,catalog.`catalog_voltage`,catalog.`catalog_length`,catalog.`catalog_width`,catalog.`catalog_diameter`,catalog.`catalog_custom_size`,catalog.`catalog_attachment`,catalog.`catalog_case_colour`,catalog.`catalog_index_colour`,catalog.`catalog_dimming`,catalog.`catalog_sectionof_size`,catalog.`catalog_type_light`,catalog.`catalog_angle`,catalog.`catalog_application`,catalog.`catalog_form`,catalog.`catalog_accessory_cat`,catalog.`catalog_enter_in_accessory`,catalog.`catalog_block`,catalog.`catalog_name_accessory`,catalog.`catalog_aksessuary_true`,catalog.`catalog_recommend`,catalog.`catalog_type_good`,catalog.`catalog_temper_expl_block`,lamps.`lamps_voltage`,lamps.`lamps_diffuser`,lamps.`lamps_colortemperature`,lamps.`lapms_material`,lamps.`lamps_mounting_dimension`,lamps.`lamps_equipment`,lamps.`lamps_stream`,lamps.`lamps_modification`,lamps.`lamps_alngle`,lamps.`lamps_type`,lamps.`lamps_frequency`,lamps.`lamps_count_lines`,lamps.`lamps_draiver`,lamps.`lamps_pf`,lamps.`lamps_count`,lamps.`lamps_current_svetodiod`,lamps.`lamps_driver_power_factor`,lamps.`lamps_svetodiod_brand`,lamps.`lamps_svetodiod_light_output`,lamps.`lamps_light_distrib`,lamps.`lamps_weight`,lamps.`lamps_work_temperature`,lamps.`lamps_climate_perfomance`,lamps.`lamps_protect_class`,lamps.`lamps_control`,lamps.`lamps_kss`,lamps.`lamps_type_source`,lamps.`lamps_light_current`,lamps.`lamps_light_count_diod`,lamps.`lamps_light_bright`,lamps.`lamps_seria`,lamps.`lamps_serii_prioritet`,lamps.`lamps_images_usage`,lamps.`lamps_primenenie`,lamps.`lamps_shema_podklucheniya`,lamps.`ultra_is_ultrathin_cat` , if (main_parent_id is not null and main_parent_id>0,main_parent_id,id) as for_group, `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_catalog_ecommerce_fields` as catalog ON catalog.good_id = g.id LEFT JOIN `tbl_lamps_ecommerce_fields` as lamps ON lamps.good_id = g.id WHERE `status` = 'enable' AND `good_off`=0 AND 1=1 AND ( (g.parent_id IS NULL or g.parent_id =0) AND (g.main_parent_id IS NULL or g.parent_id =0) ) ORDER BY main_parent_id, (price IS NULL OR price = '0' OR price = ''), price) as `tbl_ecommerce_goods` WHERE ((`tbl_ecommerce_goods`.status = 'enable' and `tbl_ecommerce_goods`.`good_off`=0) AND (`tbl_ecommerce_goods`.`catalog_application` LIKE '%для кухни%')) GROUP BY for_group ORDER BY main_parent_id, (price IS NULL OR price = '0' OR price = ''), price LIMIT 30