exhibitionPeriod
string(4) "Past"
searchCritea
array(1) {
[0]=>
array(3) {
["libele"]=>
string(12) "Exhibition: "
["data"]=>
string(50) "Soda - Sketchbook-2 - édition avec dessin original"
["field"]=>
string(10) "exhibition"
}
}
Artwork_search
string(43) " AND tbl_exhib_artwork.id_exhibition='988' "
Artwork_sort
string(40) " ORDER BY tbl_exhib_artwork.n_ordre ASC "
sql_swipe
string(471) "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='988' ORDER BY tbl_exhib_artwork.n_ordre ASC LIMIT 8"
TOTAL ITEM SQL
NULL
TOTAL ITEM
string(2) "10"
TOTAL PAGES
float(2)
sql
string(626) "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='988' ORDER BY tbl_exhib_artwork.n_ordre ASC LIMIT 8, 8"
POST
NULL
GET
array(7) {
["lang"]=>
string(2) "en"
["page"]=>
string(5) "store"
["view"]=>
string(10) "exhibition"
["id"]=>
int(988)
["name"]=>
string(46) "soda-sketchbook-2-edition-avec-dessin-original"
["?paged"]=>
string(0) ""
["paged"]=>
string(1) "2"
}
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(5) "59031"
[1]=>
string(5) "59032"
[2]=>
string(5) "59033"
[3]=>
string(5) "59034"
[4]=>
string(5) "59035"
[5]=>
string(5) "59036"
[6]=>
string(5) "59037"
[7]=>
string(5) "59038"
}
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'
)
"
