exhibitionPeriod
string(7) "Current"
searchCritea
array(2) {
[0]=>
array(3) {
["libele"]=>
string(10) "Artiste : "
["data"]=>
string(11) "Milo Manara"
["field"]=>
string(6) "artist"
}
[1]=>
array(3) {
["libele"]=>
string(10) "Nouveautés"
["data"]=>
string(10) "Nouveautés"
["field"]=>
string(11) "new_artwork"
}
}
Artwork_search
string(1742) " AND artist.id = 189 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 (36350,36351,36354,51621,51622,51623,51624,51625,51626,51627,51628,51629,51630,52910,52911,52912,52913,52914,52915,52916,52917,52925,52926,52927,52928,52930,52931,52932,52933,52934,52935,52937,52938,52939,52940,52955,52956,52957,52958,52959,53287,53288,53289,53292,53295,53296,53297,53302,53303,53307,53309,53311,53318,53321,53323,53324,53325,53328,53331,53332,53333,53335,53336,53342,53344,53346,53348,53352,53353,53355,53356,53359,53361,53363,53365,53374,53375,53376,53377,53378,53379,53380,53381,53382,53383,53384,53385,53386,53387,53388,53389,53390,53391,53393,53395,53396,53397,53398,53399,53400,53401,53402,53403,53404,53405,53407,53408,53409,53410,53411,53412,53458,53466,53467,53471,53476,53478,53480,53481,53486,53487,53488,53491,53493,53497,53498,53499,53501,53502,53504,53505,53508,53511,53512,53514,53516,53527,53597,53598,53599,53600,53601,53602,53603,53640,53644,53697,53698,53699,53700,53701,53702,53703,53704,53705,53706,53756,53757,53759,53760,53771,53772,53773,53774,53775,53777,53778,53779,53780,53830,53847,53902,53903,53904,53905,53906,53907,53908,53918,53924,53925,53926,53927,53928,53929,53930,53931,53932,53933,53934,53935,53936,53937,53938,53941,53942,53943,53944,53945,53946,53947,53948,53949,53950,53951,53952,53953,53954,53955,53956,53957,53958,53959,53960,53961,53962,53963,53966,53967,53968,53969,53970,53971,53972,53973,53974,53975,53977,54063,54093,54098,54099,54100,54102,54106,54107,54108,54110,54111,54112,54134,54135,54136,54147) "
Artwork_sort
string(42) " ORDER BY tbl_artwork.custom_field_8 DESC "
sql_swipe
string(2169) "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 = 189 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 (36350,36351,36354,51621,51622,51623,51624,51625,51626,51627,51628,51629,51630,52910,52911,52912,52913,52914,52915,52916,52917,52925,52926,52927,52928,52930,52931,52932,52933,52934,52935,52937,52938,52939,52940,52955,52956,52957,52958,52959,53287,53288,53289,53292,53295,53296,53297,53302,53303,53307,53309,53311,53318,53321,53323,53324,53325,53328,53331,53332,53333,53335,53336,53342,53344,53346,53348,53352,53353,53355,53356,53359,53361,53363,53365,53374,53375,53376,53377,53378,53379,53380,53381,53382,53383,53384,53385,53386,53387,53388,53389,53390,53391,53393,53395,53396,53397,53398,53399,53400,53401,53402,53403,53404,53405,53407,53408,53409,53410,53411,53412,53458,53466,53467,53471,53476,53478,53480,53481,53486,53487,53488,53491,53493,53497,53498,53499,53501,53502,53504,53505,53508,53511,53512,53514,53516,53527,53597,53598,53599,53600,53601,53602,53603,53640,53644,53697,53698,53699,53700,53701,53702,53703,53704,53705,53706,53756,53757,53759,53760,53771,53772,53773,53774,53775,53777,53778,53779,53780,53830,53847,53902,53903,53904,53905,53906,53907,53908,53918,53924,53925,53926,53927,53928,53929,53930,53931,53932,53933,53934,53935,53936,53937,53938,53941,53942,53943,53944,53945,53946,53947,53948,53949,53950,53951,53952,53953,53954,53955,53956,53957,53958,53959,53960,53961,53962,53963,53966,53967,53968,53969,53970,53971,53972,53973,53974,53975,53977,54063,54093,54098,54099,54100,54102,54106,54107,54108,54110,54111,54112,54134,54135,54136,54147) AND tbl_artwork_multiple.premiere_dispo = 1 ORDER BY tbl_artwork.custom_field_8 DESC "
TOTAL ITEM SQL
NULL
TOTAL ITEM
int(39)
TOTAL PAGES
float(3)
sql
string(2162) "
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 = 189 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 (36350,36351,36354,51621,51622,51623,51624,51625,51626,51627,51628,51629,51630,52910,52911,52912,52913,52914,52915,52916,52917,52925,52926,52927,52928,52930,52931,52932,52933,52934,52935,52937,52938,52939,52940,52955,52956,52957,52958,52959,53287,53288,53289,53292,53295,53296,53297,53302,53303,53307,53309,53311,53318,53321,53323,53324,53325,53328,53331,53332,53333,53335,53336,53342,53344,53346,53348,53352,53353,53355,53356,53359,53361,53363,53365,53374,53375,53376,53377,53378,53379,53380,53381,53382,53383,53384,53385,53386,53387,53388,53389,53390,53391,53393,53395,53396,53397,53398,53399,53400,53401,53402,53403,53404,53405,53407,53408,53409,53410,53411,53412,53458,53466,53467,53471,53476,53478,53480,53481,53486,53487,53488,53491,53493,53497,53498,53499,53501,53502,53504,53505,53508,53511,53512,53514,53516,53527,53597,53598,53599,53600,53601,53602,53603,53640,53644,53697,53698,53699,53700,53701,53702,53703,53704,53705,53706,53756,53757,53759,53760,53771,53772,53773,53774,53775,53777,53778,53779,53780,53830,53847,53902,53903,53904,53905,53906,53907,53908,53918,53924,53925,53926,53927,53928,53929,53930,53931,53932,53933,53934,53935,53936,53937,53938,53941,53942,53943,53944,53945,53946,53947,53948,53949,53950,53951,53952,53953,53954,53955,53956,53957,53958,53959,53960,53961,53962,53963,53966,53967,53968,53969,53970,53971,53972,53973,53974,53975,53977,54063,54093,54098,54099,54100,54102,54106,54107,54108,54110,54111,54112,54134,54135,54136,54147) AND tbl_artwork_multiple.premiere_dispo = 1 ORDER BY tbl_artwork.custom_field_8 DESC
LIMIT 0, 16"
POST
NULL
GET
array(8) {
["lang"]=>
string(2) "fr"
["page"]=>
string(5) "store"
["view"]=>
string(8) "editions"
["id"]=>
int(0)
["name"]=>
string(29) "huberty-breyne-store-editions"
["?paged"]=>
string(0) ""
["artist"]=>
string(15) "milo-manara-189"
["paged"]=>
string(1) "1"
}
exhib_search
string(0) ""
openFilter
bool(true)
artwork_ids
array(39) {
[0]=>
string(5) "49766"
[1]=>
string(5) "49764"
[2]=>
string(5) "49767"
[3]=>
string(5) "49768"
[4]=>
string(5) "48546"
[5]=>
string(5) "44720"
[6]=>
string(5) "38707"
[7]=>
string(5) "38709"
[8]=>
string(5) "38711"
[9]=>
string(5) "37534"
[10]=>
string(5) "37536"
[11]=>
string(5) "28012"
[12]=>
string(5) "28029"
[13]=>
string(5) "28030"
[14]=>
string(5) "28031"
[15]=>
string(5) "28032"
[16]=>
string(5) "28033"
[17]=>
string(5) "28034"
[18]=>
string(5) "28035"
[19]=>
string(5) "13544"
[20]=>
string(5) "12267"
[21]=>
string(5) "30155"
[22]=>
string(5) "12271"
[23]=>
string(5) "13543"
[24]=>
string(5) "13546"
[25]=>
string(5) "12016"
[26]=>
string(5) "13547"
[27]=>
string(5) "12022"
[28]=>
string(5) "13548"
[29]=>
string(5) "12025"
[30]=>
string(5) "13550"
[31]=>
string(5) "12026"
[32]=>
string(5) "12027"
[33]=>
string(5) "12028"
[34]=>
string(5) "12029"
[35]=>
string(5) "12031"
[36]=>
string(5) "12034"
[37]=>
string(5) "12040"
[38]=>
string(5) "12256"
}
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 "