exhibitionPeriod
string(7) "Current"
searchCritea
array(1) {
[0]=>
array(3) {
["libele"]=>
string(8) "Artist: "
["data"]=>
string(15) "David Merveille"
["field"]=>
string(6) "artist"
}
}
Artwork_search
string(1886) " AND artist.id = 678 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(2360) "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 = 678 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(3)
TOTAL PAGES
float(1)
sql
string(2353) "
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 = 678 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(28) "huberty-breyne-gallery-store"
["?paged"]=>
string(0) ""
["artist"]=>
string(19) "david-merveille-678"
}
exhib_search
string(0) ""
openFilter
bool(true)
artwork_ids
array(3) {
[0]=>
string(5) "24283"
[1]=>
string(5) "39897"
[2]=>
string(5) "39898"
}
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 "
