function getCatalogoByMarc($marId) { $sql = "SELECT sen.*, tel.*, thm.PIC_Id,\r\n COALESCE(thm.PIC_Nombre, 'default_camcar.jpg') PIC_Nombre,\r\n COALESCE(thm.PIC_SEN_Id, 'default') PIC_Folder\r\n FROM (\r\n SELECT *\r\n FROM v_camSeminuevos\r\n WHERE SEN_Status = 1\r\n ) sen\r\n INNER JOIN camTelefonos tel\r\n ON sen.AGN_Id = tel.TEL_AGN_Id\r\n LEFT JOIN (\r\n SELECT *\r\n FROM camPictures\r\n WHERE PIC_Thum = 1\r\n ) thm\r\n ON sen.SEN_Id = thm.PIC_SEN_Id\r\n WHERE SEN_MAR_Id = :marId\r\n AND AGN_Id = 7\r\n ORDER BY MAR_Id\r\n "; getCatalogoJSON($sql, $marId); }
function getCatalogoByMarc($marId) { $sql = "SELECT *\r\n FROM v_camSeminuevos sen\r\n INNER JOIN camTelefonos tel\r\n ON sen.AGN_Id = tel.TEL_AGN_Id\r\n INNER JOIN (\r\n SELECT * \r\n FROM camPictures\r\n WHERE PIC_Thum = 1\r\n ) thm\r\n ON sen.SEN_Id = thm.PIC_SEN_Id\r\n WHERE SEN_MAR_Id = 2\r\n ORDER BY MAR_Id"; getCatalogoJSON($sql, $marId); }
function getCatalogoByMarc($marId) { $sql = "SELECT *\r\n FROM camSeminuevos sen\r\n INNER JOIN camAgencias agn\r\n ON sen.SEN_AGN_Id = agn.AGN_Id\r\n INNER JOIN camAGNTelefonos agntel\r\n ON agn.AGN_Id = agntel.TEL_AGN_Id\r\n INNER JOIN camCategorias cat\r\n ON sen.SEN_CAT_Id = cat.CAT_Id\r\n INNER JOIN camModelos mdo\r\n ON sen.SEN_MDO_Id = mdo.MDO_Id\r\n INNER JOIN camMarcas mrc\r\n ON sen.SEN_MAR_Id = mrc.MAR_Id\r\n INNER JOIN camThumbs thm\r\n ON sen.SEN_Id = thm.THM_Id\r\n WHERE SEN_MAR_Id = :marId\r\n ORDER BY MAR_Id\r\n "; getCatalogoJSON($sql, $marId); }
function getCatalogoByMarc($marId) { $sql = "SELECT *\r\n FROM camSeminuevos sen\r\n INNER JOIN (\r\n SELECT * \r\n FROM camAgencias\r\n WHERE AGN_Tipo = 0\r\n ) agn\r\n ON sen.SEN_AGN_Id = agn.AGN_Id\r\n INNER JOIN camTelefonos tel\r\n ON agn.AGN_Id = tel.TEL_AGN_Id\r\n INNER JOIN camCategorias cat\r\n ON sen.SEN_CAT_Id = cat.CAT_Id\r\n INNER JOIN camModelos mdo\r\n ON sen.SEN_MDO_Id = mdo.MDO_Id\r\n INNER JOIN camMarcas mrc\r\n ON sen.SEN_MAR_Id = mrc.MAR_Id\r\n INNER JOIN (\r\n SELECT * \r\n FROM camPictures\r\n WHERE PIC_Thum = 1\r\n ) thm\r\n ON sen.SEN_Id = thm.PIC_SEN_Id\r\n WHERE SEN_MAR_Id = :marId\r\n ORDER BY MAR_Id\r\n "; getCatalogoJSON($sql, $marId); }