SELECT 
  irisvisi_wstokidb.as_products.id,
  irisvisi_wstokidb.as_products.price,
  irisvisi_wstokidb.as_products.old_price,  
  irisvisi_wstokidb.as_products.to_have_in_stock,
  irisvisi_wstokidb.as_products.description_1,
  irisvisi_wstokidb.as_products.description2_1,
  irisvisi_wstokidb.as_products.top_offer,
  irisvisi_wstokidb.as_products.name_1,
  irisvisi_wstokidb.as_products.date_last_update,  
  irisvisi_wstokidb.as_products.name2_1,
  irisvisi_wstokidb.as_products.meta_keywords_1,  
  irisvisi_wstokidb.as_products.meta_description_1,  
  irisvisi_wstokidb.as_products.meta_title_1,  
  irisvisi_wstokidb.as_products.fl2, 
  irisvisi_wstokidb.as_products.id_dostavchik,   
  irisvisi_wstokidb.as_products.id_inport, 
  irisvisi_wstokidb.as_products.id_sorce,    
  irisvisi_wstokidb.as_products.d_a,  
  irisvisi_wstokidb.as_products.category,   
  irisvisi_wstokidb.as_products.prod_num, 
  irisvisi_wstokidb.as_products.catalojen_n,   
  irisvisi_wstokidb.as_products.id_marka,  
  irisvisi_wstokidb.as_products.if_basket,
  irisvisi_wstokidb.as_products.id_firma,
  irisvisi_wstokidb.as_products.weight,         
  irisvisi_wstokidb.as_products.fllang
FROM
  irisvisi_wstokidb.as_products
  WHERE
  irisvisi_wstokidb.as_products.`fllang`= 1 and  irisvisi_wstokidb.as_products.id_firma=100268 and category=2530146  LIMIT 6,6

Каталог мебели

Витрина ъглова 803 МДФ фурнир дъб

634.00 лв.

Витрина единична 801 МДФ фурнир дъб

619.00 лв.

Витрина трикрилна 804 МДФ фурнир дъб

1262.00 лв.

Витрина ъглова 803М МДФ фурнир дъб

424.00 лв.

Categories