exhibitionPeriod
string(7) "Current"
searchCritea
array(2) {
[0]=>
array(3) {
["libele"]=>
string(8) "Artist: "
["data"]=>
string(15) "Speedy Graphito"
["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(1592) " AND artist.id = 339 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,43129,43130,43131,43133,43134,43135,43138,43140,43141,43142,43143,43144,43145,43146,43147,43148,43151,43154,43156,43157,43158,43159,43160,43162,43163,43165,43166,43167,43169,43170,43171,43173,43175,43179,43180,43182,43183,43185,43186,43187,43188,43189,43190,43191,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,43459,43460,43461,43462,43463,43464,43491) "
Artwork_sort
string(42) " ORDER BY tbl_artwork.custom_field_8 DESC "
sql_swipe
string(2019) "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 = 339 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,43129,43130,43131,43133,43134,43135,43138,43140,43141,43142,43143,43144,43145,43146,43147,43148,43151,43154,43156,43157,43158,43159,43160,43162,43163,43165,43166,43167,43169,43170,43171,43173,43175,43179,43180,43182,43183,43185,43186,43187,43188,43189,43190,43191,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,43459,43460,43461,43462,43463,43464,43491) AND tbl_artwork_multiple.premiere_dispo = 1 ORDER BY tbl_artwork.custom_field_8 DESC "
TOTAL ITEM SQL
NULL
TOTAL ITEM
int(12)
TOTAL PAGES
float(1)
sql
string(2012) "
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 = 339 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,43129,43130,43131,43133,43134,43135,43138,43140,43141,43142,43143,43144,43145,43146,43147,43148,43151,43154,43156,43157,43158,43159,43160,43162,43163,43165,43166,43167,43169,43170,43171,43173,43175,43179,43180,43182,43183,43185,43186,43187,43188,43189,43190,43191,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,43459,43460,43461,43462,43463,43464,43491) 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(19) "speedy-graphito-339"
}
exhib_search
string(0) ""
openFilter
bool(true)
artwork_ids
array(12) {
[0]=>
string(5) "32861"
[1]=>
string(5) "32838"
[2]=>
string(5) "32834"
[3]=>
string(5) "32829"
[4]=>
string(5) "32837"
[5]=>
string(5) "32840"
[6]=>
string(5) "32845"
[7]=>
string(5) "32856"
[8]=>
string(5) "32857"
[9]=>
string(5) "32858"
[10]=>
string(5) "32859"
[11]=>
string(5) "32860"
}
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 "
