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=2530104  LIMIT 12,6

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

Спалня Cosmopolitan 1

1121.00 лв.

Спален комплект Космополитън 22

1026.00 лв.

Спален комплект Космополитън 24

1990.00 лв.

Спален комплект Космополитън 25

1390.00 лв.

Спален комплект Космополитън 23

1321.00 лв.

Спален комплект Космополитън 20

1156.00 лв.

Categories