SELECT id_categorie as ID FROM categories WHERE slug = :slug<pre>array(1) {
  ["slug"]=>
  string(9) "motoneige"
}
</pre>SELECT a.id_parent,b.slug FROM categories a inner join categories b on a.id_parent = b.id_categorie WHERE a.id_categorie = :id_category<pre>array(1) {
  ["id_category"]=>
  string(2) "12"
}
</pre>SELECT nom FROM categories WHERE slug = :slug<pre>array(1) {
  ["slug"]=>
  string(9) "motoneige"
}
</pre>SELECT
localites.province,
localites.region,
regions.nom AS regionName,
regions.slug as regionSlug
FROM
localites
INNER JOIN regions ON localites.region = regions.region
WHERE localites.slug = :slug<pre>array(1) {
  ["slug"]=>
  string(15) "sainte-florence"
}
</pre>SELECT nom FROM regions WHERE slug = :slug<pre>array(1) {
  ["slug"]=>
  string(17) "Bas-Saint-Laurent"
}
</pre>SELECT id_localite as ID FROM localites WHERE slug = :slug and region = :region<pre>array(2) {
  ["slug"]=>
  string(15) "sainte-florence"
  ["region"]=>
  string(1) "1"
}
</pre>SELECT nom FROM localites WHERE slug = :slug<pre>array(1) {
  ["slug"]=>
  string(15) "sainte-florence"
}
</pre>CALL SP_SEARCH_VEHICLES_PREMIUM(
            :category,
            :subcategorie,
            :make,
            :model,
            :province,
            :region,
            :ville,
            :priceMin,
            :priceMax,
            :minYear,
            :maxYear,
            :minMileage,
            :maxMileage,
            :sort,
            :order,
            :start,
            :per_page,
            :status,
            :dealer
        )<pre>array(19) {
  ["category"]=>
  string(2) "12"
  ["subcategorie"]=>
  string(4) "Tous"
  ["make"]=>
  string(4) "Tous"
  ["model"]=>
  string(4) "Tous"
  ["province"]=>
  string(2) "QC"
  ["region"]=>
  string(1) "1"
  ["ville"]=>
  string(4) "7010"
  ["priceMin"]=>
  string(4) "Tous"
  ["priceMax"]=>
  string(4) "Tous"
  ["minYear"]=>
  string(4) "Tous"
  ["maxYear"]=>
  string(4) "Tous"
  ["minMileage"]=>
  string(4) "Tous"
  ["maxMileage"]=>
  string(4) "Tous"
  ["sort"]=>
  string(7) "annonce"
  ["order"]=>
  string(4) "desc"
  ["start"]=>
  int(0)
  ["per_page"]=>
  int(3)
  ["status"]=>
  string(4) "Tous"
  ["dealer"]=>
  string(4) "Tous"
}
</pre>CALL SP_SEARCH_VEHICLES_2(
            :category,
            :subcategorie,
            :make,
            :model,
            :province,
            :region,
            :ville,
            :priceMin,
            :priceMax,
            :minYear,
            :maxYear,
            :minMileage,
            :maxMileage,
            :sort,
            :order,
            :start,
            :per_page,
            :status,
            :dealer
        )<pre>array(19) {
  ["category"]=>
  string(2) "12"
  ["subcategorie"]=>
  string(4) "Tous"
  ["make"]=>
  string(4) "Tous"
  ["model"]=>
  string(4) "Tous"
  ["province"]=>
  string(2) "QC"
  ["region"]=>
  string(1) "1"
  ["ville"]=>
  string(4) "7010"
  ["priceMin"]=>
  string(4) "Tous"
  ["priceMax"]=>
  string(4) "Tous"
  ["minYear"]=>
  string(4) "Tous"
  ["maxYear"]=>
  string(4) "Tous"
  ["minMileage"]=>
  string(4) "Tous"
  ["maxMileage"]=>
  string(4) "Tous"
  ["sort"]=>
  string(7) "annonce"
  ["order"]=>
  string(4) "desc"
  ["start"]=>
  int(0)
  ["per_page"]=>
  string(2) "10"
  ["status"]=>
  string(4) "Tous"
  ["dealer"]=>
  string(4) "Tous"
}
</pre>init ->SQLSTATE[HY000]: General error: 1366 Incorrect integer value: 'Tous' for column 'V_STATUS' at row 1