SupeSite info: MySQL Query Error

Time: 2026-7-26 4:02am
Script: /store.php

SQL:

SELECT SQL_CALC_FOUND_ROWS i.subject,i.itemid,g.thumb,g.image,c.name category,

  u2.spacename,g.price,i.uid,i.dateline,c.catid,g.recurring_frequency,

  g.is_artist_allowed,MATCH (subject) AGAINST ('Audiotraffic CD') score 

FROM supe_spaceitems i,supe_spacegoods g,supe_userspaces u2,supe_categories c 

WHERE i.itemid=g.itemid and i.uid=u2.uid and i.type='goods' and i.subtype='goods' and

   i.folder=1 and i.top=0 and i.dateline < unix_timestamp() and i.catid=c.catid and

   (MATCH (subject) AGAINST ('Audiotraffic CD') or u2.spacename like concat('Audiotraffic CD','%')) and

   i.itemid not in (428468) 

ORDER BY MATCH (subject) AGAINST ('Audiotraffic CD') desc,i.viewnum desc 

LIMIT 20