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 | $ | |
---|---|---|
VEXILLUM SANGUISUGUM CASTANEOSTICTA |
8.00 | |
DOSINIA CONCENTRICA |
3.00 | |
HALIOTIS RUFESCENS HATTORII |
85.00 | |
CALLISTA CHINENSIS |
8.00 | |
TELLINA ROSTRATA |
6.00 | |
ZONARIA ZONARIA |
8.00 | |
TIMOCLEA COSTELLIFERA |
6.00 | |
HALIOTIS ASININA |
8.00 | |
MARGINELLA DESJARDINI |
6.00 | |
STROMBUS CANARIUM |
6.00 | |
LAMBIS ADAMII |
8.00 | |
STROMBUS GIBBERULUS GIBBOSUS |
4.00 | |
MARGINELLA CLERYI |
12.00 | |
OVINOTIS OVINA |
8.00 | |
ANOMALOCARDIA AUBERIANA |
4.00 | |
TELLINELLA ALBINELLA |
4.00 | |
TELLINA ROSTRATA |
6.00 | |
SERRATINA CAPSOIDES |
4.00 | |
STROMBUS BULLA |
20.00 | |
CRYOTOSPIRA VENTRICOSA SINISTRAL |
85.00 | |
STROMBUS BULLA |
8.00 | |
MARGINELLA AMYGDALA |
4.00 | |
STROMBUS WILSONI |
8.00 | |
NERITA POLITA |
3.00 | |
NERITINA VIOLACEA |
4.00 | |
OLIVA OLIVA STELLATA |
4.00 | |
PLACAMEN LAMELLATUM |
12.00 | |
MARGINELLA CINGULATA |
4.00 | |
HALIOTIS ASININA |
8.00 | |
TELLINA cf VIRGATA |
3.00 | |
DOSINIA DISCUS |
5.00 | |
NERITA POLITA |
3.00 | |
TIMOCLEA COSTELLIFERA |
4.00 | |
MACOMA cf. SECTIOR |
6.00 | |
RHINOCLAVIS SINENSIS |
4.00 | |
CONUS AULICUS |
35.00 | |
Total: | 414.00 |