selinerdominik

undefined,filename,type,title,contributor1,contributor2,contributor3,contributor4,contributor5,contributor6,contributor7,contributor8,contributor9,contributor10,year
1,"Cara16b","Paper","Marea: a Semi-automatic Decision Support System for Breaking Dependency Cycles","Caracciolo, A.","Aga, B.","Lungu, M.","Nierstrasz, O.",,,,,,,"2016"
2,"Cara16c","Paper","Evaluating an Architecture Conformance Monitoring Solution","Caracciolo, A.","Lungu, M.","Truffer, O.","Levitin, K.","Nierstrasz, O.",,,,,,"2016"
3,"Nier16a-death-of-oop","Paper","The Death of Object-Oriented Programming","Nierstrasz, O.",,,,,,,,,,"2016"
4,"Osma16a","Paper","Tracking Null Checks in Open-Source Java Systems","Osman, H.","Leuenberger, M.","Lungu, M.","Nierstrasz, O.",,,,,,,"2016"
5,"Osma16b","Paper","Against the Mainstream in Bug Prediction","Osman, H.",,,,,,,,,,"2016"
6,"Schn16a","Paper","CuboidMatrix: Exploring Dynamic Structural Connections in Software Components using Space-Time Cube","Schneider, T.","Tymchuk, Y.","Salgado, R.","Bergel, A."

selinerdominik

$id_shop = 1;

selinerdominik

SELECT ppl.name, group_concat(al.name SEPARATOR ',') as attributes, pa.ean13, pa.supplier_reference
FROM ps_product AS pp, ps_product_lang AS ppl, ps_attribute_lang AS al, ps_product_attribute AS pa, ps_product_attribute_combination AS pac
WHERE pp.id_product = ppl.id_product
AND pp.id_product = pa.id_product
AND pa.id_product_attribute = pac.id_product_attribute
AND pac.id_attribute = al.id_attribute
AND ppl.id_lang =4
AND al.id_lang =4
AND id_supplier =5
GROUP BY pa.id_product_attribute