Skip to content

Latest commit

 

History

History
74 lines (65 loc) · 1.91 KB

README.md

File metadata and controls

74 lines (65 loc) · 1.91 KB
Raw

baanstudio 2021

-- project

field_year
field_venue
field_client
field_artist_link => link field
field_curator
field_project_medias => views

SELECT
	n.nid
	, n.title
	, n.created
	, n.changed
	, r.body
	, p.field_year_value AS 'year'
	, p.field_venue_value AS 'venue'
	, p.field_client_value AS 'client'
	, (
		SELECT
			GROUP_CONCAT(
				IF(a.field_artist_link_url IS NULL OR TRIM(a.field_artist_link_url) != '',
					CONCAT('[', a.field_artist_link_title, '](', a.field_artist_link_url , ')'),
					a.field_artist_link_title
				)
			)
		FROM
			content_field_artist_link a
		WHERE
			a.nid = n.nid
		GROUP BY nid

	) AS 'artists'
	, p.field_curator_value AS 'curator'
FROM
	node n
	LEFT OUTER JOIN content_type_project p ON n.nid = p.nid
	LEFT OUTER JOIN node_revisions r ON n.nid = r.nid
WHERE
	n.type = 'project'
ORDER BY
	p.field_year_value DESC;

이미지 비율

658x494 비율 1.331983806
4x3 비율 1.333333333
3x2 비율 1.5
원본 3000x2250

xs: < 576px => x_small:600x450
sm: > 576px => small:800x600
md: > 768px => medium:1000x750
lg: > 992px => large:1200x900
xlg:>1200px => x_large:2400x1800

upgrade to 10.2

drush eval "\Drupal::service('update.post_update_registry')->registerInvokedUpdates(['image_post_update_image_loading_attribute', 'image_post_update_image_loading_attribute']);"
drush eval "\Drupal::service('update.post_update_registry')->registerInvokedUpdates(['system_post_update_enable_provider_database_driver', 'system_post_update_enable_provider_database_driver']);"
drush eval "\Drupal::service('update.post_update_registry')->registerInvokedUpdates(['views_post_update_provide_revision_table_relationship', 'views_post_update_provide_revision_table_relationship']);"
drush eval "\Drupal::service('update.post_update_registry')->registerInvokedUpdates(['views_post_update_image_lazy_load', 'views_post_update_image_lazy_load']);"
drush updb -y && drush cr
drush cim -y