SELECT irisvisi_wstokidb.as_products.id, irisvisi_wstokidb.as_products.price, irisvisi_wstokidb.as_products.old_price, irisvisi_wstokidb.as_products.pr_ot, irisvisi_wstokidb.as_products.pr_do, irisvisi_wstokidb.as_products.to_have_in_stock, irisvisi_wstokidb.as_products.fine_order_client, 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, irisvisi_wstokidb.as_products.kolichestvo FROM irisvisi_wstokidb.as_products WHERE 1 and irisvisi_wstokidb.as_products.`fllang`= 1 and irisvisi_wstokidb.as_products.id_firma=2047 and to_have_in_stock=1 LIMIT 0,100
