function getPicturesById($picId) { $sql = "SELECT *\r\n FROM camPictures pic\r\n INNER JOIN camSeminuevos sen\r\n ON sen.SEN_Id = pic.PIC_SEN_Id\r\n INNER JOIN camAgencias agn\r\n ON sen.SEN_AGN_Id = agn.AGN_Id\r\n WHERE PIC_SEN_Id = :picId\r\n GROUP BY PIC_Id\r\n "; getPicturesJSON($sql, $picId); }
function getPicturesById($picId) { $sql = "SELECT sen.*, agn.*,\r\n pic.PIC_Id,\r\n COALESCE(pic.PIC_Nombre, 'default_camcar.jpg') PIC_Nombre,\r\n COALESCE(pic.PIC_SEN_Id, 'default') PIC_Folder\r\n FROM (\r\n SELECT *\r\n FROM camSeminuevos\r\n WHERE SEN_Status = 1\r\n ) 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 LEFT JOIN camPictures pic\r\n ON sen.SEN_Id = pic.PIC_SEN_Id\r\n WHERE SEN_Id = :picId\r\n AND AGN_Id = 7\r\n "; getPicturesJSON($sql, $picId); }
function getPicturesById($picId) { $sql = "SELECT *, COALESCE(pic.PIC_Nombre, 'default_camcar.jpg') PIC_Nombre\r\n FROM camPictures pic\r\n INNER JOIN camSeminuevos sen\r\n ON sen.SEN_Id = pic.PIC_SEN_Id\r\n INNER JOIN camAgencias agn\r\n ON sen.SEN_AGN_Id = agn.AGN_Id\r\n WHERE PIC_SEN_Id = :picId\r\n GROUP BY PIC_Id\r\n "; getPicturesJSON($sql, $picId); }