Kedvezmények

user warning: Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'hegyalja_n.quotes_res.code' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by query: SELECT DISTINCT n.nid FROM quotes q INNER JOIN node n ON q.vid=n.vid INNER JOIN content_type_color ctc ON q.vid=ctc.vid INNER JOIN (SELECT content_type_color.nid AS nid, IFNULL( res.ndate, CURDATE() - INTERVAL 1 YEAR ) AS ndate, IFNULL( res.code, content_type_color.field_color_id_value ) AS code, IFNULL( res.diff, TIMESTAMPDIFF( DAY, CURDATE() - INTERVAL 1 YEAR, NOW())) AS diff FROM content_type_color LEFT JOIN ( SELECT nid, MAX(ndate) AS ndate, CODE, TIMESTAMPDIFF(DAY, MAX(ndate), NOW()) AS diff FROM quotes_res GROUP BY nid ORDER BY nid ) res ON res.nid = content_type_color.nid WHERE content_type_color.field_color_inactive_value = 0 AND content_type_color.field_color_napi_exclude_value = 0 AND content_type_color.field_color_fb_value = 0 ORDER BY content_type_color.nid) qr ON n.vid = qr.nid INNER JOIN node_access na ON na.nid = n.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 0 AND na.realm = 'domain_site'))) AND ( n.status=1 AND n.type='color' AND ctc.field_color_inactive_value = 0 AND ctc.field_color_napi_exclude_value = 0 AND ctc.field_color_fb_value = 0 AND TIMESTAMPDIFF(DAY,qr.ndate,NOW()) > DAY(LAST_DAY(NOW())) AND q.promote = 1 AND 1=1 )ORDER BY RAND() LIMIT 0, 1 in /var/www/hegyalja.my-nailart.net/sites/all/modules/quotes/quotes.module on line 1378.
  • Napi árnyalat
    Hibrid (tartós) lakkozás
    20%
    Hibrid (tartós) lakkozás
    A weboldalon szereplő napi árnyalat igénybevétele.
  • Emlőrák ellen a nőkért
    Mindenki számára akinek fontos az emlőrák elleni harc.
    75%
    Hibrid (tartós) lakkozás
    A kampányban szereplő 3 exkluzív Gelish árnyalat valamelyikének igénybevétele. (személyenként és havonta maximum 2 kezelés.)
  • 60+ Újbuda
    60+ kártya tulajdonosok számára
    1.500 Ft.
    Pedikűr
    60+ kártya (lakcím kártya + igazolvány)