Database error: Invalid SQL: SELECT * FROM ((SELECT m.*, the.couleur
FROM portail_page AS art,
portail_page AS cat,
portail_page AS the,
portail_page_parent AS par,
portail_page_parent AS pare,
portail_model_page as pm,
portail_model as m
WHERE art.id=pm.id_portail_page
AND pm.id_portail_model=m.id
AND pare.id_portail_page=art.id
AND pare.id_portail_page_parent=par.id_portail_page
AND par.id_portail_page=cat.id
AND par.id_portail_page_parent=the.id
AND art.visible=1
AND art.id_portail_page_type=3
AND cat.id=)
UNION
(SELECT m.*, the.couleur
FROM portail_page AS sart,
portail_page AS art,
portail_page AS cat,
portail_page AS the,
portail_page_parent AS par,
portail_page_parent AS pare,
portail_page_parent AS pares,
portail_model_page as pm,
portail_model as m
WHERE sart.id=pm.id_portail_page
AND pm.id_portail_model=m.id
AND pare.id_portail_page=sart.id
AND pare.id_portail_page_parent=par.id_portail_page
AND par.id_portail_page=art.id
AND par.id_portail_page_parent=pares.id_portail_page
AND pares.id_portail_page=cat.id
AND pares.id_portail_page_parent=the.id
AND sart.visible=1
AND sart.id_portail_page_type=9
AND cat.id=)) AS Modele
GROUP BY id
ORDER BY RAND()
LIMIT 0, 20
MySQL error:
1064 (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 ')
UNION
(SELECT m.*, the.couleur
FROM port' at line 17) Requete: SELECT * FROM ((SELECT m.*, the.couleur
FROM portail_page AS art,
portail_page AS cat,
portail_page AS the,
portail_page_parent AS par,
portail_page_parent AS pare,
portail_model_page as pm,
portail_model as m
WHERE art.id=pm.id_portail_page
AND pm.id_portail_model=m.id
AND pare.id_portail_page=art.id
AND pare.id_portail_page_parent=par.id_portail_page
AND par.id_portail_page=cat.id
AND par.id_portail_page_parent=the.id
AND art.visible=1
AND art.id_portail_page_type=3
AND cat.id=)
UNION
(SELECT m.*, the.couleur
FROM portail_page AS sart,
portail_page AS art,
portail_page AS cat,
portail_page AS the,
portail_page_parent AS par,
portail_page_parent AS pare,
portail_page_parent AS pares,
portail_model_page as pm,
portail_model as m
WHERE sart.id=pm.id_portail_page
AND pm.id_portail_model=m.id
AND pare.id_portail_page=sart.id
AND pare.id_portail_page_parent=par.id_portail_page
AND par.id_portail_page=art.id
AND par.id_portail_page_parent=pares.id_portail_page
AND pares.id_portail_page=cat.id
AND pares.id_portail_page_parent=the.id
AND sart.visible=1
AND sart.id_portail_page_type=9
AND cat.id=)) AS Modele
GROUP BY id
ORDER BY RAND()
LIMIT 0, 20;
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/site/www.easydroit.fr/class/class.mysql.php on line 183
|
|