Аквариумы с оборудованием в комплекте
Популярные производители
select p.products_model, p.kod1c, p.products_image, p.products_ordered_all, p.products_ishit, p.products_isnano, p.products_ismeristem, p.is_final_price, p.products_quantity, p.quantity_sum, p.discontinued, pd.products_name, IF(pd.products_video != "", 1, 0) as is_video, p.size, p.products_id, p.manufacturers_id, p.price_min, p.products_price, p.products_price_reg, p.price_recommend, p.products_date_added, IF(p.products_date_added > '2024-03-18', 1, 0) as isnew, p.products_isnew, p.products_tax_class_id, IF(p.quantity_sum > 0, 1, 0) as zhopa, p.products_isfish, p.is_dangerous, p.live_group, p.size, p.anal_count, p.spare_count, p.fits_count, p.fishes_count, p.feeds_count, p.korma_k_count, p.rew_count, p.sklad, st.tag from products p, products_description pd, manufacturers m, products_to_categories p2c, rw_sklady st , tech_aqua_filters_values vf where p.sklad =st.sklad_id and p.products_status = '1' and p.products_isel!=1 and p.manufacturers_id = m.manufacturers_id and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '4' and p.products_id=vf.products_id and vf.s_oborudovaniem=1 and p2c.categories_id = '4' group by kod1c order by zhopa desc, p.products_ishit_aquarium desc, p.products_price, pd.products_name
[TEP STOP]