SHARE
TWEET

Untitled

a guest Oct 21st, 2019 68 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT
  2.     prods.`id` AS `ID`,
  3.     prods.`idWeb` AS `ID Web`,
  4.     prodsdc.`diseno` AS `Diseño`,
  5.     prodsdc.`color` AS `Cód. Color`,
  6.     prods.`nombre` AS `Título`,
  7.     cats.`idPadre`,
  8.     (
  9.         SELECT cats2.`nombre`
  10.         FROM categorias_web_profesional cats2
  11.         WHERE idCat = cats.`idPadre`
  12.     ) AS 'Cat. Padre',
  13.     prodcat.`idCategoria`,
  14.     cats.`nombre` AS 'Categoría'
  15.  
  16. FROM
  17.     productos_categorias_web_profesional prodcat
  18. LEFT JOIN
  19.     categorias_web_profesional cats
  20. ON
  21.     prodcat.`idCategoria` = cats.`idCat`
  22. LEFT JOIN
  23.     Productos prods
  24. ON
  25.     prodcat.`idProducto` = prods.`id`
  26. LEFT JOIN
  27.     Productos_diseno_color prodsdc
  28. ON
  29.     prodsdc.`idProducto` = prods.`id`
  30. ORDER BY
  31.     prods.`id` DESC;
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top