Acest site foloseste cookie-uri pentru o mai buna experienta de vizitare. Prin continuarea navigarii, esti de acord cu modul de utilizare al acestor informatii.
SELECT DISTINCT productattributeid, value FROM (SELECT prodfilt.productid, productattributevalues.productattributeid, productattributevalues.value FROM ( SELECT productid FROM products WHERE charismacategoryid IN (51824, 51830, 51838, 51825, 51831, 51839, 51826, 51832, 51840, 51836, 51844, 51757, 51779, 156775, 156768, 156777, 156757, 156760, 156761, 156769) AND stock > 0 ) AS prodfilt INNER JOIN productattributevalues ON prodfilt.productid = productattributevalues.productid WHERE productattributevalues.productattributeid = 183 ) AS productlat;
SELECT DISTINCT productattributeid, value FROM (SELECT prodfilt.productid, productattributevalues.productattributeid, productattributevalues.value FROM ( SELECT productid FROM products WHERE charismacategoryid IN (51824, 51830, 51838, 51825, 51831, 51839, 51826, 51832, 51840, 51836, 51844, 51757, 51779, 156775, 156768, 156777, 156757, 156760, 156761, 156769) AND stock > 0 ) AS prodfilt INNER JOIN productattributevalues ON prodfilt.productid = productattributevalues.productid WHERE productattributevalues.productattributeid = 217 ) AS productlat;
SELECT DISTINCT productattributeid, value FROM (SELECT prodfilt.productid, productattributevalues.productattributeid, productattributevalues.value FROM ( SELECT productid FROM products WHERE charismacategoryid IN (51824, 51830, 51838, 51825, 51831, 51839, 51826, 51832, 51840, 51836, 51844, 51757, 51779, 156775, 156768, 156777, 156757, 156760, 156761, 156769) AND stock > 0 ) AS prodfilt INNER JOIN productattributevalues ON prodfilt.productid = productattributevalues.productid WHERE productattributevalues.productattributeid = 218 ) AS productlat;
SELECT DISTINCT productattributeid, value FROM (SELECT prodfilt.productid, productattributevalues.productattributeid, productattributevalues.value FROM ( SELECT productid FROM products WHERE charismacategoryid IN (51824, 51830, 51838, 51825, 51831, 51839, 51826, 51832, 51840, 51836, 51844, 51757, 51779, 156775, 156768, 156777, 156757, 156760, 156761, 156769) AND stock > 0 ) AS prodfilt INNER JOIN productattributevalues ON prodfilt.productid = productattributevalues.productid WHERE productattributevalues.productattributeid = 225 ) AS productlat;
SELECT DISTINCT productattributeid, value FROM (SELECT prodfilt.productid, productattributevalues.productattributeid, productattributevalues.value FROM ( SELECT productid FROM products WHERE charismacategoryid IN (51824, 51830, 51838, 51825, 51831, 51839, 51826, 51832, 51840, 51836, 51844, 51757, 51779, 156775, 156768, 156777, 156757, 156760, 156761, 156769) AND stock > 0 ) AS prodfilt INNER JOIN productattributevalues ON prodfilt.productid = productattributevalues.productid WHERE productattributevalues.productattributeid = 168 ) AS productlat;
SELECT DISTINCT productattributeid, value FROM (SELECT prodfilt.productid, productattributevalues.productattributeid, productattributevalues.value FROM ( SELECT productid FROM products WHERE charismacategoryid IN (51824, 51830, 51838, 51825, 51831, 51839, 51826, 51832, 51840, 51836, 51844, 51757, 51779, 156775, 156768, 156777, 156757, 156760, 156761, 156769) AND stock > 0 ) AS prodfilt INNER JOIN productattributevalues ON prodfilt.productid = productattributevalues.productid WHERE productattributevalues.productattributeid = 167 ) AS productlat;
SELECT DISTINCT productattributeid, value FROM (SELECT prodfilt.productid, productattributevalues.productattributeid, productattributevalues.value FROM ( SELECT productid FROM products WHERE charismacategoryid IN (51824, 51830, 51838, 51825, 51831, 51839, 51826, 51832, 51840, 51836, 51844, 51757, 51779, 156775, 156768, 156777, 156757, 156760, 156761, 156769) AND stock > 0 ) AS prodfilt INNER JOIN productattributevalues ON prodfilt.productid = productattributevalues.productid WHERE productattributevalues.productattributeid = 172 ) AS productlat;
SELECT DISTINCT productattributeid, value FROM (SELECT prodfilt.productid, productattributevalues.productattributeid, productattributevalues.value FROM ( SELECT productid FROM products WHERE charismacategoryid IN (51824, 51830, 51838, 51825, 51831, 51839, 51826, 51832, 51840, 51836, 51844, 51757, 51779, 156775, 156768, 156777, 156757, 156760, 156761, 156769) AND stock > 0 ) AS prodfilt INNER JOIN productattributevalues ON prodfilt.productid = productattributevalues.productid WHERE productattributevalues.productattributeid = 220 ) AS productlat;
SELECT DISTINCT productattributeid, value FROM (SELECT prodfilt.productid, productattributevalues.productattributeid, productattributevalues.value FROM ( SELECT productid FROM products WHERE charismacategoryid IN (51824, 51830, 51838, 51825, 51831, 51839, 51826, 51832, 51840, 51836, 51844, 51757, 51779, 156775, 156768, 156777, 156757, 156760, 156761, 156769) AND stock > 0 ) AS prodfilt INNER JOIN productattributevalues ON prodfilt.productid = productattributevalues.productid WHERE productattributevalues.productattributeid = 232 ) AS productlat;
SELECT DISTINCT productattributeid, value FROM (SELECT prodfilt.productid, productattributevalues.productattributeid, productattributevalues.value FROM ( SELECT productid FROM products WHERE charismacategoryid IN (51824, 51830, 51838, 51825, 51831, 51839, 51826, 51832, 51840, 51836, 51844, 51757, 51779, 156775, 156768, 156777, 156757, 156760, 156761, 156769) AND stock > 0 ) AS prodfilt INNER JOIN productattributevalues ON prodfilt.productid = productattributevalues.productid WHERE productattributevalues.productattributeid = 233 ) AS productlat;
SELECT DISTINCT productattributeid, value FROM (SELECT prodfilt.productid, productattributevalues.productattributeid, productattributevalues.value FROM ( SELECT productid FROM products WHERE charismacategoryid IN (51824, 51830, 51838, 51825, 51831, 51839, 51826, 51832, 51840, 51836, 51844, 51757, 51779, 156775, 156768, 156777, 156757, 156760, 156761, 156769) AND stock > 0 ) AS prodfilt INNER JOIN productattributevalues ON prodfilt.productid = productattributevalues.productid WHERE productattributevalues.productattributeid = 234 ) AS productlat;
SELECT DISTINCT productattributeid, value FROM (SELECT prodfilt.productid, productattributevalues.productattributeid, productattributevalues.value FROM ( SELECT productid FROM products WHERE charismacategoryid IN (51824, 51830, 51838, 51825, 51831, 51839, 51826, 51832, 51840, 51836, 51844, 51757, 51779, 156775, 156768, 156777, 156757, 156760, 156761, 156769) AND stock > 0 ) AS prodfilt INNER JOIN productattributevalues ON prodfilt.productid = productattributevalues.productid WHERE productattributevalues.productattributeid = 202 ) AS productlat;
SELECT DISTINCT productattributeid, value FROM (SELECT prodfilt.productid, productattributevalues.productattributeid, productattributevalues.value FROM ( SELECT productid FROM products WHERE charismacategoryid IN (51824, 51830, 51838, 51825, 51831, 51839, 51826, 51832, 51840, 51836, 51844, 51757, 51779, 156775, 156768, 156777, 156757, 156760, 156761, 156769) AND stock > 0 ) AS prodfilt INNER JOIN productattributevalues ON prodfilt.productid = productattributevalues.productid WHERE productattributevalues.productattributeid = 198 ) AS productlat;
SELECT DISTINCT productattributeid, value FROM (SELECT prodfilt.productid, productattributevalues.productattributeid, productattributevalues.value FROM ( SELECT productid FROM products WHERE charismacategoryid IN (51824, 51830, 51838, 51825, 51831, 51839, 51826, 51832, 51840, 51836, 51844, 51757, 51779, 156775, 156768, 156777, 156757, 156760, 156761, 156769) AND stock > 0 ) AS prodfilt INNER JOIN productattributevalues ON prodfilt.productid = productattributevalues.productid WHERE productattributevalues.productattributeid = 206 ) AS productlat;
SELECT DISTINCT productattributeid, value FROM (SELECT prodfilt.productid, productattributevalues.productattributeid, productattributevalues.value FROM ( SELECT productid FROM products WHERE charismacategoryid IN (51824, 51830, 51838, 51825, 51831, 51839, 51826, 51832, 51840, 51836, 51844, 51757, 51779, 156775, 156768, 156777, 156757, 156760, 156761, 156769) AND stock > 0 ) AS prodfilt INNER JOIN productattributevalues ON prodfilt.productid = productattributevalues.productid WHERE productattributevalues.productattributeid = 205 ) AS productlat;
SELECT DISTINCT productattributeid, value FROM (SELECT prodfilt.productid, productattributevalues.productattributeid, productattributevalues.value FROM ( SELECT productid FROM products WHERE charismacategoryid IN (51824, 51830, 51838, 51825, 51831, 51839, 51826, 51832, 51840, 51836, 51844, 51757, 51779, 156775, 156768, 156777, 156757, 156760, 156761, 156769) AND stock > 0 ) AS prodfilt INNER JOIN productattributevalues ON prodfilt.productid = productattributevalues.productid WHERE productattributevalues.productattributeid = 204 ) AS productlat;
SELECT DISTINCT productattributeid, value FROM (SELECT prodfilt.productid, productattributevalues.productattributeid, productattributevalues.value FROM ( SELECT productid FROM products WHERE charismacategoryid IN (51824, 51830, 51838, 51825, 51831, 51839, 51826, 51832, 51840, 51836, 51844, 51757, 51779, 156775, 156768, 156777, 156757, 156760, 156761, 156769) AND stock > 0 ) AS prodfilt INNER JOIN productattributevalues ON prodfilt.productid = productattributevalues.productid WHERE productattributevalues.productattributeid = 203 ) AS productlat;
SELECT DISTINCT productattributeid, value FROM (SELECT prodfilt.productid, productattributevalues.productattributeid, productattributevalues.value FROM ( SELECT productid FROM products WHERE charismacategoryid IN (51824, 51830, 51838, 51825, 51831, 51839, 51826, 51832, 51840, 51836, 51844, 51757, 51779, 156775, 156768, 156777, 156757, 156760, 156761, 156769) AND stock > 0 ) AS prodfilt INNER JOIN productattributevalues ON prodfilt.productid = productattributevalues.productid WHERE productattributevalues.productattributeid = 201 ) AS productlat;
SELECT DISTINCT productattributeid, value FROM (SELECT prodfilt.productid, productattributevalues.productattributeid, productattributevalues.value FROM ( SELECT productid FROM products WHERE charismacategoryid IN (51824, 51830, 51838, 51825, 51831, 51839, 51826, 51832, 51840, 51836, 51844, 51757, 51779, 156775, 156768, 156777, 156757, 156760, 156761, 156769) AND stock > 0 ) AS prodfilt INNER JOIN productattributevalues ON prodfilt.productid = productattributevalues.productid WHERE productattributevalues.productattributeid = 200 ) AS productlat;
SELECT DISTINCT productattributeid, value FROM (SELECT prodfilt.productid, productattributevalues.productattributeid, productattributevalues.value FROM ( SELECT productid FROM products WHERE charismacategoryid IN (51824, 51830, 51838, 51825, 51831, 51839, 51826, 51832, 51840, 51836, 51844, 51757, 51779, 156775, 156768, 156777, 156757, 156760, 156761, 156769) AND stock > 0 ) AS prodfilt INNER JOIN productattributevalues ON prodfilt.productid = productattributevalues.productid WHERE productattributevalues.productattributeid = 199 ) AS productlat;
SELECT DISTINCT productattributeid, value FROM (SELECT prodfilt.productid, productattributevalues.productattributeid, productattributevalues.value FROM ( SELECT productid FROM products WHERE charismacategoryid IN (51824, 51830, 51838, 51825, 51831, 51839, 51826, 51832, 51840, 51836, 51844, 51757, 51779, 156775, 156768, 156777, 156757, 156760, 156761, 156769) AND stock > 0 ) AS prodfilt INNER JOIN productattributevalues ON prodfilt.productid = productattributevalues.productid WHERE productattributevalues.productattributeid = 173 ) AS productlat;
SELECT DISTINCT productattributeid, value FROM (SELECT prodfilt.productid, productattributevalues.productattributeid, productattributevalues.value FROM ( SELECT productid FROM products WHERE charismacategoryid IN (51824, 51830, 51838, 51825, 51831, 51839, 51826, 51832, 51840, 51836, 51844, 51757, 51779, 156775, 156768, 156777, 156757, 156760, 156761, 156769) AND stock > 0 ) AS prodfilt INNER JOIN productattributevalues ON prodfilt.productid = productattributevalues.productid WHERE productattributevalues.productattributeid = 217 ) AS productlat;
SELECT DISTINCT productattributeid, value FROM (SELECT prodfilt.productid, productattributevalues.productattributeid, productattributevalues.value FROM ( SELECT productid FROM products WHERE charismacategoryid IN (51824, 51830, 51838, 51825, 51831, 51839, 51826, 51832, 51840, 51836, 51844, 51757, 51779, 156775, 156768, 156777, 156757, 156760, 156761, 156769) AND stock > 0 ) AS prodfilt INNER JOIN productattributevalues ON prodfilt.productid = productattributevalues.productid WHERE productattributevalues.productattributeid = 218 ) AS productlat;
SELECT DISTINCT productattributeid, value FROM (SELECT prodfilt.productid, productattributevalues.productattributeid, productattributevalues.value FROM ( SELECT productid FROM products WHERE charismacategoryid IN (51824, 51830, 51838, 51825, 51831, 51839, 51826, 51832, 51840, 51836, 51844, 51757, 51779, 156775, 156768, 156777, 156757, 156760, 156761, 156769) AND stock > 0 ) AS prodfilt INNER JOIN productattributevalues ON prodfilt.productid = productattributevalues.productid WHERE productattributevalues.productattributeid = 225 ) AS productlat;
SELECT DISTINCT productattributeid, value FROM (SELECT prodfilt.productid, productattributevalues.productattributeid, productattributevalues.value FROM ( SELECT productid FROM products WHERE charismacategoryid IN (51824, 51830, 51838, 51825, 51831, 51839, 51826, 51832, 51840, 51836, 51844, 51757, 51779, 156775, 156768, 156777, 156757, 156760, 156761, 156769) AND stock > 0 ) AS prodfilt INNER JOIN productattributevalues ON prodfilt.productid = productattributevalues.productid WHERE productattributevalues.productattributeid = 168 ) AS productlat;
SELECT DISTINCT productattributeid, value FROM (SELECT prodfilt.productid, productattributevalues.productattributeid, productattributevalues.value FROM ( SELECT productid FROM products WHERE charismacategoryid IN (51824, 51830, 51838, 51825, 51831, 51839, 51826, 51832, 51840, 51836, 51844, 51757, 51779, 156775, 156768, 156777, 156757, 156760, 156761, 156769) AND stock > 0 ) AS prodfilt INNER JOIN productattributevalues ON prodfilt.productid = productattributevalues.productid WHERE productattributevalues.productattributeid = 167 ) AS productlat;
SELECT DISTINCT productattributeid, value FROM (SELECT prodfilt.productid, productattributevalues.productattributeid, productattributevalues.value FROM ( SELECT productid FROM products WHERE charismacategoryid IN (51824, 51830, 51838, 51825, 51831, 51839, 51826, 51832, 51840, 51836, 51844, 51757, 51779, 156775, 156768, 156777, 156757, 156760, 156761, 156769) AND stock > 0 ) AS prodfilt INNER JOIN productattributevalues ON prodfilt.productid = productattributevalues.productid WHERE productattributevalues.productattributeid = 172 ) AS productlat;
SELECT DISTINCT productattributeid, value FROM (SELECT prodfilt.productid, productattributevalues.productattributeid, productattributevalues.value FROM ( SELECT productid FROM products WHERE charismacategoryid IN (51824, 51830, 51838, 51825, 51831, 51839, 51826, 51832, 51840, 51836, 51844, 51757, 51779, 156775, 156768, 156777, 156757, 156760, 156761, 156769) AND stock > 0 ) AS prodfilt INNER JOIN productattributevalues ON prodfilt.productid = productattributevalues.productid WHERE productattributevalues.productattributeid = 170 ) AS productlat;
Pe teritoriul României transportul se face în 24-48 ore de la confirmarea comenzii
Produsele comandate prin intermediul webshop-ului
beneficiează de 2 ani garanție
Pentru comenzile online oferim 14 zile în care se pot returna produsele comandate