SELECT product_id, product_category_id, product_reference, product_libelle, product_description, product_price, product_by, product_published, company_id, product_is_new, product_promo, product_parent FROM dgcms_product WHERE product_published = 1 AND (product_promo <> 0 AND product_promo is not null) ORDER BY RAND() LIMIT 0, 5
array(3) {
  [0]=>
  string(5) "HY000"
  [1]=>
  int(1)
  [2]=>
  string(62) "Can't create/write to file '/tmp/#sql_345_0.MYD' (Errcode: 17)"
}
SELECT product_id, product_category_id, product_reference, product_libelle, product_description, product_price, product_by, product_published, company_id, product_is_new, product_promo, product_parent FROM dgcms_product WHERE product_published = 1 AND product_is_new = 1 GROUP BY IF (product_parent IS NOT NULL AND product_parent <> 0, product_parent, product_id) ORDER BY RAND() LIMIT 0, 5
array(3) {
  [0]=>
  string(5) "HY000"
  [1]=>
  int(1)
  [2]=>
  string(62) "Can't create/write to file '/tmp/#sql_345_0.MYD' (Errcode: 17)"
}
Découvrez notre linge de maison brodé, nos broderies etc...