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 | $ | |
---|---|---|
COLUMBELLA SCRIPTA |
3.00 | |
TURRIDRUPA BIJUBATA |
3.00 | |
PATELLA LONGICOSTA |
6.00 | |
STROMBUS BULLA |
8.00 | |
CORCULUM CARDISSA |
8.00 | |
HEMIPLECTA WICHMANNI |
8.00 | |
SPONDYLUS FOLIACEUS |
12.00 | |
POLINICES MAMMILLA |
4.00 | |
BABELOMUREX FINCHII |
60.00 | |
HALIOTIS SCALARIS |
20.00 | |
MARGINELLA ANSONAE |
4.00 | |
PACHYMELANIA cf. AURITA |
6.00 | |
MONETARIA MONETA |
3.00 | |
GIBBULA TURBINOIDES |
3.00 | |
AMPHIDROMUS PERVERSUS MELANOMA |
12.00 | |
SIMILILYRIA AIKENI AIKENI |
30.00 | |
PUSTULARIA CICERCULA |
8.00 | |
TEREBELLUM TEREBELLUM PUNCTULORUM |
6.00 | |
TECTARIUS PAGODUS |
12.00 | |
ENGINA MENDICARIA |
3.00 | |
OVINOTIS OVINA |
6.00 | |
STROMBUS FRAGILIS |
6.00 | |
HELICOSTYLA FLORIDA |
4.00 | |
HABROMORULA BICONICA |
6.00 | |
CONUS MITRATUS |
90.00 | |
TRACHYCARDIUM ELONGATUM ELONGATUM |
20.00 | |
Total: | 351.00 |