Green Remove selection
 Effect color Remove selection
 Rubber paint Remove selection
Empty the search


File 1: /var/www/html/maston.fi/Maston/web/index.php
Line 1: 51
File 2: /var/www/html/maston.fi/Maston/web/libraries/cms/application/cms.php
Line 2: 265
File 3: /var/www/html/maston.fi/Maston/web/libraries/cms/application/site.php
Line 3: 230
File 4: /var/www/html/maston.fi/Maston/web/libraries/cms/application/site.php
Line 4: 191
File 5: /var/www/html/maston.fi/Maston/web/libraries/cms/component/helper.php
Line 5: 369
File 6: /var/www/html/maston.fi/Maston/web/libraries/cms/component/helper.php
Line 6: 394
File 7: /var/www/html/maston.fi/Maston/web/components/com_modulepage/modulepage.php
Line 7: 7
File 8: /var/www/html/maston.fi/Maston/web/libraries/legacy/controller/legacy.php
Line 8: 710
File 9: /var/www/html/maston.fi/Maston/web/libraries/legacy/controller/legacy.php
Line 9: 672
File 10: /var/www/html/maston.fi/Maston/web/components/com_modulepage/views/page/view.html.php
Line 10: 52
File 11: /var/www/html/maston.fi/Maston/web/modules/mod_modulemanager_region/helper.php
Line 11: 170
File 12: /var/www/html/maston.fi/Maston/web/libraries/joomla/document/renderer/html/module.php
Line 12: 93
File 13: /var/www/html/maston.fi/Maston/web/libraries/cms/module/helper.php
Line 13: 198
File 14: /var/www/html/maston.fi/Maston/web/modules/mod_macce/mod_macce.php
Line 14: 393
File 15: /var/www/html/maston.fi/Maston/web/modules/mod_macce/tmpl/color_browser.php
Line 15: 652
File 16: /var/www/html/maston.fi/Maston/web/modules/mod_macce/helper.php
Line 16: 103

Script: /index.php
Error: FUNCTION mursu.url_encode does not exist

SELECT pcol.color, pcol.color_filename, pcoltra.code
FROM MW_maston_fi_cat as c
JOIN MW_maston_fi_prod_cat as pc ON (pc.cat_type=c.type and pc.cat_id=c.id)
JOIN MW_maston_fi_products AS p ON (p.tuoteno=pc.tuoteno and p.osasto=10 and p.try!=702 AND p.try IN (190,192) and p.nimitys_fi not like '%pohjamaali%')
JOIN jos_maston_product_color as pcol ON (pcol.pupesoft_product_id=pc.tuoteno and pcol.color!='')
JOIN MW_maston_fi_cat as c2 ON (c2.type='color_type' and url_encode(c2.name_en) = 'effect-color' and c2.extra NOT LIKE '%"show_in_maalivalitsin":"0"%') JOIN MW_maston_fi_prod_cat as pc2 ON (pc2.tuoteno=pc.tuoteno and pc2.cat_type=c2.type and pc2.cat_id=c2.id)
LEFT JOIN jos_maston_product_color_translation as pcoltra ON (pcoltra.pupesoft_product_id=pcol.pupesoft_product_id and pcoltra.language='en-GB' and pcoltra.code!='')
WHERE c.type='color' and c.name_en='green' and c.extra NOT LIKE '%"show_in_maalivalitsin":"0"%'
GROUP BY pcol.color
ORDER BY pcol.color