| |
|
|
|
|
|
|
| ORDER |
DISCOUNT |
 | 5% |
|
| |
|
|
|
|
select UNIX_TIMESTAMP(p.products_date_added) AS dateadd,p.products_id, p.products_model , pd.products_name, pd.products_brief_info, p.products_image, p.products_price, p.products_tax_class_id, p.products_date_added, m.manufacturers_name, 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 p left join specials s on p.products_id = s.products_id left join manufacturers m on (p.manufacturers_id = m.manufacturers_id), products_description pd , products_to_categories p2c where p2c.categories_id in (86, 87, 88, 219, 220, 221, 251, 319, 250, 253, 254, 259, 260, 323, 343, 222, 223, 241, 242, 245, 246, 248, 249, 324, 325, 339, 340, 341, 345, 224, 225, 244, 270, 275, 299, 300) and p2c.products_id = p.products_id and p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '1' order by p.products_date_added DESC, pd.products_name
1021 - Disk full (/tmp/#sql_2c2b_2.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
select UNIX_TIMESTAMP(p.products_date_added) AS dateadd,p.products_id, p.products_model , pd.products_name, pd.products_brief_info, p.products_image, p.products_price, p.products_tax_class_id, p.products_date_added, m.manufacturers_name, 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 p left join specials s on p.products_id = s.products_id left join manufacturers m on (p.manufacturers_id = m.manufacturers_id), products_description pd , products_to_categories p2c where p2c.categories_id in (86, 87, 88, 219, 220, 221, 251, 319, 250, 253, 254, 259, 260, 323, 343, 222, 223, 241, 242, 245, 246, 248, 249, 324, 325, 339, 340, 341, 345, 224, 225, 244, 270, 275, 299, 300) and p2c.products_id = p.products_id and p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '1' order by p.products_date_added DESC, pd.products_name
[TEP STOP]
|
