exhibitionPeriod
string(7) "Current"
searchCritea
array(2) {
[0]=>
array(3) {
["libele"]=>
string(8) "Artist: "
["data"]=>
string(16) "Matthias Lehmann"
["field"]=>
string(6) "artist"
}
[1]=>
array(3) {
["libele"]=>
string(12) "New artworks"
["data"]=>
string(12) "New artworks"
["field"]=>
string(11) "new_artwork"
}
}
Artwork_search
string(417) " AND artist.id = 3342 AND ( ( tbl_artwork.custom_field_8 <= DATE(NOW()) AND tbl_artwork.custom_field_8 !='0000-00-00' ) AND (tbl_artwork.custom_field_9 >= DATE(NOW()) OR tbl_artwork.custom_field_9 ='0000-00-00' )) AND tbl_artwork.type !='artwork' AND tbl_artwork.id NOT IN (34487,34503,34510,34879,34903,34907,34909,34913,49420,49421,49510,49511,49512,49513,49624,49625,49626,49634,49635,49764,49766,49767,49768) "
Artwork_sort
string(42) " ORDER BY tbl_artwork.custom_field_8 DESC "
sql_swipe
string(844) "SELECT DISTINCT tbl_artwork.id,tbl_artwork.id_artist,tbl_artwork.medium FROM tbl_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.premiere_dispo = 1
WHERE tbl_artwork.stock='on' AND artist.id = 3342 AND ( ( tbl_artwork.custom_field_8 <= DATE(NOW()) AND tbl_artwork.custom_field_8 !='0000-00-00' ) AND (tbl_artwork.custom_field_9 >= DATE(NOW()) OR tbl_artwork.custom_field_9 ='0000-00-00' )) AND tbl_artwork.type !='artwork' AND tbl_artwork.id NOT IN (34487,34503,34510,34879,34903,34907,34909,34913,49420,49421,49510,49511,49512,49513,49624,49625,49626,49634,49635,49764,49766,49767,49768) AND tbl_artwork_multiple.premiere_dispo = 1 ORDER BY tbl_artwork.custom_field_8 DESC "
TOTAL ITEM SQL
NULL
TOTAL ITEM
int(0)
TOTAL PAGES
float(0)
sql
string(837) "
SELECT DISTINCT
tbl_artwork.id
FROM tbl_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.premiere_dispo = 1
WHERE tbl_artwork.stock='on' AND artist.id = 3342 AND ( ( tbl_artwork.custom_field_8 <= DATE(NOW()) AND tbl_artwork.custom_field_8 !='0000-00-00' ) AND (tbl_artwork.custom_field_9 >= DATE(NOW()) OR tbl_artwork.custom_field_9 ='0000-00-00' )) AND tbl_artwork.type !='artwork' AND tbl_artwork.id NOT IN (34487,34503,34510,34879,34903,34907,34909,34913,49420,49421,49510,49511,49512,49513,49624,49625,49626,49634,49635,49764,49766,49767,49768) AND tbl_artwork_multiple.premiere_dispo = 1 ORDER BY tbl_artwork.custom_field_8 DESC
LIMIT 0, 16"
POST
NULL
GET
array(7) {
["lang"]=>
string(2) "en"
["page"]=>
string(5) "store"
["view"]=>
string(8) "editions"
["id"]=>
int(0)
["name"]=>
string(29) "huberty-breyne-store-editions"
["?paged"]=>
string(0) ""
["artist"]=>
string(21) "matthias-lehmann-3342"
}
exhib_search
string(0) ""
openFilter
bool(true)
artwork_ids
NULL
publicLeftJoin TEST FROM PC FIX
string(126) " LEFT JOIN tbl_artwork_multiple ON tbl_artwork_multiple.id_artwork=tbl_artwork.id AND tbl_artwork_multiple.premiere_dispo = 1 "