In Progress

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

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, [url removed, login to view] 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 [url removed, login to view] = '1' order by rand() DESC limit 12

[TEP STOP]

Must have good knowledge of oscommerce and programming.

Thanks

Skills: PHP, Script Install

See more: fix 1054 unknown column, fix 1054, tep stop 1054, rand programming, programming error, my fix, programming rand, unknown column clause join, unknown column project, unknown column clause fix, 1054 unknown column fixed, error php, desc

About the Employer:
( 40 reviews ) coulsdon, United Kingdom

Project ID: #210094

Awarded to:

imotion

Please check PMB...iMotion

$30 USD in 0 days
(120 Reviews)
6.4

5 freelancers are bidding on average $30 for this job

value4u

Hi, please check my PM. Thanks you.

$30 USD in 0 days
(274 Reviews)
8.2
NickolaS

Hi, please, check your PM

$30 USD in 0 days
(329 Reviews)
7.5
pentium10

Professional work from professionals!

$30 USD in 0 days
(223 Reviews)
6.8
anode

Please check PM. Thank you.

$30 USD in 1 day
(111 Reviews)
6.2