exhibitionPeriod
string(7) "Current"
searchCritea
array(1) {
[0]=>
array(3) {
["libele"]=>
string(8) "Artist: "
["data"]=>
string(14) "André Juillard"
["field"]=>
string(6) "artist"
}
}
Artwork_search
string(1250) " AND artist.id = 168 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 (1329,4653,4657,4663,4668,4670,4671,4673,5219,5222,5223,5226,12527,17856,19947,19954,21828,21914,21919,21922,21924,21926,21935,21937,21943,21945,21947,21952,21962,24288,24291,28645,28646,28647,31771,35839,35873,35880,35933,36039,46460,46462,47147,47149,47151,47166,47173,47177,47179,47289,47290,47291,47292,47293,47294,47295,47296,47297,47298,47299,47300,47301,47302,47303,47304,47305,47306,47417,47418,47419,47420,47421,47422,47423,47424,47425,47427,47428,47429,47430,47431,47432,47433,47434,47435,47436,47437,47438,47439,47440,47450,47451,47452,47453,47454,47455,47456,47457,47458,47459,47460,47461,47462,47463,47464,47465,47466,47467,47468,47469,47470,47471,47472,47473,47474,47475,47476,47477,47478,47479,47480,47481,47482,47483,47484,47485,47486,47487,47488,47489,47491,47492,47493,47494,47529,47530,47550,47551,47554,47555,47556,47557,47558,47559,47561,47564,47570,47571,47578,47584,47586,47588,47589,47591,47592,47593,47595,47597,47598,47611,47639,47668,47682,47683) "
Artwork_sort
string(89) " ORDER BY artist.nom ASC,artist.prenom ASC, tbl_artwork.title ASC, tbl_artwork.year DESC "
sql_swipe
string(1724) "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 = 168 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 (1329,4653,4657,4663,4668,4670,4671,4673,5219,5222,5223,5226,12527,17856,19947,19954,21828,21914,21919,21922,21924,21926,21935,21937,21943,21945,21947,21952,21962,24288,24291,28645,28646,28647,31771,35839,35873,35880,35933,36039,46460,46462,47147,47149,47151,47166,47173,47177,47179,47289,47290,47291,47292,47293,47294,47295,47296,47297,47298,47299,47300,47301,47302,47303,47304,47305,47306,47417,47418,47419,47420,47421,47422,47423,47424,47425,47427,47428,47429,47430,47431,47432,47433,47434,47435,47436,47437,47438,47439,47440,47450,47451,47452,47453,47454,47455,47456,47457,47458,47459,47460,47461,47462,47463,47464,47465,47466,47467,47468,47469,47470,47471,47472,47473,47474,47475,47476,47477,47478,47479,47480,47481,47482,47483,47484,47485,47486,47487,47488,47489,47491,47492,47493,47494,47529,47530,47550,47551,47554,47555,47556,47557,47558,47559,47561,47564,47570,47571,47578,47584,47586,47588,47589,47591,47592,47593,47595,47597,47598,47611,47639,47668,47682,47683) AND tbl_artwork_multiple.premiere_dispo = 1 ORDER BY artist.nom ASC,artist.prenom ASC, tbl_artwork.title ASC, tbl_artwork.year DESC "
TOTAL ITEM SQL
NULL
TOTAL ITEM
int(1)
TOTAL PAGES
float(1)
sql
string(1717) "
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 = 168 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 (1329,4653,4657,4663,4668,4670,4671,4673,5219,5222,5223,5226,12527,17856,19947,19954,21828,21914,21919,21922,21924,21926,21935,21937,21943,21945,21947,21952,21962,24288,24291,28645,28646,28647,31771,35839,35873,35880,35933,36039,46460,46462,47147,47149,47151,47166,47173,47177,47179,47289,47290,47291,47292,47293,47294,47295,47296,47297,47298,47299,47300,47301,47302,47303,47304,47305,47306,47417,47418,47419,47420,47421,47422,47423,47424,47425,47427,47428,47429,47430,47431,47432,47433,47434,47435,47436,47437,47438,47439,47440,47450,47451,47452,47453,47454,47455,47456,47457,47458,47459,47460,47461,47462,47463,47464,47465,47466,47467,47468,47469,47470,47471,47472,47473,47474,47475,47476,47477,47478,47479,47480,47481,47482,47483,47484,47485,47486,47487,47488,47489,47491,47492,47493,47494,47529,47530,47550,47551,47554,47555,47556,47557,47558,47559,47561,47564,47570,47571,47578,47584,47586,47588,47589,47591,47592,47593,47595,47597,47598,47611,47639,47668,47682,47683) AND tbl_artwork_multiple.premiere_dispo = 1 ORDER BY artist.nom ASC,artist.prenom ASC, tbl_artwork.title ASC, tbl_artwork.year DESC
LIMIT 0, 16"
POST
NULL
GET
array(7) {
["lang"]=>
string(2) "en"
["page"]=>
string(5) "store"
["view"]=>
string(6) "unique"
["id"]=>
int(0)
["name"]=>
string(28) "huberty-breyne-gallery-store"
["?paged"]=>
string(0) ""
["artist"]=>
string(18) "andre-juillard-168"
}
exhib_search
string(0) ""
openFilter
bool(true)
artwork_ids
array(1) {
[0]=>
string(3) "549"
}
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 "
