🚀 go-pugleaf

Tengo una funcion (del addon "star products" en oscommerce con mysql)
que huevea con este mensaje:

1054 - Unknown column 'p.products_id' in 'on clause'

select substring(pd.products_description, 1, 598) as
products_description, p.products_id, p.products_image,
p.manufacturers_id, p.products_price, IF(s.status,
s.specials_new_products_price, NULL) as specials_new_products_price,
IF(s.status, s.specials_new_products_price, p.products_price) as
final_price, p.products_tax_class_id, sp.product_id from products p,
products_description pd, star_product sp left join specials s on
p.products_id = s.products_id where p.products_id = pd.products_id and
p.products_status = '1' and pd.products_description != '' and
p.products_id=sp.product_id and pd.language_id = '3'


*******************************

La funcion causante del problema es esta:


tep_db_query("select substring(pd.products_description, 1, 598) as
products_description, p.products_id, p.products_image,
p.manufacturers_id, p.products_price, IF(s.status,
s.specials_new_products_price, NULL) as specials_new_products_price,
IF(s.status, s.specials_new_products_price, p.products_price) as
final_price, p.products_tax_class_id, sp.product_id from " .
TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " .
TABLE_STAR_PRODUCT . " sp left join " . TABLE_SPECIALS . " s on
p.products_id = s.products_id where p.products_id = pd.products_id and
p.products_status = '1' and pd.products_description != '' and
p.products_id=sp.product_id and pd.language_id = '" . $languages_id .
"'");


Ademas entiendo que se debe a la nueva version de php 5 se puso mas
estricta con la sintaxis. Pero no cacho como dejar el codigo para que
siga funcionando.