Unknown column 'products_fulltext_myisam.product_id' in 'where clause'<BR><BR><PRE>SELECT SQL_CALC_FOUND_ROWS 	distinct(products.PRODUCT_ID), 
			products.PARENT_PRODUCT_ID, 
			substr(products.TITLE,1,10) AS TITLE, 
			substr(products.AUTHOR,1,10) AS AUTHOR, 
		       	products.SALES_RANK, 
			IFNULL(products.SALES_RANK, 'Z') as SALES_RANK_SORT,
		       	products.stock_qty_sold,  
			products_store.store_qty_sold,
			products.image_has_small as IMAGE_HAS_SMALL  FROM products left join products_store             on (products.product_id = products_store.product_id and products_store.store_id = 8246)  , products_fulltext_myisam_1  WHERE  products.store_id in (0, 8246)  AND  products.STORETYPE_ID1 = 'Y'  AND  (match (FT_TITLE, FT_AUTHOR, FT_ISBN, FT_UPC, FT_EAN, FT_MANUFACTURERS_CODE, FT_KEYWORDS, FT_PRODUCT_CONFIG, FT_PUBLISHER_NAME ) AGAINST ('+encouragement* ' IN BOOLEAN MODE)) and products.product_id = products_fulltext_myisam_1.product_id  AND  (match (FT_TITLE ) AGAINST ('+ENCOURAGEMENT* +BEAR ' IN BOOLEAN MODE))  and products.product_id = products_fulltext_myisam.product_id  AND  products.stock_available_flag in ('Y', 'P')  AND  (products.PRICE 				> 0 AND products.STATUS in ('A', 'B', 'C', 'M'))  AND ( products.product_id      not in (select product_term as product_id     from store_product_censor where censorship_type = 'PID' and store_product_censor.store_id = 8246) and  products.isbn            not in (select product_term as isbn           from store_product_censor where censorship_type = 'PIS' and store_product_censor.store_id = 8246) and  products.upc             not in (select product_term as upc            from store_product_censor where censorship_type = 'PUP' and store_product_censor.store_id = 8246) and  products.ean             not in (select product_term as ean            from store_product_censor where censorship_type = 'PEA' and store_product_censor.store_id = 8246) and  products.author          not in (select product_term as author         from store_product_censor where censorship_type = 'AU'  and store_product_censor.store_id = 8246) and  products.product_config  not in (select product_term as product_config from store_product_censor where censorship_type = 'PC'  and store_product_censor.store_id = 8246) and  products.publisher_name  not in (select product_term as publisher_name from store_product_censor where censorship_type = 'PUB' and store_product_censor.store_id = 8246) and  products.publisher       not in (select product_term as publisher      from store_product_censor where censorship_type = 'PUC' and store_product_censor.store_id = 8246) )  ORDER BY IMAGE_HAS_SMALL DESC, TITLE  LIMIT 1000 </PRE><BR><BR><BR>SELECT SQL_CALC_FOUND_ROWS 	distinct(products.PRODUCT_ID), 
			products.PARENT_PRODUCT_ID, 
			substr(products.TITLE,1,10) AS TITLE, 
			substr(products.AUTHOR,1,10) AS AUTHOR, 
		       	products.SALES_RANK, 
			IFNULL(products.SALES_RANK, 'Z') as SALES_RANK_SORT,
		       	products.stock_qty_sold,  
			products_store.store_qty_sold,
			products.image_has_small as IMAGE_HAS_SMALL  FROM products left join products_store             on (products.product_id = products_store.product_id and products_store.store_id = 8246)  , products_fulltext_myisam_1  WHERE  products.store_id in (0, 8246)  AND  products.STORETYPE_ID1 = 'Y'  AND  (match (FT_TITLE, FT_AUTHOR, FT_ISBN, FT_UPC, FT_EAN, FT_MANUFACTURERS_CODE, FT_KEYWORDS, FT_PRODUCT_CONFIG, FT_PUBLISHER_NAME ) AGAINST ('+encouragement* ' IN BOOLEAN MODE)) and products.product_id = products_fulltext_myisam_1.product_id  AND  (match (FT_TITLE ) AGAINST ('+ENCOURAGEMENT* +BEAR ' IN BOOLEAN MODE))  and products.product_id = products_fulltext_myisam.product_id  AND  products.stock_available_flag in ('Y', 'P')  AND  (products.PRICE 				> 0 AND products.STATUS in ('A', 'B', 'C', 'M'))  AND ( products.product_id      not in (select product_term as product_id     from store_product_censor where censorship_type = 'PID' and store_product_censor.store_id = 8246) and  products.isbn            not in (select product_term as isbn           from store_product_censor where censorship_type = 'PIS' and store_product_censor.store_id = 8246) and  products.upc             not in (select product_term as upc            from store_product_censor where censorship_type = 'PUP' and store_product_censor.store_id = 8246) and  products.ean             not in (select product_term as ean            from store_product_censor where censorship_type = 'PEA' and store_product_censor.store_id = 8246) and  products.author          not in (select product_term as author         from store_product_censor where censorship_type = 'AU'  and store_product_censor.store_id = 8246) and  products.product_config  not in (select product_term as product_config from store_product_censor where censorship_type = 'PC'  and store_product_censor.store_id = 8246) and  products.publisher_name  not in (select product_term as publisher_name from store_product_censor where censorship_type = 'PUB' and store_product_censor.store_id = 8246) and  products.publisher       not in (select product_term as publisher      from store_product_censor where censorship_type = 'PUC' and store_product_censor.store_id = 8246) )  ORDER BY IMAGE_HAS_SMALL DESC, TITLE  LIMIT 1000