Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- seo_izdelie.id,
- seo_izdelie.name_short AS izdelie_name,
- seo_izdelie.alias AS izdelie_alias,
- 1 AS dok_rubrika_id,
- 26 AS podrubrika_id,
- "Запчасти для ТО" AS rubrika_name,
- "Запчасти для ТО" AS podrubrika_name,
- 1 AS `column`,
- 1 AS prior_pod,
- 1 AS rubrika_priority,
- seo_izdelie.rubrika_to AS izdelie_prior
- -- ,seo_izdelie.*
- ,dpr.id
- ,seo_izdelie.dok_podrubrika_id
- FROM
- seo_izdelie
- LEFT JOIN dok_podrubrica_2018 dpr ON seo_izdelie.dok_podrubrika_id = dpr.id
- WHERE
- seo_izdelie.rubrika_to IS NOT NULL
- AND seo_izdelie.dok_razdel_id IS NOT NULL
- AND seo_izdelie.is_hidden <> 1
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement