>SELECT ec.cat_id, ec.cat_name, ec.cat_name_1, ev.ven_name, ev.ven_secname, ec_root.cat_secname AS PAR_AL, ec.cat_secname, ec.cat_finalurl2prd, 
> 	ep.prd_name, ep.prd_id, ep.prd_alias, ep.prd_active, ep.prd_status, ep.prd_virtstore, ep.prd_photo_sm, ep.prd_price, ep.prd_price_bfri, ep.prd_threshold_price, ep.prd_partnerprice, ep.prd_attribute
> ,ep.prd_del_date, ep.prd_cnt, ep.prd_cnt_store, ep.prd_cnt_east  FROM categories ec 
> INNER JOIN categories ec_root ON ec_root.cat_path=SUBSTRING(ec.cat_path,1,3) 
> INNER JOIN products ep ON ep.prd_cat_id=ec.cat_id 
> INNER JOIN vendors ev ON ep.prd_ven_id=ev.ven_id WHERE (ec.cat_active > 0 AND ev.ven_active > 0)  AND 
> 	ep.prd_cat_id='666' AND ep.prd_ven_id='1165' AND
> 	ep.prd_cat_id=ec.cat_id AND ep.prd_ven_id=ev.ven_id AND ep.prd_active > 0 AND
> 	ep.prd_id!='75310' AND 1980 >= ep.prd_price AND ep.prd_price >= 1320 and length(ep.prd_photo_sm) > 0
> 	ORDER BY rand() LIMIT 0, 6
Table 'komfortbt.categories' doesn't exist
Back