No valid database connection 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 'AND partkey != '' LIMIT 1000) as pa LEFT JOIN `broker_parts`.`' at line 16 SQL=CREATE TEMPORARY TABLE IF NOT EXISTS broker_history.search1 (`partkey` CHAR(40),`mfg` CHAR(24),`partsno` CHAR(20),`description` CHAR(64),`catid` INT(11),`category` CHAR(80),`img` CHAR(60),`prodid` INT(11),`sortcat` INT(11),`price` DOUBLE, `sellers_listing` INT(11), `featured` INT(11), INDEX (`sortcat`,`price`,`partkey`), PRIMARY KEY (`partkey`,`mfg`)) ENGINE=MEMORY SELECT pa.partkey, pa.mfg, pa.partsno, IF(prod.description IS NULL,pa.description,prod.description)description, categoryid as catid, '' as category, '' as img, productid as prodid, 0 as sortcat, (IF(MIN(`price`) <> '1e+16',ROUND(MIN(`price`),2) * 2,'1e+16')) as price, SUM(IF(pa.special=4,1,0)) as featured FROM (SELECT * FROM `broker_parts`.`partall` WHERE comp_id = AND partkey != '' LIMIT 1000) as pa LEFT JOIN `broker_parts`.`etilize_prods_short` as prod ON pa.partkey=prod.partkey AND pa.mfg=prod.mfg WHERE 1=1 AND prod.categoryid = 4799 GROUP BY pa.partkey,pa.mfg
No valid database connection Table 'broker_history.search1' doesn't exist SQL=SELECT * FROM broker_history.search1 ORDER BY sortcat DESC, price ASC, partkey ASC LIMIT 0, 12
No valid database connection Table 'broker_history.search1' doesn't exist SQL=SELECT * FROM broker_history.search1 ORDER BY sortcat DESC, price ASC, partkey ASC

Profile Page (Powered by Broker Exchange Network)