Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /var/www/www.electronic-boulevard.com/inc/lib/article.lib.php on line 191
SELECT a.id_article, id_produit, a.ref_article, type_article, amperage_article, watth,watthL,infotech,quantite_article, p.id_type, p.id_categorie, p.id_marque, voltage_article, nom_type, nom_categorie, nom_marque, REPLACE(commentaire_article,'{NOM SITE}','EBVD') AS commentaire_article, REPLACE(msg_compatible_article,'{NOM SITE}','EBVD') AS msg_compatible_article, REPLACE(msg_compatible0_article,'{NOM SITE}','EBVD') AS msg_compatible0_article, ref_origine, ref_appareil, prix_promo, DATE_FORMAT(date_livraison_article,'%d/%m/%Y') AS date_livraison_article_fr, ROUND(IF(prix_promo,MIN(IF(prefix_promo=1,prix_vente_article - prix_promo,ROUND(prix_vente_article * (1 - (prix_promo / 100)),2))),prix_vente_article) * (1 + valeur_taxe),2) AS prix_vente_ttc, ROUND(prix_vente_article * (1 + valeur_taxe),2) AS prix_vente_ttc_no_promo, ROUND(IF(prix_promo,MIN(IF(prefix_promo=1,prix_vente_article - prix_promo,ROUND(prix_vente_article * (1 - (prix_promo / 100)),2))),prix_vente_article),2) AS prix_vente_ht, ROUND(prix_vente_article,2) AS prix_vente_ht_no_promo, image_article, image_zoom_article, garantie_article FROM (ARTICLE a, TAXE tx, PRODUIT p , TYPE t, CATEGORIE c) LEFT JOIN MARQUE m ON (p.id_marque = m.id_marque) LEFT JOIN PROMO pr ON (((pr.ref_article = a.ref_article OR pr.ref_article = '') AND (pr.id_type = p.id_type OR pr.id_type IS NULL) AND (pr.id_categorie = p.id_categorie OR pr.id_categorie IS NULL) AND (pr.id_marque = p.id_marque OR pr.id_marque IS NULL)) AND date_debut_promo <= NOW() AND date_fin_promo >= NOW() AND statut_promo='1' AND code_promo='') WHERE a.id_taxe = tx.id_taxe AND a.ref_article = p.ref_article AND p.id_type = t.id_type AND p.id_categorie = c.id_categorie AND afficher_article = '1' AND prix_vente_article > 0 AND p.id_type = '13' AND p.id_categorie = '71' AND p.id_marque = '1421' AND ref_origine LIKE '%HXEW01%' GROUP BY p.ref_article ORDER BY description_type DESC Table 'ebvd.TYPE' doesn't exist
|
