Climapark
0 Καλάθι Αγορών
Καλάθι Αγορών 0.00€
1055 - Expression #87 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'climapark_climdb.p2c.categories_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

select p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_weight, p.products_status, p.products_tax_class_id, p.manufacturers_id, p.products_ordered, p.products_oldprice, p.products_tax_class_id_oldprice, p.products_youtube, p.products_enable_seo, p.skroutz_enable, p.skroutz_mpn, p.skroutz_isbn, p.skroutz_sizes, p.intnum1, p.intnum2, p.intnum3, p.intnum4, p.intnum5, p.intnum6, p.doublenum1, p.doublenum2, p.doublenum3, p.doublenum4, p.doublenum5, p.doublenum6, p.booleannum1, p.booleannum2, p.booleannum3, p.booleannum4, p.booleannum5, p.booleannum6, p.booleannum7, p.booleannum8, p.booleannum9, p.booleannum10, p.datenum1, p.datenum2, p.datenum3, p.datenum4, p.datenum5, p.datenum6, p.products_table1, p.products_table2, p.products_table3, p.products_table4, p.products_table5, p.products_table6, p.file1, p.file2, p.file3, p.file4, p.file5, p.file6, p.file7, p.file8, pd.products_id, pd.language_id, pd.products_name, pd.products_description, pd.products_url, pd.products_viewed, pd.tags, pd.seo_title, pd.seo_description, pd.seo_keywords, pd.text1, pd.text2, pd.text3, pd.text4, pd.text5, pd.text6, pd.keimeno1, pd.keimeno2, pd.keimeno3, pd.keimeno4, pd.keimeno5, pd.keimeno6, p2c.products_id, p2c.categories_id, ptb1.table1_titlos, ptb2.table2_titlos, ptb3.table3_titlos, ptb4.table4_titlos, ptb5.table5_titlos, m.manufacturers_id, m.manufacturers_name, m.manufacturers_image, mi.manufacturers_id, mi.manufacturers_url, mi.manufacturers_titlos from products_description pd, products_to_categories p2c, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id left join products_table1 ptb1 on p.products_table1 = ptb1.products_table1_id and ptb1.language_id='1' left join products_table2 ptb2 on p.products_table2 = ptb2.products_table2_id and ptb2.language_id='1' left join products_table3 ptb3 on p.products_table3 = ptb3.products_table3_id and ptb3.language_id='1' left join products_table4 ptb4 on p.products_table4 = ptb4.products_table4_id and ptb4.language_id='1' left join products_table5 ptb5 on p.products_table5 = ptb5.products_table5_id and ptb5.language_id='1' left join manufacturers_info mi on m.manufacturers_id = mi.manufacturers_id and mi.languages_id='1' where p.products_status = '1' and p.products_id = pd.products_id and p.products_date_available <= '2024-03-29 7:11:28' and pd.language_id = '1' and p.products_id = p2c.products_id and p.booleannum2=1 group by p2c.products_id order by p.doublenum2 ASC, p.products_date_available DESC limit 0, 1000000

[TEP STOP]