home
home
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 'ORDER BY pcs.size+0 LIMIT 100' at line 10
SELECT ss_edge,ss_body,ss_bell,ss_pattern,ss_roll,ss_choke,ss_chick,ss_closed,ss_open, weight, volume, sticksound, intensity, sustain, bellcharacter, soundcharacter, chicksound, mods.familyid, pcs.size, pcs.sizeid, mods.modelname, fams.familyname FROM product_cymbal_sizes as pcs, product_cymbal_families as fams, product_cymbal_models as mods WHERE mods.familyid=fams.familyid AND pcs.modelid=mods.modelid AND pcs.inactive=0 AND pcs.discontinued=0 AND mods.inactive=0 AND mods.discontinued=0 AND fams.inactive=0 AND fams.discontinued=0 AND mods.modelid= ORDER BY pcs.size+0