Notice: Undefined variable: page_title in
/home/siters/public_html/rs.ro/inc/site.index.subcategory.php on line
11
Notice: Undefined variable: scateg_id in
/home/siters/public_html/rs.ro/inc/site.index.subcategory.php on line
72
SELECT produse.id_produs,id_subcateg,subcategorie,titlu,meta_title,poza_mare,autor,type_produs,anul,atribute,
produse.keywords,produse.promotie,produse.promotie_fara_tva,produse.pret,produse.pret_fara_tva,produse.start_promotie,produse.end_promotie,
produse.tva,ROUND((produse.pret_fara_tva*((CAST(produse.tva AS BINARY) / 100)+1)),2) as produs_pret_calculat,
descriere_scurta,descriere_lunga,stoc,produse.cod_alfa
FROM produse,subdomeniu_categories_recomandation,subdomeniu,domeniu_tip as p1 INNER JOIN
(SELECT * FROM domeniu_tip GROUP BY id_produs HAVING MAX(id_domeniu_tip)) p2
ON p1.id_domeniu_tip = p2.id_domeniu_tip WHERE produse.id_produs=subdomeniu_categories_recomandation.id_produs_fk
AND subdomeniu_categories_recomandation.scateg_id_fk=
AND produse.id_produs=p1.id_produs
AND subdomeniu.id_subcateg=p1.id_subcategorie
AND p1.id_categorie="5"
AND produse.rs_ro="Da" AND subdomeniu.id_subcateg="36" GROUP BY produse.id_produs ORDER BY srec_order=0,srec_order ASC
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND produse.id_produs=p1.id_produs
AND subdomeniu.id_subcateg=p1.id_subcat' at line 9
