Pleasure Crafts
- warning: Creating default object from empty value in /home/usagoods/public_html/modules/taxonomy/taxonomy.pages.inc on line 33.
- strict warning: Declaration of views_plugin_style_default::options() should be compatible with views_object::options() in /home/usagoods/public_html/sites/all/modules/views/plugins/views_plugin_style_default.inc on line 24.
- user warning: Expression #7 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'usagoods_drupal.node_data_field_image.field_image_fid' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
query: SELECT DISTINCT(node.nid) AS nid,
node_data_field_advertise.field_ad_text_value AS node_data_field_advertise_field_ad_text_value,
node_data_field_advertise.field_ad_text_format AS node_data_field_advertise_field_ad_text_format,
node.language AS node_language,
node.type AS node_type,
node.vid AS node_vid,
node_data_field_image.field_image_fid AS node_data_field_image_field_image_fid,
node_data_field_image.field_image_list AS node_data_field_image_field_image_list,
node_data_field_image.field_image_data AS node_data_field_image_field_image_data,
node_data_field_image.delta AS node_data_field_image_delta,
RAND() AS _random
FROM node node
LEFT JOIN content_field_image node_data_field_image ON node.vid = node_data_field_image.vid
LEFT JOIN content_type_portal_product node_data_field_advertise ON node.vid = node_data_field_advertise.vid
LEFT JOIN term_node term_node ON node.vid = term_node.vid
LEFT JOIN term_data term_data ON term_node.tid = term_data.tid
WHERE (node.type in ('portal_product')) AND (node_data_field_image.field_image_list <> 0) AND (node_data_field_advertise.field_advertise_value = 1) AND (term_data.vid in ('6'))
GROUP BY nid
ORDER BY _random ASC
LIMIT 0, 3 in /home/usagoods/public_html/sites/all/modules/views/includes/view.inc on line 807.
Ski Boats, Fishing Boats and Small Pleasure Boats
