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 '*,orders.cusnum AS d_cusnum from
LEFT JOIN orders ON .ref = orders.ref
where .' at line 1
Shell | $ | |
---|---|---|
CHLAMYS DELICATULA |
15.00 | |
CYMATIUM LOTORIUM |
20.00 | |
XENOPHORA CEREA |
8.00 | |
CONUS VERDENSIS |
30.00 | |
VEXILLUM ALVINOBALANI |
8.00 | |
DOMIPORTA MANOUI |
80.00 | |
PILSBRYSPIRA ALBOCINCTA |
8.00 | |
LYNCINA ARGUS |
8.00 | |
CONUS SWAINSONI |
320.00 | |
MARGINELLA DENTICULATA |
6.00 | |
LYNCINA ARGUS VENTRICOSA |
50.00 | |
BABELOMUREX CENTIMANUS |
20.00 | |
ZONARIA ARABICULA |
8.00 | |
CRALLIOPHILLA MEYENDORFFI |
8.00 | |
MAURITIA ARABICA |
6.00 | |
MAURITIA ARABICA |
12.00 | |
CHLAMYS BULLATA |
6.00 | |
CANARIUM RADIANS |
6.00 | |
OLIVA ANNULATA CARNICOLOR |
6.00 | |
MAURITIA ARABICA |
8.00 | |
NEBULARIA LUCTUOSA |
3.00 | |
GLYCYMERIS RADIANS |
8.00 | |
Total: | 644.00 |