exhibitionPeriod
string(7) "Current"
searchCritea
array(1) {
[0]=>
array(3) {
["libele"]=>
string(8) "Artist: "
["data"]=>
string(14) "François Avril"
["field"]=>
string(6) "artist"
}
}
Artwork_search
string(1885) " AND artist.id = 11 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 (41999,42000,42001,42002,42003,42004,42005,42006,42007,42008,42009,42010,42011,42012,42013,42014,42015,42016,42017,42018,42019,42020,42021,42022,42023,42024,42025,42026,42027,42028,42029,42030,42032,42033,42034,42035,42036,42037,42040,42145,42154,42155,42172,42310,42311,42312,42313,42314,42315,42316,42317,42318,42319,42320,42321,42323,42324,42598,42599,42600,42712,42714,42716,42718,42719,42720,42721,42722,42723,42724,42725,42726,42727,42728,42729,42730,42731,42732,42736,42737,42738,42740,42741,42742,42743,42744,42745,42746,42747,42748,42749,42751,42752,42753,42754,42755,42756,42757,42759,42760,42761,42801,42802,42803,42804,42805,42806,42807,42949,42953,42956,42957,42958,42959,42960,42963,42973,42974,42975,42978,42980,42981,43087,43090,43093,43095,43098,43109,43111,43114,43118,43120,43125,43128,43141,43143,43146,43159,43166,43170,43171,43173,43175,43186,43197,43217,43229,43308,43309,43310,43311,43312,43313,43314,43315,43316,43317,43318,43319,43320,43321,43322,43323,43327,43334,43335,43336,43337,43338,43339,43340,43341,43342,43343,43344,43345,43346,43347,43491,43624,43625,43626,43627,43628,43630,43631,43632,43633,43634,43635,43636,43637,43638,43639,43640,43642,43643,43644,43645,43646,43647,43648,43649,43650,43651,43652,43653,43654,43655,43656,43657,43658,43659,43660,43661,43662,43663,43664,43665,43666,43667,43668,43771,43772,43773,43774,43776,43777,43778,43779,43780,43781,43782,43783,43784,43785,43786,43787,43788,43789,43790,43792,43793,43794,43795,43796,43797,43799,43800,43801,43802,43807,43808,43809,43810,43811,43812,43813,43814,43815,43816,43817,43818,43819,43820,43821,43822,43824) "
Artwork_sort
string(89) " ORDER BY artist.nom ASC,artist.prenom ASC, tbl_artwork.title ASC, tbl_artwork.year DESC "
sql_swipe
string(2359) "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 = 11 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 (41999,42000,42001,42002,42003,42004,42005,42006,42007,42008,42009,42010,42011,42012,42013,42014,42015,42016,42017,42018,42019,42020,42021,42022,42023,42024,42025,42026,42027,42028,42029,42030,42032,42033,42034,42035,42036,42037,42040,42145,42154,42155,42172,42310,42311,42312,42313,42314,42315,42316,42317,42318,42319,42320,42321,42323,42324,42598,42599,42600,42712,42714,42716,42718,42719,42720,42721,42722,42723,42724,42725,42726,42727,42728,42729,42730,42731,42732,42736,42737,42738,42740,42741,42742,42743,42744,42745,42746,42747,42748,42749,42751,42752,42753,42754,42755,42756,42757,42759,42760,42761,42801,42802,42803,42804,42805,42806,42807,42949,42953,42956,42957,42958,42959,42960,42963,42973,42974,42975,42978,42980,42981,43087,43090,43093,43095,43098,43109,43111,43114,43118,43120,43125,43128,43141,43143,43146,43159,43166,43170,43171,43173,43175,43186,43197,43217,43229,43308,43309,43310,43311,43312,43313,43314,43315,43316,43317,43318,43319,43320,43321,43322,43323,43327,43334,43335,43336,43337,43338,43339,43340,43341,43342,43343,43344,43345,43346,43347,43491,43624,43625,43626,43627,43628,43630,43631,43632,43633,43634,43635,43636,43637,43638,43639,43640,43642,43643,43644,43645,43646,43647,43648,43649,43650,43651,43652,43653,43654,43655,43656,43657,43658,43659,43660,43661,43662,43663,43664,43665,43666,43667,43668,43771,43772,43773,43774,43776,43777,43778,43779,43780,43781,43782,43783,43784,43785,43786,43787,43788,43789,43790,43792,43793,43794,43795,43796,43797,43799,43800,43801,43802,43807,43808,43809,43810,43811,43812,43813,43814,43815,43816,43817,43818,43819,43820,43821,43822,43824) 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(31)
TOTAL PAGES
float(2)
sql
string(2352) "
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 = 11 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 (41999,42000,42001,42002,42003,42004,42005,42006,42007,42008,42009,42010,42011,42012,42013,42014,42015,42016,42017,42018,42019,42020,42021,42022,42023,42024,42025,42026,42027,42028,42029,42030,42032,42033,42034,42035,42036,42037,42040,42145,42154,42155,42172,42310,42311,42312,42313,42314,42315,42316,42317,42318,42319,42320,42321,42323,42324,42598,42599,42600,42712,42714,42716,42718,42719,42720,42721,42722,42723,42724,42725,42726,42727,42728,42729,42730,42731,42732,42736,42737,42738,42740,42741,42742,42743,42744,42745,42746,42747,42748,42749,42751,42752,42753,42754,42755,42756,42757,42759,42760,42761,42801,42802,42803,42804,42805,42806,42807,42949,42953,42956,42957,42958,42959,42960,42963,42973,42974,42975,42978,42980,42981,43087,43090,43093,43095,43098,43109,43111,43114,43118,43120,43125,43128,43141,43143,43146,43159,43166,43170,43171,43173,43175,43186,43197,43217,43229,43308,43309,43310,43311,43312,43313,43314,43315,43316,43317,43318,43319,43320,43321,43322,43323,43327,43334,43335,43336,43337,43338,43339,43340,43341,43342,43343,43344,43345,43346,43347,43491,43624,43625,43626,43627,43628,43630,43631,43632,43633,43634,43635,43636,43637,43638,43639,43640,43642,43643,43644,43645,43646,43647,43648,43649,43650,43651,43652,43653,43654,43655,43656,43657,43658,43659,43660,43661,43662,43663,43664,43665,43666,43667,43668,43771,43772,43773,43774,43776,43777,43778,43779,43780,43781,43782,43783,43784,43785,43786,43787,43788,43789,43790,43792,43793,43794,43795,43796,43797,43799,43800,43801,43802,43807,43808,43809,43810,43811,43812,43813,43814,43815,43816,43817,43818,43819,43820,43821,43822,43824) 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(20) "huberty-breyne-store"
["?paged"]=>
string(0) ""
["artist"]=>
string(17) "francois-avril-11"
}
exhib_search
string(0) ""
openFilter
bool(true)
artwork_ids
array(31) {
[0]=>
string(3) "616"
[1]=>
string(4) "2880"
[2]=>
string(5) "18372"
[3]=>
string(5) "18373"
[4]=>
string(5) "18374"
[5]=>
string(5) "34247"
[6]=>
string(5) "14033"
[7]=>
string(5) "34242"
[8]=>
string(5) "14035"
[9]=>
string(5) "37768"
[10]=>
string(4) "6414"
[11]=>
string(4) "2399"
[12]=>
string(5) "21554"
[13]=>
string(5) "20144"
[14]=>
string(4) "2584"
[15]=>
string(5) "21447"
[16]=>
string(5) "34342"
[17]=>
string(4) "2891"
[18]=>
string(5) "12415"
[19]=>
string(5) "34687"
[20]=>
string(5) "26778"
[21]=>
string(5) "34143"
[22]=>
string(5) "21428"
[23]=>
string(5) "34598"
[24]=>
string(4) "6432"
[25]=>
string(5) "26811"
[26]=>
string(5) "15821"
[27]=>
string(5) "34609"
[28]=>
string(5) "18516"
[29]=>
string(5) "13114"
[30]=>
string(5) "34141"
}
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 "