Store - Expositions - Sélection Brafa 2026

exhibitionPeriod
bool(false)


searchCritea
array(1) {
  [0]=>
  array(3) {
    ["libele"]=>
    string(13) "Exposition : "
    ["data"]=>
    string(20) "Sélection Brafa 2026"
    ["field"]=>
    string(10) "exhibition"
  }
}


Artwork_search
string(44) " AND tbl_exhib_artwork.id_exhibition='1033' "


Artwork_sort
string(40) " ORDER BY tbl_exhib_artwork.n_ordre ASC "


sql_swipe
string(472) "SELECT tbl_artwork.id,tbl_artwork.id_artist,tbl_artwork.medium FROM tbl_artwork
     LEFT JOIN tbl_exhib_artwork ON tbl_artwork.id=tbl_exhib_artwork.id_artwork  
    LEFT JOIN tbl_contact AS artist ON (tbl_artwork.id_artist = artist.id)
    LEFT JOIN tbl_artwork_multiple ON tbl_artwork_multiple.id_artwork=tbl_artwork.id
    WHERE  tbl_exhib_artwork.published_artwork='on'  AND tbl_exhib_artwork.id_exhibition='1033'    ORDER BY tbl_exhib_artwork.n_ordre ASC  LIMIT 8"


TOTAL ITEM SQL
NULL


TOTAL ITEM
string(3) "187"


TOTAL PAGES
float(24)


sql
string(629) "SELECT DISTINCT tbl_artwork.id FROM tbl_artwork
     LEFT JOIN tbl_exhib_artwork ON tbl_artwork.id=tbl_exhib_artwork.id_artwork  
    LEFT JOIN tbl_contact AS artist ON (tbl_artwork.id_artist = artist.id)
     LEFT JOIN tbl_artwork_multiple ON tbl_artwork_multiple.id_artwork=tbl_artwork.id AND
    (
        tbl_artwork_multiple.state = 'Disponible'
        OR tbl_artwork_multiple.state = 'Vendue'
        OR tbl_artwork_multiple.state = 'Hors Galerie'
     )
     
    WHERE  tbl_exhib_artwork.published_artwork='on'  AND tbl_exhib_artwork.id_exhibition='1033'    ORDER BY tbl_exhib_artwork.n_ordre ASC  LIMIT 128, 8"


POST
NULL


GET
array(7) {
  ["lang"]=>
  string(2) "fr"
  ["page"]=>
  string(5) "store"
  ["view"]=>
  string(10) "exhibition"
  ["id"]=>
  int(1033)
  ["name"]=>
  string(20) "selection-brafa-2026"
  ["?paged"]=>
  string(0) ""
  ["paged"]=>
  string(2) "17"
}


exhib_search
string(77) " LEFT JOIN tbl_exhib_artwork ON tbl_artwork.id=tbl_exhib_artwork.id_artwork  "


openFilter
bool(false)


artwork_ids
array(8) {
  [0]=>
  string(4) "2874"
  [1]=>
  string(5) "60470"
  [2]=>
  string(4) "1955"
  [3]=>
  string(5) "52733"
  [4]=>
  string(5) "51228"
  [5]=>
  string(5) "54366"
  [6]=>
  string(5) "37602"
  [7]=>
  string(4) "2422"
}


 publicLeftJoin TEST FROM PC FIX
string(264) " LEFT JOIN tbl_artwork_multiple ON tbl_artwork_multiple.id_artwork=tbl_artwork.id AND
    (
        tbl_artwork_multiple.state = 'Disponible'
        OR tbl_artwork_multiple.state = 'Vendue'
        OR tbl_artwork_multiple.state = 'Hors Galerie'
     )
     "