left start: 0.0274 sec left end: 0.322 sec listing start: 0.3623 sec listing end: 0.752 sec END: 0.7523 sec
select p.products_image1, p.description products_name , p.products_id, p.products_price,p.products_price_special, p.products_price final_price from products p , products_to_categories p2c where p.products_status = '1' and p.products_id = p2c.products_id and ( p2c.categories_id = '1037' or p2c.categories_id = '1038' or p2c.categories_id = '1039' or p2c.categories_id = '1040' or p2c.categories_id = '1041' or p2c.categories_id = '1042' or p2c.categories_id = '1043' or p2c.categories_id = '1044' or p2c.categories_id = '1045' or p2c.categories_id = '1046' or p2c.categories_id = '1047' or p2c.categories_id = '1048' or p2c.categories_id = '1049' or p2c.categories_id = '1050' or p2c.categories_id = '1051' or p2c.categories_id = '1052' or p2c.categories_id = '1053' or p2c.categories_id = '1054' or p2c.categories_id = '1055' or p2c.categories_id = '1056' or p2c.categories_id = '1057' or p2c.categories_id = '1058' or p2c.categories_id = '1059' or p2c.categories_id = '1060' or p2c.categories_id = '1061' or p2c.categories_id = '1062' or p2c.categories_id = '1063' or p2c.categories_id = '1064' or p2c.categories_id = '1065' or p2c.categories_id = '1066' or p2c.categories_id = '1067' or p2c.categories_id = '1068' or p2c.categories_id = '1069' or p2c.categories_id = '1070' or p2c.categories_id = '1071' or p2c.categories_id = '1072' or p2c.categories_id = '1073' or p2c.categories_id = '1074' or p2c.categories_id = '1075' or p2c.categories_id = '1076' or p2c.categories_id = '1077' or p2c.categories_id = '1078' or p2c.categories_id = '1079' or p2c.categories_id = '1080' or p2c.categories_id = '1081' or p2c.categories_id = '1082' or p2c.categories_id = '1083' or p2c.categories_id = '1084' or p2c.categories_id = '1085' or p2c.categories_id = '1086' or p2c.categories_id = '1087' or p2c.categories_id = '1088' or p2c.categories_id = '1089' or p2c.categories_id = '1090' or p2c.categories_id = '1091' or p2c.categories_id = '1092' or p2c.categories_id = '1093' or p2c.categories_id = '1094' or p2c.categories_id = '1095' or p2c.categories_id = '1096' or p2c.categories_id = '1097' or p2c.categories_id = '1098' or p2c.categories_id = '1099' or p2c.categories_id = '1100' or p2c.categories_id = '1101' or p2c.categories_id = '1102' or p2c.categories_id = '1103' or p2c.categories_id = '1104' or p2c.categories_id = '1105' or p2c.categories_id = '1106' or p2c.categories_id = '1107' or p2c.categories_id = '1108' or p2c.categories_id = '1109' or p2c.categories_id = '1110' or p2c.categories_id = '1111' or p2c.categories_id = '1112' or p2c.categories_id = '1113' or p2c.categories_id = '1114' or p2c.categories_id = '1115' or p2c.categories_id = '1116' or p2c.categories_id = '1117' or p2c.categories_id = '1118' or p2c.categories_id = '1119' or p2c.categories_id = '1120' or p2c.categories_id = '1121' or p2c.categories_id = '1122' or p2c.categories_id = '1123' or p2c.categories_id = '1124' or p2c.categories_id = '1125' or p2c.categories_id = '1126' or p2c.categories_id = '1127' or p2c.categories_id = '1128' or p2c.categories_id = '1129' or p2c.categories_id = '1130' or p2c.categories_id = '1131' or p2c.categories_id = '1132' or p2c.categories_id = '1133' or p2c.categories_id = '1134' or p2c.categories_id = '1135' or p2c.categories_id = '1136' or p2c.categories_id = '1137' or p2c.categories_id = '1138' or p2c.categories_id = '1139' or p2c.categories_id = '1140' or p2c.categories_id = '1141' or p2c.categories_id = '1142' or p2c.categories_id = '1143' or p2c.categories_id = '1144' or p2c.categories_id = '1145' or p2c.categories_id = '1146' or p2c.categories_id = '1147' or p2c.categories_id = '1148' or p2c.categories_id = '1149' or p2c.categories_id = '1150' or p2c.categories_id = '1151' or p2c.categories_id = '1152' or p2c.categories_id = '1153' or p2c.categories_id = '1154' or p2c.categories_id = '1155' or p2c.categories_id = '1156' or p2c.categories_id = '1157' or p2c.categories_id = '1158' or p2c.categories_id = '1159' or p2c.categories_id = '1160' or p2c.categories_id = '1161' or p2c.categories_id = '1162' or p2c.categories_id = '1163' or p2c.categories_id = '1164' or p2c.categories_id = '1165' or p2c.categories_id = '1166' or p2c.categories_id = '1167' or p2c.categories_id = '1168' or p2c.categories_id = '1169' or p2c.categories_id = '1170' or p2c.categories_id = '1171' or p2c.categories_id = '1172' or p2c.categories_id = '1173' or p2c.categories_id = '1174' or p2c.categories_id = '1175' or p2c.categories_id = '1176' or p2c.categories_id = '1177' or p2c.categories_id = '1178' or p2c.categories_id = '1179' or p2c.categories_id = '1180' or p2c.categories_id = '1181' or p2c.categories_id = '1182' or p2c.categories_id = '1183' or p2c.categories_id = '1184' or p2c.categories_id = '1185' or p2c.categories_id = '1186' or p2c.categories_id = '1187' or p2c.categories_id = '1188' or p2c.categories_id = '1189' or p2c.categories_id = '1190' or p2c.categories_id = '1191' ) group by products_id_group order by p.description