riccardocagnasso

Untitled

Nov 20th, 2013
158
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 3.39 KB | None | 0 0
  1. SELECT globo.codice AS globo_codice, globo.nome AS globo_nome, globo.tipo_globo_id AS globo_tipo_globo_id, globo.diametro_id AS globo_diametro_id, globo.famiglia_id AS globo_famiglia_id, globo.cartografia_id AS globo_cartografia_id, globo.base_id AS globo_base_id, globo.meridiano_id AS globo_meridiano_id, globo.luce_id AS globo_luce_id, globo.background_hash AS globo_background_hash, globo.picture_hash AS globo_picture_hash, globo.designer_name AS globo_designer_name, globo.onsale AS globo_onsale, globo.price AS globo_price, globo.paypalid AS globo_paypalid
  2. FROM globo LEFT OUTER JOIN select_value AS sq_famiglia ON globo.famiglia_id = sq_famiglia.id LEFT OUTER JOIN select_content AS sq_famiglia_content ON sq_famiglia.id = sq_famiglia_content.id LEFT OUTER JOIN select_value AS sq_tipo_globo ON globo.tipo_globo_id = sq_tipo_globo.id LEFT OUTER JOIN select_content AS sq_tipo_globo_content ON sq_tipo_globo.id = sq_tipo_globo_content.id LEFT OUTER JOIN select_value AS sq_diametro ON globo.diametro_id = sq_diametro.id LEFT OUTER JOIN select_content AS sq_diametro_content ON sq_diametro.id = sq_diametro_content.id LEFT OUTER JOIN select_value AS sq_cartografia ON globo.cartografia_id = sq_cartografia.id LEFT OUTER JOIN select_content AS sq_cartografia_content ON sq_cartografia.id = sq_cartografia_content.id LEFT OUTER JOIN select_value AS sq_base_globo ON globo.base_id = sq_base_globo.id LEFT OUTER JOIN select_content AS sq_base_globo_content ON sq_base_globo.id = sq_base_globo_content.id LEFT OUTER JOIN select_value AS sq_meridiano ON globo.meridiano_id = sq_meridiano.id LEFT OUTER JOIN select_content AS sq_meridiano_content ON sq_meridiano.id = sq_meridiano_content.id LEFT OUTER JOIN select_value AS sq_luce ON globo.luce_id = sq_luce.id LEFT OUTER JOIN select_content AS sq_luce_content ON sq_luce.id = sq_luce_content.id LEFT OUTER JOIN famiglia_to_collezione AS famiglia_to_collezione_1 ON sq_famiglia.id = famiglia_to_collezione_1.id_famiglia LEFT OUTER JOIN select_value AS sq_collezione ON famiglia_to_collezione_1.id_collezione = sq_collezione.id LEFT OUTER JOIN select_content AS sq_collezione_content ON sq_collezione_content.id = sq_collezione.id LEFT OUTER JOIN collezione_to_marchio AS collezione_to_marchio_1 ON sq_collezione.id = collezione_to_marchio_1.id_collezione LEFT OUTER JOIN select_value AS sq_marchio ON collezione_to_marchio_1.id_marchio = sq_marchio.id LEFT OUTER JOIN select_content AS sq_marchio_content ON sq_marchio_content.id = sq_marchio.id LEFT OUTER JOIN globo_description AS sq_globo_description ON globo.codice = sq_globo_description.codice_globo LEFT OUTER JOIN select_value ON select_value.id = globo.famiglia_id AND select_value.display = TRUE LEFT OUTER JOIN select_content AS select_content_1 ON select_value.id = select_content_1.id LEFT OUTER JOIN select_content AS select_content_2 ON select_value.id = select_content_2.id LEFT OUTER JOIN select_content AS select_content_3 ON select_value.id = select_content_3.id
  3. WHERE to_tsvector(CONCAT_WS(' ', nome, sq_famiglia_content.VALUE, sq_tipo_globo_content.VALUE, sq_globo_description.description, sq_diametro_content.VALUE, sq_cartografia_content.VALUE, sq_base_globo_content.VALUE, sq_meridiano_content.VALUE, sq_luce_content.VALUE, sq_collezione_content.VALUE, sq_marchio_content.VALUE)) @@ plainto_tsquery(%(searchquery)s) ORDER BY concat_ws(%(concat_ws_1)s, COALESCE(select_content_1.VALUE, select_content_2.VALUE, select_content_3.VALUE), globo.nome)
Advertisement
Add Comment
Please, Sign In to add comment