1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
| $sqlQuery = "SELECT publication.id, publication.title, publication.description, publication.gender, publication.age, publication.email, publication.tel1, publication.tel1Note, publication.tel2, publication.tel2Note, DATE(publication.creationDate) AS creationDate, activity.id AS activityId, activity.civicNo, activity.street, activity.idProvince, activity.idCountry, activity.postalCode, activity.day, TIME_FORMAT(activity.time, '%H:%i') AS time, activity.frequency, section.name".$_SESSION['siteLanguage']." AS sectionName, category.name".$_SESSION['siteLanguage']." AS categoryName, subCategory.name".$_SESSION['siteLanguage']." AS subCategoryName, city.name".$_SESSION['siteLanguage']."
FROM section,
category,
subCategory,
city,
publication LEFT JOIN activity ON publication.id = activity.idPublication
WHERE publication.delete = 'N'
AND publication.deleteDate = '0000-00-00 00:00:00'
AND publication.idSection = ".$this -> idSection."
AND publication.idCategory = ".$this -> idCategory."
AND publication.idSubCategory = ".$this -> idSubCategory."
AND publication.language = '".$_SESSION['siteLanguage']."'
AND section.id = publication.idSection
AND category.id = publication.idCategory
AND subCategory.id = publication.idSubcategory
AND city.id = activity.idCity
ORDER BY creationDate DESC LIMIT ".$this -> currentIndex.", ".$this -> publicationsPerPage.""; |
Partager