Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- prods.`id` AS `ID`,
- prods.`idWeb` AS `ID Web`,
- prodsdc.`diseno` AS `Diseño`,
- prodsdc.`color` AS `Cód. Color`,
- prods.`nombre` AS `Título`,
- cats.`idPadre`,
- (
- SELECT cats2.`nombre`
- FROM categorias_web_profesional cats2
- WHERE idCat = cats.`idPadre`
- ) AS 'Cat. Padre',
- prodcat.`idCategoria`,
- cats.`nombre` AS 'Categoría'
- FROM
- productos_categorias_web_profesional prodcat
- LEFT JOIN
- categorias_web_profesional cats
- ON
- prodcat.`idCategoria` = cats.`idCat`
- LEFT JOIN
- Productos prods
- ON
- prodcat.`idProducto` = prods.`id`
- LEFT JOIN
- Productos_diseno_color prodsdc
- ON
- prodsdc.`idProducto` = prods.`id`
- ORDER BY
- prods.`id` DESC;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement