Kunst1.de

  • User warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'A=0'%')) )) count_alias' at line 18 query: SELECT COUNT(*) FROM (SELECT DISTINCT node.nid AS nid FROM node node LEFT JOIN content_type_product node_data_field_prod_partner ON node.vid = node_data_field_prod_partner.vid LEFT JOIN node node_node_data_field_prod_partner ON node_data_field_prod_partner.field_prod_partner_nid = node_node_data_field_prod_partner.nid LEFT JOIN content_type_product node_data_field_prod_artist ON node.vid = node_data_field_prod_artist.vid LEFT JOIN node node_node_data_field_prod_artist ON node_data_field_prod_artist.field_prod_artist_nid = node_node_data_field_prod_artist.nid INNER JOIN content_type_partner node_node_data_field_prod_partner_node_data_field_partner_campaign_active ON node_node_data_field_prod_partner.vid = node_node_data_field_prod_partner_node_data_field_partner_campaign_active.vid LEFT JOIN content_type_partner node_node_data_field_prod_partner__node_data_field_partner_valid_from ON node_node_data_field_prod_partner.vid = node_node_data_field_prod_partner__node_data_field_partner_valid_from.vid LEFT JOIN content_type_partner node_data_field_partner_valid_from ON node.vid = node_data_field_partner_valid_from.vid LEFT JOIN content_type_partner node_node_data_field_prod_partner__node_data_field_partner_spread_from ON node_node_data_field_prod_partner.vid = node_node_data_field_prod_partner__node_data_field_partner_spread_from.vid LEFT JOIN content_type_partner node_data_field_partner_spread_from ON node.vid = node_data_field_partner_spread_from.vid LEFT JOIN content_type_partner node_node_data_field_prod_partner__node_data_field_partner_valid_to ON node_node_data_field_prod_partner.vid = node_node_data_field_prod_partner__node_data_field_partner_valid_to.vid LEFT JOIN content_type_partner node_data_field_partner_valid_to ON node.vid = node_data_field_partner_valid_to.vid LEFT JOIN content_type_partner node_node_data_field_prod_partner__node_data_field_partner_valid_to2 ON node_node_data_field_prod_partner.vid = node_node_data_field_prod_partner__node_data_field_partner_valid_to2.vid LEFT JOIN content_type_product node_data_field_prod_image ON node.vid = node_data_field_prod_image.vid INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 1 AND na.realm = 'nodeaccess_rid') OR (na.gid = 0 AND na.realm = 'nodeaccess_uid') OR (na.gid = 0 AND na.realm = 'nodeaccess_author'))) AND ( (((node.type in ('product')) AND (node.status <> 0) AND (node_node_data_field_prod_partner_node_data_field_partner_campaign_active.field_partner_campaign_active_value = 'Y') AND (node_node_data_field_prod_partner.status <> 0)) AND ((DATE_FORMAT(node_node_data_field_prod_partner__node_data_field_partner_valid_from.field_partner_valid_from_value, '%Y-%m-%d\T%H:%i:%s') <= '2018-11-21T11:41:51') AND (DATE_FORMAT(node_node_data_field_prod_partner__node_data_field_partner_spread_from.field_partner_spread_from_value, '%Y-%m-%d\T%H:%i:%s') <= '2018-11-21T11:41:51'))) AND ((node_node_data_field_prod_partner__node_data_field_partner_valid_to.field_partner_valid_to_value IS NULL) OR (DATE_FORMAT(node_node_data_field_prod_partner__node_data_field_partner_valid_to2.field_partner_valid_to_value, '%Y-%m-%d\T%H:%i:%s') >= '2018-11-21T11:41:51')) AND (node.nid IN(SELECT si.sid FROM search_index AS si WHERE si.type = 'node' AND si.word LIKE '%m'A=0'%')) )) count_alias in _db_query() (line 146 of /var/www/vhosts/kunst1.de/httpdocs/includes/database.mysqli.inc).
  • User warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'A=0'%')) )ORDER BY node_data_field_prod_image_field_prod_clicks_count_value D' at line 40 query: SELECT DISTINCT node.nid AS nid, node_data_field_prod_image.field_prod_image_fid AS node_data_field_prod_image_field_prod_image_fid, node_data_field_prod_image.field_prod_image_list AS node_data_field_prod_image_field_prod_image_list, node_data_field_prod_image.field_prod_image_data AS node_data_field_prod_image_field_prod_image_data, node.type AS node_type, node.vid AS node_vid, node.title AS node_title, node_data_field_prod_image.field_prod_clicks_count_value AS node_data_field_prod_image_field_prod_clicks_count_value, node_data_field_prod_image.field_prod_oprice_amount AS node_data_field_prod_image_field_prod_oprice_amount, node_data_field_prod_image.field_prod_oprice_currency AS node_data_field_prod_image_field_prod_oprice_currency, node_data_field_prod_image.field_prod_price_amount AS node_data_field_prod_image_field_prod_price_amount, node_data_field_prod_image.field_prod_price_currency AS node_data_field_prod_image_field_prod_price_currency, node_data_field_prod_image.field_prod_link_value AS node_data_field_prod_image_field_prod_link_value, node_node_data_field_prod_partner__node_data_field_partner_valid_from.field_partner_logo_fid AS node_node_data_field_prod_partner__node_data_field_partner_valid_from_field_partner_logo_fid, node_node_data_field_prod_partner__node_data_field_partner_valid_from.field_partner_logo_list AS node_node_data_field_prod_partner__node_data_field_partner_valid_from_field_partner_logo_list, node_node_data_field_prod_partner__node_data_field_partner_valid_from.field_partner_logo_data AS node_node_data_field_prod_partner__node_data_field_partner_valid_from_field_partner_logo_data, node_node_data_field_prod_partner.nid AS node_node_data_field_prod_partner_nid, node_node_data_field_prod_partner.type AS node_node_data_field_prod_partner_type, node_node_data_field_prod_partner.vid AS node_node_data_field_prod_partner_vid, node_data_field_prod_image.field_prod_shipping_amount AS node_data_field_prod_image_field_prod_shipping_amount, node_data_field_prod_image.field_prod_shipping_currency AS node_data_field_prod_image_field_prod_shipping_currency, node_node_data_field_prod_artist.title AS node_node_data_field_prod_artist_title, node_node_data_field_prod_artist.nid AS node_node_data_field_prod_artist_nid FROM node node LEFT JOIN content_type_product node_data_field_prod_partner ON node.vid = node_data_field_prod_partner.vid LEFT JOIN node node_node_data_field_prod_partner ON node_data_field_prod_partner.field_prod_partner_nid = node_node_data_field_prod_partner.nid LEFT JOIN content_type_product node_data_field_prod_artist ON node.vid = node_data_field_prod_artist.vid LEFT JOIN node node_node_data_field_prod_artist ON node_data_field_prod_artist.field_prod_artist_nid = node_node_data_field_prod_artist.nid INNER JOIN content_type_partner node_node_data_field_prod_partner_node_data_field_partner_campaign_active ON node_node_data_field_prod_partner.vid = node_node_data_field_prod_partner_node_data_field_partner_campaign_active.vid LEFT JOIN content_type_partner node_node_data_field_prod_partner__node_data_field_partner_valid_from ON node_node_data_field_prod_partner.vid = node_node_data_field_prod_partner__node_data_field_partner_valid_from.vid LEFT JOIN content_type_partner node_data_field_partner_valid_from ON node.vid = node_data_field_partner_valid_from.vid LEFT JOIN content_type_partner node_node_data_field_prod_partner__node_data_field_partner_spread_from ON node_node_data_field_prod_partner.vid = node_node_data_field_prod_partner__node_data_field_partner_spread_from.vid LEFT JOIN content_type_partner node_data_field_partner_spread_from ON node.vid = node_data_field_partner_spread_from.vid LEFT JOIN content_type_partner node_node_data_field_prod_partner__node_data_field_partner_valid_to ON node_node_data_field_prod_partner.vid = node_node_data_field_prod_partner__node_data_field_partner_valid_to.vid LEFT JOIN content_type_partner node_data_field_partner_valid_to ON node.vid = node_data_field_partner_valid_to.vid LEFT JOIN content_type_partner node_node_data_field_prod_partner__node_data_field_partner_valid_to2 ON node_node_data_field_prod_partner.vid = node_node_data_field_prod_partner__node_data_field_partner_valid_to2.vid LEFT JOIN content_type_product node_data_field_prod_image ON node.vid = node_data_field_prod_image.vid INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 1 AND na.realm = 'nodeaccess_rid') OR (na.gid = 0 AND na.realm = 'nodeaccess_uid') OR (na.gid = 0 AND na.realm = 'nodeaccess_author'))) AND ( (((node.type in ('product')) AND (node.status <> 0) AND (node_node_data_field_prod_partner_node_data_field_partner_campaign_active.field_partner_campaign_active_value = 'Y') AND (node_node_data_field_prod_partner.status <> 0)) AND ((DATE_FORMAT(node_node_data_field_prod_partner__node_data_field_partner_valid_from.field_partner_valid_from_value, '%Y-%m-%d\T%H:%i:%s') <= '2018-11-21T11:41:51') AND (DATE_FORMAT(node_node_data_field_prod_partner__node_data_field_partner_spread_from.field_partner_spread_from_value, '%Y-%m-%d\T%H:%i:%s') <= '2018-11-21T11:41:51'))) AND ((node_node_data_field_prod_partner__node_data_field_partner_valid_to.field_partner_valid_to_value IS NULL) OR (DATE_FORMAT(node_node_data_field_prod_partner__node_data_field_partner_valid_to2.field_partner_valid_to_value, '%Y-%m-%d\T%H:%i:%s') >= '2018-11-21T11:41:51')) AND (node.nid IN(SELECT si.sid FROM search_index AS si WHERE si.type = 'node' AND si.word LIKE '%m'A=0'%')) )ORDER BY node_data_field_prod_image_field_prod_clicks_count_value DESC, node_title ASC LIMIT 0, 20 in _db_query() (line 146 of /var/www/vhosts/kunst1.de/httpdocs/includes/database.mysqli.inc).
  • User warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'A=0'%')) LEFT JOIN content_type_product AS ctpr ON(node.nid = ctpr.ni' at line 5 query: SELECT td.tid, td.vid, th.parent, td.name as tname, td.description, vc.name as vname,count(ctpr2.nid) as count FROM term_data AS td LEFT JOIN term_hierarchy AS th ON ( td.tid = th.tid ) LEFT JOIN term_node AS tn ON ( td.tid = tn.tid AND tn.tid IN(44,75,80,73,76,77,79,78,74) ) LEFT JOIN node AS node ON ( tn.nid = node.nid AND node.type = 'product' AND node.status <> 0 AND node.nid IN(SELECT si.sid FROM search_index AS si WHERE si.type = 'node' AND si.word LIKE '%m'A=0'%')) LEFT JOIN content_type_product AS ctpr ON(node.nid = ctpr.nid) LEFT JOIN content_type_partner AS ctpa ON(ctpr.field_prod_partner_nid = ctpa.nid AND ctpa.field_partner_valid_from_value <= now() AND (ctpa.field_partner_valid_to_value IS NULL OR ctpa.field_partner_valid_to_value >= now()) AND ctpa.field_partner_campaign_active_value = 'Y' AND ctpa.field_partner_spread_from_value IS NOT NULL AND ctpa.field_partner_spread_from_value <= now()) LEFT JOIN content_type_product AS ctpr2 ON(ctpr.nid = ctpr2.nid AND ctpa.nid IS NOT NULL) LEFT JOIN vocabulary AS vc ON ( td.vid = vc.vid ) WHERE (td.vid = 1 AND td.tid IN(44,75,80,73,76,77,79,78,74)) OR td.vid != 1 GROUP BY td.tid ORDER BY vc.weight, vc.vid, td.weight ASC , td.tid in _db_query() (line 146 of /var/www/vhosts/kunst1.de/httpdocs/includes/database.mysqli.inc).
Ihr Merkzettel!

Objekte pro Seite