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

IN PROGRESS
Bids
5
Avg Bid (USD)
$30
Project Budget (USD)
$30 - $100

Project Description:
Hello

I have an error on my site, i fixed the ones in the categories that had the same error, but im still getting this error when i have a subcategory.

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

select distinct p.products_id, p.products_image, p.products_tax_class_id, s.status as specstat, s.specials_new_products_price, p.products_price from products p left join specials s on p.products_id = s.products_id, products_to_categories p2c, categories c left join featured f on p.products_id = f.products_id where p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and c.parent_id = '81' and p.products_status = '1' and f.status = '1' order by rand() DESC limit 12

[TEP STOP]

Must have good knowledge of oscommerce and programming.

Thanks

Skills required:
PHP, Script Install
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$ 30
in 0 days
Hire NickolaS
$ 30
in 0 days
$ 30
in 0 days
Hire imotion
$ 30
in 0 days
Hire anode
$ 30
in 1 days