Aide Syntax error #1064 SQL
Bonjour !
Pourriez vous m'aider à résoudre l'erreur de syntaxe dans mon code ? J'ai regarder partout je ne trouve pas ou elle peut bien se trouver :?
Code:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
| SELECT DISTINCT "produit" type_req,
p.id_product id_product,
0 id_product_attribute,
p.price prix_vente,
p.wholesale_price prix_achat,
p.reference reference,
p.weight weight,
p.quantity quantity,
p.date_upd date_upd,
pl.name name,
pl.description_short description,
tr.name tax_rule
FROM ps_product p
LEFT JOIN ps_product_lang pl ON (pl.id_product = p.id_product AND pl.id_lang=1)LEFT JOIN ps_tax_rules_group tr ON (p.id_tax_rules_group = tr.id_tax_rules_group)
WHERE p.id_product >= 526 AND p.id_product <= 526
UNION
SELECT "declinaison" type_req,
pa.id_product id_product,
pa.id_product_attribute id_product_attribute,
pa.price + p.price prix_vente,
pa.wholesale_price prix_achat,
p.reference reference,
pa.weight + p.weight weight,
pa.quantity quantity,
p.date_upd date_upd,
pl.name name,
pl.description_short description,
tr.name tax_rule
FROM ps_product_attribute pa
JOIN ps_product p ON (p.id_product=pa.id_product)
LEFT JOIN ps_product_lang pl ON (pl.id_product=pa.id_product AND pl.id_lang=1) LEFT JOINps_tax_rules_group tr ON (p.id_tax_rules_group = tr.id_tax_rules_group)
WHERE p.id_product >= 526 AND p.id_product <= 526 ORDER BY 1 |
