FVS S.p.a. has been operating in the steel sector since 1954: the company provides tailor-made machining on industrial volumes of ANY TYPE OF STEEL PRODUCT YOUR BUSINESS NEEDS.
The vast assortment available at our warehouses in Villafranca and Mozzecane makes it possible to complete your supply requirements both of material processed according to your requests and of material available from stock.
FVS S.p.a. addresses the national market of metal constructions in general, mechanical constructions and heavy carpentry without neglecting the various applications that distinguish the world of steel.
DISTRIBUTION AND PROCESSING OF STEEL PRODUCTS
ADVICE, SUPPORT AND SUPPLY IN THE WORLD OF METAL CONSTRUCTION
Whole query: SELECT *, (SELECT COUNT(comments_id) FROM comments as com WHERE com.product_id=p.product_id AND com.comments_status='1') as comments_num, (SELECT SUM(comments_rate) FROM comments as com WHERE com.product_id=p.product_id AND com.comments_status='1') as comments_rate_sum, (SELECT AVG(comments_rate) FROM comments as com WHERE com.product_id=p.product_id AND com.comments_status='1') as comments_rate_avg, (SELECT SUM(comments_like) FROM comments as com WHERE com.product_id=p.product_id AND com.comments_status='1') as comments_like_sum FROM product AS p INNER JOIN to_user AS p2u ON p.product_id=p2u.ref_id AND p2u.ref_table="product" INNER JOIN to_view AS p2v ON p.product_id=p2v.ref_id AND p2v.ref_table="product" INNER JOIN product_to_menu AS p2m ON p.product_id = p2m.product_id INNER JOIN product_menu AS pm ON pm.product_menu_id = p2m.product_menu_id LEFT JOIN wbm_user AS u ON p2u.wbm_id=u.wbm_id WHERE p2m.product_menu_id IN (13) AND p.product_languages_id = 2 AND pm.product_menu_languages_id = 2 AND p.product_status = "1" ORDER BY product_order ASC LIMIT -3, 3