Advertisement
campocreek

Untitled

Feb 9th, 2018
102
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.62 KB | None | 0 0
  1. SELECT
  2. seo_izdelie.id,
  3. seo_izdelie.name_short AS izdelie_name,
  4. seo_izdelie.alias AS izdelie_alias,
  5. 1 AS dok_rubrika_id,
  6. 26 AS podrubrika_id,
  7. "Запчасти для ТО" AS rubrika_name,
  8. "Запчасти для ТО" AS podrubrika_name,
  9. 1 AS `column`,
  10. 1 AS prior_pod,
  11. 1 AS rubrika_priority,
  12. seo_izdelie.rubrika_to AS izdelie_prior
  13. -- ,seo_izdelie.*
  14. ,dpr.id
  15. ,seo_izdelie.dok_podrubrika_id
  16. FROM
  17. seo_izdelie
  18. LEFT JOIN dok_podrubrica_2018 dpr ON seo_izdelie.dok_podrubrika_id = dpr.id
  19. WHERE
  20. seo_izdelie.rubrika_to IS NOT NULL
  21. AND seo_izdelie.dok_razdel_id IS NOT NULL
  22. AND seo_izdelie.is_hidden <> 1
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement