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 | $ | |
---|---|---|
MERETRIX LYRATA |
8.00 | |
BUFONARIA CRUMENA |
8.00 | |
CONASPRELLA TOINCABRALI |
80.00 | |
TEREBRA ALBOMARGINATA |
5.00 | |
CYPRAEA TIGRIS |
8.00 | |
BABELOMUREX CENTIMANUS |
25.00 | |
SPONDYLUS SWINNENI |
20.00 | |
TEREBRA ALBOMARGINATA |
8.00 | |
CARDITES BICOLOR |
4.00 | |
ENSIS SILIQUA |
6.00 | |
NERITA POLITA |
3.00 | |
CYPRAEA TIGRIS |
8.00 | |
HYDATINA ALBOCINCTA |
10.00 | |
HARPA ARTICULARIS |
20.00 | |
SPONDYLUS SWINNENI |
30.00 | |
FUSOLATIRUS RIKAE |
15.00 | |
CYPRAEA TIGRIS |
8.00 | |
ATYS CYLINDRICUS |
3.00 | |
ZAFRONA JASPIDEA |
3.00 | |
SASSIA SEMITORTA |
6.00 | |
CYPRAEA TIGRIS |
80.00 | |
SPONDYLUS SWINNENI |
20.00 | |
OLIVA TIGRINA |
4.00 | |
PAPHIA RHOMBOIDES |
4.00 | |
CONUS AMADIS NEPTUNUS |
12.00 | |
TECTUS PYRAMIS |
6.00 | |
LIOCONCHA SOWERBYI |
30.00 | |
MITRELLA SUDUIRAUTI |
6.00 | |
ENGINA MENDICARIA |
3.00 | |
UNEDOGEMMULA FRIEDRICHBONHOEFFERI |
25.00 | |
CLYPTOSPIRA DACTYLUS |
20.00 | |
DOSINIA SCALARIS |
6.00 | |
SPONDYLUS NICOBARICUS CILIATUS |
8.00 | |
MAURITIA EGLANTINA NIGER |
280.00 | |
TRIPIDOTURRIS FOSSATA NOTIALIS |
12.00 | |
SPONDYLUS REEVEI |
45.00 | |
Total: | 839.00 |