Products

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

select p2c.categories_id, p.products_model, pd.products_name, p.products_quantity, p.products_date_available, p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join specials s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '49' and YEAR( p.products_date_available) = '2012' AND MONTH( p.products_date_available) = '02' union select p2c.categories_id, p.products_model, pd.products_name, p.products_quantity, p.products_date_available, p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join specials s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '52' and YEAR( p.products_date_available) = '2012' AND MONTH( p.products_date_available) = '02' union select p2c.categories_id, p.products_model, pd.products_name, p.products_quantity, p.products_date_available, p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join specials s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '48' and YEAR( p.products_date_available) = '2012' AND MONTH( p.products_date_available) = '02'

[TEP STOP]

1062 - Duplicate entry '0508ede0da' for key 1

insert into sessions values ('0508ede0dad2f03644bbcf2af82e0088', '1328624879', 'cart|O:12:\"shoppingcart\":4:{s:8:\"contents\";a:0:{}s:5:\"total\";i:0;s:6:\"weight\";i:0;s:12:\"content_type\";b:0;}language|s:7:\"english\";languages_id|s:1:\"1\";currency|s:3:\"USD\";navigation|O:17:\"navigationhistory\":2:{s:4:\"path\";a:1:{i:0;a:4:{s:4:\"page\";s:9:\"index.php\";s:4:\"mode\";s:6:\"NONSSL\";s:3:\"get\";a:0:{}s:4:\"post\";a:0:{}}}s:8:\"snapshot\";a:0:{}}')

[TEP STOP]