X
accueil
    
Les pierres naturelles (Margelles)
    
Les Margelles Classiques
    
Margelle de piscine PIERRE NOIRE
1226 - User 'leshoppijfauth' has exceeded the 'max_questions' resource (current value: 96507)

select pd.products_name, pd.products_name2, p.products_divers, p.products_model, p.products_image, p.products_id, p.products_master, p.products_master_status, p.manufacturers_id, p.products_width, p.products_height, p.products_piece_angle, p.products_piece_angle_price, p.products_piece_angle_weight, p.products_kit_margelle, p.products_multi_option, p.products_unique_stop_cart, p.products_price, p.design_surface, p.products_price_surface, p.products_remise, p.products_weight, p.products_quantity, p.shipping_module, p.products_qty_blocks, p.products_tax_class_id, p.adh_cart, p.products_affect, p.group_products, p.name, p.price, p.netWeight, p.status, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, ptdc.discount_categories_id, p.products_mesure_status from new_cimb_products p left join new_cimb_specials s on p.products_id = s.products_id left join new_cimb_products_to_discount_categories ptdc on p.products_id = ptdc.products_id, new_cimb_products_description pd where p.products_status = '1' and pd.products_id = p.products_id and p.products_id = '1992' and pd.language_id = '4'

[TEP STOP]