|
|||||
 |
|||||
select p.products_image, pd.products_name, m.manufacturers_name, p.products_date_added, p.products_ordered, p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, 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 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 = '4' and p2c.categories_id = '472' order by final_price , pd.products_name limit -150, 30 [TEP STOP] 1062 - Duplicate entry '8b01a77d7ef17dd12f5abb73d3cea16c' for key 'PRIMARY' insert into sessions values ('8b01a77d7ef17dd12f5abb73d3cea16c', '1726880889', '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:8:\"japanese\";languages_id|s:1:\"4\";currency|s:3:\"JPY\";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:3:\"SSL\";s:3:\"get\";a:4:{s:6:\"osCsid\";s:32:\"8b01a77d7ef17dd12f5abb73d3cea16c\";s:5:\"cPath\";s:7:\"462_472\";s:4:\"sort\";s:2:\"5a\";s:4:\"page\";s:2:\"-4\";}s:4:\"post\";a:0:{}}}s:8:\"snapshot\";a:0:{}}') [TEP STOP] |
